3727330 - Assigning Multiple FX Gain/Loss G/L Accounts in Advanced Foreign Currency Valuation - SAP S/4HANA Cloud Public Edition

How to assign multiple FX gain/loss G/L accounts based on account categories such as accounts payable, accounts receivable, and other G/L accounts in advanced foreign currency valuation (AFCV)?

Following standard valuation rule, SKDV, FX valuation results are posted into the same  fx gain/loss G/L accounts.

SAP S/4HANA Cloud Public Edition

1. Configure Advanced Foreign Currency Valuation (AFCV).
2. Attempt to assign multiple FX gain/loss G/L accounts based on account categories such as accounts payable, accounts receivable, bank accounts, and other G/L accounts.
3. Run the Advanced Foreign Currency Valuation job, follow standard valuation rule, SKDV
4. Observe that all FX valuation results are posted into the same G/L accounts, regardless of account categories.

1. Create a new valuation rule:

• Navigate to configuration activity "Define Rules for Advanced Foreign Currency Valuation" (SSCUI ID 105450).
• Copy the SAP-delivered rule (e.g., SKDV) and assign a new name to it.
• Save the newly created rule, ensuring the system performs a full consistency check.

     2. Create valuation rule steps:

• Step 0010: Vendor Accounts
• Business Transaction Type: RFCV
• Exchange Rate Type: M (or preferred rate type)
• FCV Valuation Method: ALWAYS_VALUATE (or as per business requirement)
• Assign semantic tag (e.g., FX_VENDOR) to filter vendor reconciliation accounts.
• Assign G/L accounts for FSV: Vendor Reconciliation Accounts → AP Gain/Loss G/Ls.

• Step 0020: Customer Accounts
• Business Transaction Type: RFCV
• Exchange Rate Type: M (or preferred rate type)
• FCV Valuation Method: ALWAYS_VALUATE (or as per business requirement)
• Assign semantic tag (e.g., FX_CUSTOMER) to filter customer reconciliation accounts.
• Assign G/L accounts for FSV: Customer Reconciliation Accounts → AR Gain/Loss G/Ls.

• Step 0030: Other G/L Accounts
• Business Transaction Type: RFCV
• Exchange Rate Type: M (or preferred rate type)
• FCV Valuation Method: ALWAYS_VALUATE (or as per business requirement)
• Assign semantic tag (e.g., FX_OTHER) to filter remaining G/L accounts.
• Assign G/L accounts for FSV: Other G/L Accounts → Other FX Gain/Loss G/Ls.

    3. Configure semantic tags:

• Navigate to "Define Semantic Tags for Financial Statement Versions" (SSCUI ID 101878).
• Assign semantic tags to financial statement versions using "Assign Semantic Tags to Financial Statement Versions" (SSCUI ID 102659) or the "Manage Global Hierarchies" app.
• Assign the following semantic tags to the respective account ranges in the related financial statement version:
• Vendor Semantic Tag (FX_VENDOR): Vendor reconciliation account ranges.
• Customer Semantic Tag (FX_CUSTOMER): Customer reconciliation account ranges.
• Other G/L Semantic Tag (FX_OTHER): Remaining G/L account ranges requiring FX valuation.

   4. Ensure postings are made to the relevant G/L accounts before running the Advanced Foreign Currency Valuation job.

• Refer to: How to assign Semantic Tag - SAP S/4HANA Cloud Public Edition.
• Refer to: How to perform Advanced Foreign Currency Valuation.
• Refer to: Foreign Currency Valuation with the new Advanced Valuations - SAP Community.

advanced foreign currency valuation, afcv, fx gain/loss accounts, semantic tags, financial statement version, vendor accounts, customer accounts, bank accounts, unrealized gain/loss, reconciliation, configuration, public cloud. , KBA , FI-GL-GL-G-2CL , Closing Operations / Period-End (Public Cloud) , How To