Symptom
The Tax Amount that appears on the Customer Invoice ABC and the Report - G/L Accounts Line items are different.
While checking the Report: G/L Accounts Line items, the value difference is impacting both Debit Amount Company Currency and Balance Amount Company Currency.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Reports sub view.
- Search for the Report - G/L Accounts Line items.
- Give the inputs on mandatory Data Selection as; Company, set of books, Accounting Period/Year, Journal Entry, posting date, Display Currency - Conversion date
- Run the report.
- See the result in Debit Amount Company Currency, which is 100.199 KRW,
- Check in the Customer invoice 'ABC', there the Tax amount is 100.200 KRW. ('ABC' refers to Customer Invoice ID)
- The differences occur with 1 KRW.
Cause
Usually, these differences in amount occurs due to exchange rate.
- Go to the Customer Invoicing work center.
- Go to the Invoice documents sub view.
- Search for the Customer Invoice 'ABC'
- Navigate to the Document Flow.
- Find the respective Clearing ID with the Journal Entry.
- Under relevant Journal Entry check the G/L accounts line items.
Note: The value provided below are just for the example calculations.
G/L account Line Item 1 - 50.045 KRW
G/L account Line Item 2 - 50.154 KRW
Summation of the values --> 50.045 + 50.154 = 100.199 KRW
Tax Exchange Rate: 1
Resolution
- According to the summation of the values in the G/L accounts Line items 1 & 2, the system behaving as expected.
- The Tax Exchange Rate is 1, and based on the calculation, the amount of 100.199 KRW is generated in the report G/L Accounts - Line items.
- The Clearing with Tax Exchange Rate was updated after the Customer Invoice 'ABC' was posted. While trying to run report G/L Accounts - Line items, the Debit Amount Company Currency and Balance Amount Company Currency correctly reflect the applied Tax Exchange Rate value.
Keywords
Tax Exchange Rate, Report - G/L Accounts Line items, Debit Amount Company Currency, Balance Amount Company Currency, South Korea , KBA , SRD-FIN-ANA , Analytics Content , Problem