SAP Knowledge Base Article - Public

3416366 - Differences of Tax Amount occurred between Customer Invoice and Report - G/L Accounts Line items - South Korea

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

  1. Go to the General Ledger work center.
  2. Go to the Reports sub view.
  3. Search for the Report - G/L Accounts Line items.
  4. Give the inputs on mandatory Data Selection as; Company, set of books, Accounting Period/Year, Journal Entry, posting date, Display Currency - Conversion date
  5. Run the report.
  6. See the result in Debit Amount Company Currency, which is 100.199 KRW,
  7. Check in the Customer invoice 'ABC', there the Tax amount is 100.200 KRW. ('ABC' refers to Customer Invoice ID)
  8. The differences occur with 1 KRW.

 

Cause

Usually, these differences in amount occurs due to exchange rate.

  1. Go to the Customer Invoicing work center.
  2. Go to the Invoice documents sub view.
  3. Search for the Customer Invoice 'ABC'
  4. Navigate to the Document Flow.
  5. Find the respective Clearing ID with the Journal Entry.
  6. 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

  1. According to the summation of the values in the G/L accounts Line items 1 & 2, the system behaving as expected.
  2. 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.
  3. 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

Product

SAP Business ByDesign all versions