Symptom
You run the report Sales Register-India and notice that the field 'Product Tax Base Amount' shows an amount different from the amount on the Journal Entry of the customer invoice.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Customer Invoicing work center.
- Go to the Invoice Documents view.
- Search for Invoice ID XXX (XXX stands for the ID of the invoice).
- Net Value is 200, 36 EUR.
- Select Edit.
- Select View All.
- Select Items tab.
- Select Tax subtab.
- Tax Base Amount is 200,36 EUR.
- Select Document Flow tab.
- Open the corresponding Journal Entry of the invoice.
- The amount in the JE posting shows as 18.000,34 INR.
The posting date is 08.01.2024
The Exchange Rate is 89,84
To run the Sales Register-India report.
- Go to the Business Analytics work center.
- Go to the Design Reports view.
- Open the report Sales Register-India.
- Run the report with the necessary selection.
For invoice XXX , the report shows the Product Tax Base Amount as 18.244,78 INR.
18.244,78 INR in the report is different from amount 18.000,34 INR in the JE posting.
Note: The amounts and date used in this document are example.
Cause
The amount in the report is obtained from the exchange rate available in the system at the creation time of the invoice.
Before the posting of the Journal Entry, another exchange rate is maintained and is used for the journal entry posting.
This is why the amount on the journal entry posting is different from the amount in the report.
Resolution
This is the expected and designed system behavior.
To have the same amount in the report and on the journal entry, cancel invoice XXX and recreate it so the exchange rate used by the system for the invoice and the report is the same.
In the future, make sure at the creation time of the invoice, the appropriate exchange rate is maintained and available in the system.
Keywords
Product Tax Base Amount, Sales Register-India, Journal Entry, Customer Invoice, Exchange Rate. , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , Problem