SAP Knowledge Base Article - Public

3623167 - How the tax amount is calculated in purchase order

Symptom

The calculated tax amount in purchase order has a slightly difference with the actual purchase order tax amount when purchasing products with very low unit price.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Purchase Requests and Orders Work Center.
  2. Click on New Purchase Order view under Common Tasks.
  3. Enter mandatory information in the purchase order and navigate item tab.
  4. Under Basic Data sub-tab, Price component, since the product has a very low unit price, enter a net price for bulk quantity (say 10 X/ 1,000 UoM). (Here X refers to currency)
  5. The calculated tax amount is different from the actual amount.

Cause

Example here:

Enter 1,769,911.50 X /10,000 UoM) as the unit price, enter quantity 4, and tax rate 13% for example.

Now, the expected calculated tax amount is  13%*4*176.991,15 , and after the total amount is calculated as 92.035398 X, system finally do the rounding off and results to 92.04 X.

However, the actual calculated tax amount is as following: 13%*4*rounding off(176.991,15) = 13%*4*176.99, equal to 92.03 X.

The result is slightly different. 

Resolution

This is the current system design.

System will first do the rounding off to calculate the net value and use this net value with only 2 decimal points as the tax based amount to calculate the tax amount.

Keywords

Tax amount, Purchase order, Rounding off, Decimal points, Currencies, Unit price , KBA , SRD-SRM-SI , Supplier Invoicing , Problem

Product

SAP Business ByDesign all versions