3784603 - Difference in VAT Amount Between Sales Order, Customer Invoice, and Customer Credit Memo Due to Tax Difference Distribution and Rounding Off

There is a differences in the VAT amount between a Sales Order, Customer Invoice, and Customer Credit Memo although the same item, quantity, price, and tax rate are used.

Examples include:

• The VAT amount in the Sales Order differs by 0.01 EUR from the expected calculation.
• The Customer Invoice shows a different VAT amount than the originating Sales Order.
• A Customer Credit Memo created for a returned item contains a VAT amount that differs from the original invoice.
• The VAT amount on the credit memo does not exactly match the VAT amount of the corresponding invoice line item.

This may result in apparent discrepancies when comparing commercial documents.

Example

Net Amount: 3,674.00 EUR
Tax Rate: 23%
Mathematical VAT: 845.02 EUR
System Calculated VAT:
Sales Order: 845.01/845.02 EUR
Customer Invoice: 845.00 EUR
Credit Memo: 845.02 EUR

SAP Business ByDesign

1. Create a Sales Order.
2. Add multiple taxable line items.
3. Maintain the quantity, net price.
4. Save the Sales Order.
5. Navigate to the Taxes tab and note the calculated VAT amount.
6. Create a Customer Invoice from the Sales Order.
7. Compare the VAT amount on the invoice with the Sales Order.
8. Create a Customer Credit Memo for one or more invoice items.
9. Compare the VAT amount in the credit memo with the original invoice.

A difference of one or more currency unit may be observed.

In SAP Business ByDesign, tax is calculated at both the item level and the document (header) level.

At the item level, tax is calculated separately for each line item and rounded according to the decimal precision of the document currency.
At the document level, tax is calculated using the aggregated taxable amount for all relevant items and then rounded.

Because rounding is performed differently at these two levels, the total of the rounded item tax amounts may differ from the rounded document-level tax amount by one or more currency units of the minimum rounding value (for example, 0.01 EUR).

This difference is expected because tax is calculated and rounded at both the item level and the document level. If a rounding difference occurs, SAP Business ByDesign automatically distributes the rounding difference across the document items using the standard Tax Difference Distribution logic.

The distribution is performed using the standard Rule of Three algorithm:

1. Proportional Distribution Rule – The system first distributes the tax difference proportionally across the item tax amounts based on each item's contribution to the total tax.
2. Minimum Amount Distribution Rule – If a remainder still exists after proportional distribution, the system distributes the minimum currency unit (for example, 0.01 EUR) across the document items until the remaining difference is reduced.
3. Remainder Distribution Rule – If a residual difference still remains, it is assigned to the item with the highest tax amount.

Each business document (for example, Sales Order, Customer Invoice, and Customer Credit Memo) performs its own tax calculation using this standard logic. Since the item composition, document structure, and applicable tax distribution may differ between documents, the rounding difference can be assigned to different line items. Consequently, related documents may show VAT differences of one or two cents even when the same quantities, prices, and tax rates are used.

This behavior is by design and ensures that the document-level tax remains mathematically correct while maintaining consistency with accounting requirements and currency rounding rules.

The observed VAT difference is expected system behavior resulting from the standard tax calculation and tax difference distribution logic in SAP Business ByDesign.

Rules of Tax Difference Distribution in SAP Busine... - SAP Community

VAT; Rounding Off; Invoice; Credit Memo; Tax Distribution; Calculated; Sales Order; Customer Invoice , KBA , SRD-CRM-ORD , Orders & Contracts , Problem