SAP B1 Reporting
Why Your SAP Business One Sales Report Doesn't Match
Two reports, two different sales totals, and a meeting spent arguing about which one is right. Here are the seven reasons this happens in SAP Business One, and how to make every report agree.
Rishad Ahmed · November 1, 2026 · 4 min read
It's one of the most common questions I hear from owners and controllers: "Why doesn't this report match SAP?" The saved query says one number, SAP's own Sales Analysis says another, and the Power BI dashboard says a third.
Usually nobody made a mistake. Each report is answering a slightly different question. Once you know the seven places where they quietly differ, you can make them agree, and keep them agreeing.
1. Cancelled Invoices Are Counted Twice
When you cancel an A/R invoice in SAP Business One, SAP doesn't delete it. It keeps the original and creates a new cancellation document that reverses it. In the invoice table (OINV), the field CANCELED tells them apart:
N: a normal invoiceY: the original invoice that was cancelledC: the cancellation document
A query that filters out only Y still counts the cancellation document, so the reversal shows up as negative sales. A query with no filter counts both. The fix is simple: keep only CANCELED = 'N'. That drops both halves of every cancellation.
2. Credit Memos Are Left Out
Returns and price corrections live in a different table: A/R credit memos (ORIN and its lines, RIN1). A report built only on invoices shows gross sales. If the figure you compare it to is net of returns, the gap is exactly your credit memos for the period.
To report net sales, add credit memo lines as negatives, for the same customer, item and period.
3. Freight Is Missing, or Repeated on Every Line
Freight and other document charges don't sit on the invoice lines. They're stored separately (INV3 for invoices, RIN3 for credit memos). This causes two opposite errors:
- A line-level report ignores freight entirely, so it comes in low.
- A report that joins freight to the lines repeats the same freight on every line, so it comes in high. A 10-line invoice with $50 of freight suddenly has $500.
Freight belongs at the document level: add it once per invoice, never per line.
4. The Document Discount Is Ignored
A discount entered at the bottom of the invoice is stored on the document header (DiscSum), not spread across the lines. Summing line totals alone overstates sales by the value of every document-level discount.
A document's net value, before tax, is roughly:
Sum of line totals
+ freight and other charges (once per document)
- document-level discount
5. Different Currencies
If you sell in more than one currency, check which one each report uses. In SAP B1, line totals are stored in your local currency. Sales Analysis can show amounts in local or system currency. If the report shows one and your query converts to the other, they'll never tie.
When you do convert, use the exchange rate for each document's date, not today's rate.
6. Different Date Fields
An SAP B1 document carries several dates, and they can fall in different months:
- Posting date (the
DocDatefield): the date that drives the accounting period - Document date (
TaxDate): often the date on the paper invoice - Due date (
DocDueDate)
An invoice posted on March 31 with a document date of April 2 lands in March in one report and April in another. Pick one date basis, usually posting date, and use it everywhere.
7. Service Lines Disappear
Invoices for services, or lines without an item, have no item code. A report that joins invoice lines to the item master and requires a match quietly drops those lines. If you bill installation, labour or handling as service lines, an item-based sales report will always come in low.
How to Make Your Reports Agree
Pick SAP's Sales Analysis report as your reference, because it's the number your finance team already trusts. Then check each report against it with the same settings:
- Same period, using the same date field.
- Same currency setting.
- Credit memos treated the same way in both: netted or excluded.
- Cancelled originals and cancellation documents both excluded.
- Freight and document discounts at document level, not per line.
- Service and non-item lines included.
Once a report ties out, keep a small reconciliation check next to it: one figure from your report, one from SAP, and the difference. When that difference is zero, nobody has to argue about the numbers again.
A quick test you can run today: take one month, run Sales Analysis in local currency, and compare it to your sales report for the same month. If they differ, the size of the gap usually points straight to the cause: about the value of your returns means credit memos, a round multiple of freight means repeated freight, and a negative swing means cancellation documents.