SAP Knowledge Base Article - Public

3712586 - Difference in transaction currency amounts between Manage Customer Line Items App and Account Receivable Aging Report App - SAP S/4HANA Cloud Public Edition

Symptom

The amount in transaction currency in Manage Customer Line Items App is different from that in Account Receivable Aging Report App while the amount in local currency remains consistent across both applications.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Navigate to Manage Customer Line Items App, select a specific open item with foreign currency.
  2. Search for the same journal entry in Account Receivable Aging Report App.
  3. Observe that the amount in transaction currency in two apps differs while the amount in local currency is exactly the same.

Cause

This is the standard behavior. 

Resolution

Manage Customer Line Items App shows the line item with transaction currency amount and local currency amount as what is originally posted in the journal entry. Or in other words, the amounts themselves are displayed as saved with the journal entry.

Meanwhile, Account Receivable Aging Report uses "Display Currency" and works based on the amount in local currency as default. That is, the line items are first processed in local currency and then converted into the display currency. This currency conversion can lead to small deviations from the persisted transaction currency in the journal entry. This can be caused some of the reasons as below:

  • Rounding differences
  • Different exchange rates used during the currency conversion of Account Receivable Aging Report.

Keywords

transaction currency, local currency, manage customer line items, account receivable aging report, currency conversion, rounding differences, exchange rates, display currency, standard system behavior, analytical report. , KBA , FI-FIO-AP-ANA-2CL , Accounts Payable Analytics: Public Cloud , Problem

Product

SAP S/4HANA Cloud Public Edition all versions