Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Thanks,

-Steve

Former Member
replied

Hi Steve,

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.

Regards,

Jitin Chawla

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question