Incorrect totals on sales report

Dec 03, 2007 1 Replies

Hi



I'm running a standard detailed sales report, I have an item that was sold and returned on the same day. It is showing on the report quantity and a plus then minus figure, but on the amount it is showing as a plus figure, throwing out my totals by 1600. Any suggestions?



I have used another test database and run the same query and the totals are fine, so this seems to be specific to this data.


Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required