Symptom
- An unexpected Balance of XXX,XX LC is displayed in the Foreign Currency Remeasurement Run for Cash (where XXX,XX LC is the amount in Local Currency).
- The GL Accounts Line Items Report shows a Balance of ZZZ,ZZ LC which is correct, but the Foreign Currency Remeasurement Run displays a Balance of XXX,XX LC (where ZZZ,ZZ LC is the amount displayed in the Report in Local Currency).
- The issue occurs specifically for one particular GL Account YYY in the Foreign Currency Remeasurement for Cash (where YYY is the GL Account ID).
- The expected behavior is a zero Balance amount in the Foreign Currency Remeasurement Run.
Environment
SAP Business ByDesign
Reproducing the Issue
- Navigate to the General Ledger work center.
- Access the Reports - List view.
- Open the GL Accounts Line Items Report (FINGLAU02_Q0001).
- Select the relevant Company, Set of Books, GL Account and the Accounting Period/Year.
- Start the Report.
- Observe that the Debit Amount in Company Currency is ZZZ,ZZ LC which is correct.
- Navigate to the Payment Management Work Center.
- Access the Foreign Currency Remeasurement Runs view.
- Open the Foreign Currency Remeasurement for Cash AAA (where AAA is the Foreign Currency Remeasurement Run ID).
- Navigate to the Remeasured Balances view and filter for the respective GL Account YYY.
Observe that the Balance amount is XXX,XX LC and the loss amount is ZZZ,ZZ LC. You expect that there should be no Balance amount XXX,XX LC displayed in the Foreign Currency Remeasurement Run at all, only the loss amount of ZZZ,ZZ LC.
Cause
The Balance amount of XXX,XX LC in the Foreign Currency Remeasurement Run for Cash originates from a reversal of a Balance Carryforward respectively a Data Migration some time back. This can be seen when navigating from the GL Accounts Line Items Report to the Journal Report and check earlier periods.
Resolution
Create a new Journal Entry Voucher for Cash like this:
- Go to the General Ledger Work Center.
- Under Journal Entry Vouchers select New - Journal Entry Voucher.
- Select Journal Entry Type as 00083 - Manual Entry for Cash.
- Choose Screen Variant as 624 - Manual Adjusting Entry for Cash.
- Enter the remaining information required for the Journal Entry Voucher.
- Post the Journal Entry Voucher for Cash to eliminate the Balance of XXX,XX LC from the Data Migration / Balance Carryforward entry.
See Also
- Refer to: SAP Community - Business ByDesign
- Refer to: SAP Influence Campaign
- Refer to: SAP Support by Product
- Refer to: SAP Help Portal - Business ByDesign
- Refer to: Meet-the-Expert Webinar Sessions
Keywords
foreign currency remeasurement, balance, GL account, manual journal entry voucher, balance carryforward reversal, cash ledger, incorrect balance, foreign currency remeasurement issue, accounting period, manual adjusting entry for cash , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem
SAP Knowledge Base Article - Public