SAP Accounting Consulting

Symptom
Wrong exchange rate in JEV Foreign Currency report, no GL offsetting account information in General Ledger Line items report, Currency code not translated in Trial Balance with Foreign Currency report
Other terms
Wrong exchange rate in JEV Foreign Currency, No GL offsetting account information in General Ledger Line Items report, Currency code not translated in Trial Balance with Foreign Currency report, Chinese Forms, Statutory Reporting
Reason and Prerequisites
1) For wrong exchange rate – the exchange rate was actually taken from the table. It should be based on the transaction
2) NO GL offsetting account – if the journal entry document has both credit and debit side with the same GL account the offsetting account was missing.
3) Currency code not translated – only the currency code was sent and not the legal name
Solution
1) For wrong exchange rate – While generating the report, the exchange rate should not be taken from the table. It should be based on the exchange rate which was calculated when the document was posted. Accordingly this was modified.
2) For GL account – In GL report, the offsetting account will not be displayed, if the GL account is same for that page. Now it will be displayed for all conditions.
3) Currency code not translated – IN JEV report, the CNY which was displayed inbetween the total amount text, is been removed.
4) And next, IN GL FCUR report the foreign currency code (USD) which was displayed in english will now be displayed as “US Dollar” which is the legal name for USD (currency code)