SAP Knowledge Base Article - Public

3373026 - The Tax amount is Showing Different for Invoice Items with Same Net Amount

Symptom

You have created a supplier invoice with multiple line items which have same net amount but the tax is showing different for each line(with a minor difference in decimal places).

Environment

SAP Business By Design

Reproducing the Issue

  1. Go to Supplier Invoicing work center
  2. Create a new supplier invoice from common tasks view
  3. Enter 2 line items with same price (say price is X) for each item
  4. However, the tax amount which got calculated is showing different for both items (a minor difference in decimal points)

Cause

On header level the total amount calculated for tax is P.QR (gross tax amount) , which is Y% of gross amount rounded to 2 decimal places. 

Now, individually at item level, when we calculate the tax,

Tax:

Line item 1: Y % of X =P.QRXT

Line item 2: Y % of X =P.QRXT

Now if we round both the items equally to P.QR and add them up, then total tax becomes little more or less than the actual gross tax amount.

So, the tax amounts in the item level differ by a small amount in order to add up to the calculated header tax amount.

Resolution

So, to balance the header tax amount, one line item shows a minor difference in the tax e.g. (a difference of say .01) so that the total tax value matches the ultimate header tax amount.

i.e. Tax=

line item 1: P.QX (rounded to next value)

line item 2: P.QR (not rounded)

On adding them, the total tax amount displays correct value.

See Also

Please refer this blog: https://blogs.sap.com/2018/04/05/rules-of-tax-difference-distribution-in-sap-business-bydesign/ 

Keywords

tax amount is different, The tax amount is Showing Different for Invoice items with Same Amount, withholding tax is different , KBA , AP-SIP-SIV , Supplier Invoice , SRD-SRM-PRO , Purchase Requests and Orders , Problem

Product

SAP Business ByDesign all versions