Query vs Sales Analysis Report
I wrote a query that does virtually the same thing as a sales analysis report -- add up all invoice totals and calculate a gross sales number.
In the sales analysis report ItemXXX has a total sales of $1456.94
My query ItemXXX has a total sales of $1457.73
A $.79 discrepancy which I assumed was a result of the fact that my query doesn't include A/R Credit Memos. Only some items have this discrepancy.
The problem is that if I do an inventory posting list on the item there are no A/R Credit Memos listed. Only A/R Invoices, A/P Invoices, and A/P Goods Receipts.
What other documents could be affecting this number? Any other things that could be causing this?
Jitin Chawla replied
A possible cause of the difference can be rounding. When you run the Sales Analysis report then in the Business One the amounts are displayed rounded to the decimal settings mentioned in the settings.
However, when you run the same from the Query, the same will take the decimals to 6 places and the same is giving you a difference between the two reports.