Hi Andre,

The reason you don't see a total amount of items (excluding misc charges and taxes) on the Order Header is that this information is not stored there. Yes it would make this inquiry faster but it's not there. You have to use the Detail information (either in Order Entry or SalesAnalysis) to determine sales exclusive of misc charges and taxes.

And the data structure does store the Credit Note amounts as positive - only in custom reports/views does this get noticed. You have to create a formula (Calculated Column in GridView) that looks at the document type field and if it is "C" then multiply the amount by -1.

IF({Doc type} = "C",-{Total Dollar Value},{Total Dollar Value})