Symptom
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.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Configure Advanced Foreign Currency Valuation (AFCV).
- 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.
- Run the Advanced Foreign Currency Valuation job, follow standard valuation rule, SKDV
- Observe that all FX valuation results are posted into the same G/L accounts, regardless of account categories.
Cause
Resolution
- 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.
See Also
Keywords
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
SAP Knowledge Base Article - Public