SAP Knowledge Base Article - Public

2846247 - No valuation of Balance Sheet account

Symptom

Balance sheet account is not valuated in app Perform Foreign Currency Valuation (App ID FAGL_FCV)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

S/4 HANA CLOUD

Reproducing the Issue

  1. Perform Foreign Currency Valuation (APP ID FAGL_FCV)/Foreign Currency Valuation Scheduled in app Schedule General Ledger Jobs (APP ID F1927) for Balance Valuation 

  2. List Does not contain any Data on Execution of report for account in question

Cause

  1. In App Manage G/L Account Master (App ID F0731A) Only Balance in Local Currency is ticked.  This Indicates that balances are updated only in local currency when users post items to this account. If the Account Currency is the local currency, the revaluation program does not recognize the foreign currency. No valuation takes place.

  2. If the user subsequently removes this indicator in app Manage G/L Account Master the new postings created can be read in foreign currency and the balances in foreign currency are taken into consideration for valuation purposes.

  3. For foreign currency Valuation The cumulative balance in balance transaction currency is valuated. See KBA 2893557 - Valuation of Foreign Currency Balance Sheet Accounts

  4. Test Example: 
    4.1 In app Manage G/L Account Master Data (App ID F0731A)-> For Account 10010011 Change History shows that the Manage Balances in Local Currency was changed from X to Blank on of the 01.10.2020, 09:49:01

    changehistory.png

    4.2 In App Display Line Items in General Ledger (App id F2217) 

    displaylineitemsingeneralledger.png

    4.3 Note the Local Currency of the Company Code is USD. The Foreign Currency is EUR.  Journal Entries 100000000, 100000001,100001116, 100001117,100001118,100001119 were created at the point in time when the field Manage Balances Only in Local Currency was selected .

    4.4 In these cases the Balance in transaction currency is USD. 

    4.5 New journal entries with a posting date in the past or future, will have the balances in transaction currency in the foreign currency in the case of  foreign currency posting. See Journal Entries
    100000003 and 100001120

    4.6 In the case of a true reversal created after the change of the field Manage Balances Only in Local Currency The system will reverse the journal Entry with the same currencies otherwise there would be and inconsistency. See Journal Entry 100000002 which is a true reversal of journal entry 100000000

    4.7 In the Foreign currency Valuation app the Cumulative balance of account with Balance Trans. Currency EUR is valuated.

    foreigncurrencyvaluation.png



  5. Accounts managed on an open item basis are excluded from this rule. All open items in foreign currency are valuated during foreign currency valuation.

Resolution

System behaviour is correct.

See Also

Foreign Currency Valuation

Maintaining Your Chart of Accounts 


Keywords

FAGL_FCV, BALANCE SHEET, XOPVW, XSALH, F0731A, F0707, ACDOCA , KBA , FI-GL-GL-G , Closing Operations / Period-End , FI-FIO-GL , Fiori UI for General Ledger Accounting , FI-FIO-GL-MD , Master Data Apps , FI-FIO-GL-TRA , Transactions Apps , Problem

Product

SAP S/4HANA Cloud all versions