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:
- Go to the Customer Invoicing work center.
- Select the Invoice Documents view.
- Open Invoice XYZ (XYZ represents the ID of the Invoice).
- Navigate to the Pricing tab.
- 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).
- The VAT is 0,00 INR
- There is a Rounding Difference of 0,17 INR.
- 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