Sage X3

I've got an issue where a negative value (say $10,000) exists in 'Amount Base Before' for the opening balance stock transaction on the Average Cost Evolution report. Eg. An opening balance loaded as a Misc Receipt worth $30,000 results in an Amount…

I am running the following Query, however when I run it, it does not output the delivery number. What am I missing.