SAP Knowledge Base Article - Public

3259735 - Difference Between Total and Total Item Value in a Sales Document Such as an Invoice or Credit Memo

Symptom

You notice a difference between the Total and the Total Item Value in a Sales Document such as an Invoice or Credit Memo.

Environment

SAP Business ByDesign

Reproducing the Issue

we will use an Invoice as an example:

  1. Go to the Customer Invoicing work center.
  2. Select the Invoice Documents view. 
  3. Open Invoice XYZ (XYZ represents the ID of the Invoice).
  4. Navigate to the Pricing tab.
  5. In the Total Pricing section you can see that the Total Item Net Value is 100,17 INR (we are using INR as an example of a currency).
  6. The VAT is 0,00 INR
  7. There is a Rounding Difference of 0,17 INR.
  8. The Total is 100,00 INR

You would like to know why there is a Rounding Difference.

Cause

The Rounding Difference is calculated according to the rounding value for INR maintained in your Business Configuration.

 The rounding value is the value to which amounts are rounded.

You can check this as follows:

Go to the Business Configuration work center.

Select the Overview view.

Open fine tuning activity Currencies.

Filter for Currency Code INR.

You can see that the rounding value is in our example 0,5 and decimals are 02.

So the value 100,17 INR will be rounded down to 100,00 INR and e.g. the value 100,47 INR will be rounded up to 100,50 INR

If the rounding value would be set to 1 in the Business Configuration the values 100,17 INR will be rounded down to 100,00 INR and the value 100,47 INR will be rounded up to 101,00 INR.

Resolution

This is the expected system behaviour.

Keywords

rounding; Total; Incorrect; Net Value; Item Net Value; rounding difference; rounding value; rounded; price; list price; , KBA , AP-PRC-PC , Calculation , AP-CI-CI , Customer Invoice , Problem

Product

SAP Business ByDesign all versions