Symptom
An extension field in the details of expense item is created to display the tax amount. However, the tax amount is not as expected.
For example, enter an expense amount of 100 USD.
The tax rate is 1%.
The expected tax amount is 1 USD, but it turns out to be 0.99 USD.
Environment
SAP Business ByDesign
Reproducing the Issue
- Enter Adatpion Mode.
- Go to Travel and Expense work center and Expense Reports view.
- Select an expense report and select Edit.
- Go to Expenses tab and select one expense item.
- Create an extension field.
- Set Calculation Rule as 'TaxAmount'.
- Save and publish.
- Enter an expense amount as 100 USD.
- See the tax amount is 0.99 USD.
Cause
The expense amount is the gross amount. The calculation logic is as follows:
100/(1+1%)*1%=0.99 USD
Resolution
This is the standard system behavior.
Keywords
Expense Report, Tax Amount, Tax Code, Extension Field, Tax Rate, Calculation, , KBA , SRD-FIN-ERM , Travel and Expense Management , Problem
Product
SAP Business ByDesign all versions