Symptom
In the Down Payment Request, the Tax base amount is displaying incorrectly.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Customer Invoicing - Invoice Documents view.
- Open the Down Payment Request: ABC.
- Go to the Agreement tab, observe the net value is 123 in the Details section.
- In the Tax Details section, the tax base amount is 456 which is different than the net value amount value.
- The expected Tax base amount should be 123 which equals to the net value.
- ABC represents the ID of the down payment request.
- 123,456 represent the value of the price field.
Cause
The discrepancy in the tax base amount is due to the rounding difference in the system calculations.
Take the down payment request ABC as example.
Gross Amount= 226.566, 39.
tax rate=20%
The system calculates the Tax Base Amount= 226566.39/1.2=188,805.325 => 188,805.33 after rounded.
Tax Amount=188,805.33 / 20% = 37,761.066 => 37,761.07 after rounded.
Then, calculate the Net Value: Amount - Tax amount= 226.566, 39 - 37,761.07=188,805.32.
Resolution
System works as designed correctly.
Keywords
Tax Base Amount, Down Payment Request, Rounding Difference, Net Value, Gross Amount, Tax Rate, Customer Invoicing. , KBA , SRD-CRM-INV , Customer Invoicing , Problem