SAP Knowledge Base Article - Public

3446367 - Amount on Journal Entry Different From Amount in Sales Register-India Report

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

  1. Go to the Customer Invoicing work center.
  2. Go to the Invoice Documents view.
  3. Search for Invoice ID XXX (XXX stands for the ID of the invoice).
  4. Net Value is 200, 36 EUR.
  5. Select Edit.
  6. Select View All.
  7. Select Items tab.
  8. Select Tax subtab.
  9. Tax Base Amount is 200,36 EUR.
  10. Select Document Flow tab.
  11. Open the corresponding Journal Entry of the invoice.
  12. 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.

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view. 
  3. Open the report Sales Register-India.
  4. 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

Product

SAP Business ByDesign 2402