Symptom
When opening the General Ledger Work Center, the exchange rate appears to be different when comparing with the attached JSON file under the Customer Invoicing Work Center.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Select Journal Entries view
- Search for the journal entry which corresponds to the source document customer invoice XYZ (Where XYZ corrrepresents the customer invoice ID)
The amount shown is e.g. INR 3,836,902.61
- Go to Customer Invoicing work center
- Select Invoice Documents view
- Search for Invoice ID XYZ
- Under the General tab, go to Attachments and open the JSON file.
The amount shown is e.g INR 3,788,589.54 ("TotInvVal": 3788589.54 }}])
Cause
The difference between the amount in the Journal Entries view and the JSON file under the Invoice Documents view is caused by the currency conversion dates on which the documents were processed.
- Customer invoice ID XYZ was created on e.g 04.11.2022, JSON would consider the exchange rate that is valid for that date which is 04.11.2022.
- On the journal entry side, the system would consider the exchange rate based on the posting date which is e.g 31.10.2022.
Resolution
This is the expected system behaviour.
Keywords
Incorrect, Not expected, Not correct, Wrong, Invoice , KBA , AP-CI-CI , Customer Invoice , Problem