Foreign Currency Open Items Exchange Difference Preview Report
Short answer: A custom ALV report that reads customer and vendor open items by document currency, revalues them at the key-date rate and shows the unrealized exchange difference per item, account and currency. The month-end effect is visible before any valuation posting is made.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
F.05 (FAGL_FCV on S/4HANA) performs the valuation and posts it; its test-run list does not offer a flexible summary by currency and account, or one Excel-ready view with customers and vendors together. FBL5N and FBL1N show the document currency amount but neither revalue at the key-date rate nor calculate the difference. Treasury usually works out the exchange effect in Excel during the month.
Who uses it? General ledger and month-end close teams, treasury and financial controllers, especially companies with large foreign currency payables and receivables.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BSIDCustomer Open Items | Customer open items: document and local currency amounts (driving table) | — | ECC + S/4 |
| BSIKVendor Open Items | Vendor open items: document and local currency amounts | BSIK-BUKRS = BSID-BUKRS | ECC + S/4 |
| T001Company Codes | Company code currency | T001-BUKRS = BSID-BUKRS | ECC + S/4 |
| TCURRExchange Rates | Exchange rate valid on the key date | TCURR-FCURR = BSID-WAERS AND TCURR-TCURR = T001-WAERS AND TCURR-KURST = P_KURST | ECC + S/4 |
| TCURFCurrency Conversion Factors | Ratio factors for the currency pair | TCURF-FCURR = TCURR-FCURR AND TCURF-TCURR = TCURR-TCURR AND TCURF-KURST = TCURR-KURST | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = BSIK-LIFNR | ECC + S/4 |
S/4HANA notes
- BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
- BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
BAPIs and functions used
- READ_EXCHANGE_RATEDetermine Exchange Rate from Table TCURR. Reads the valid rate and factors for the key date and rate type
- CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Translates the document currency amount into local currency at the key-date rate
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes | 1000 |
| S_KUNNR | Customer | Range / multiple | BSID-KUNNR | No | 200150 |
| S_LIFNR | Vendor | Range / multiple | BSIK-LIFNR | No | 100245 |
| S_WAERS | Document currency | Range / multiple | BSID-WAERS | No | USD |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 30.11.2026 |
| P_KURST | Exchange rate type | Single value | TCURR-KURST | Yes | M |
| P_CUST | Include customer open items | Checkbox | — | No | X |
| P_VEND | Include vendor open items | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | BSID-BUKRS |
| 2 | Account type | Calculated Customer when the item comes from BSID, Vendor when it comes from BSIK |
| 3 | Account | Calculated BSID-KUNNR or BSIK-LIFNR |
| 4 | Account name | Calculated KNA1-NAME1 or LFA1-NAME1 |
| 5 | Document | BSID-BELNR |
| 6 | Posting date | BSID-BUDAT |
| 7 | Document currency | BSID-WAERS |
| 8 | Amount in document currency | BSID-WRBTR |
| 9 | Booked local amount | BSID-DMBTR |
| 10 | Historical rate | Calculated DMBTR / WRBTR |
| 11 | Key-date rate | TCURR-UKURS |
| 12 | Revalued amount | Calculated WRBTR × key-date rate (with TCURF factors) |
| 13 | Unrealized exchange difference | Calculated Revalued amount − DMBTR |
| 14 | Local currency | T001-WAERS |
Sample output
| Company code | Account type | Account | Account name | Document | Posting date | Document currency | Amount in document currency | Booked local amount | Historical rate | Key-date rate | Revalued amount | Unrealized exchange difference | Local currency |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | Customer | 200150 | Kuzey Gıda Dağıtım | 1800012044 | 09/12/2026 | USD | 40,000 | 1,360,000 | 34 | 34.65 | 1,386,000 | 26,000 | TRY |
| 1000 | Customer | 200388 | Marmara Yapı Market | 1800012391 | 10/03/2026 | EUR | 15,000 | 585,000 | 39 | 40.10 | 601,500 | 16,500 | TRY |
| 1000 | Vendor | 100387 | Delta Metal | 5100003902 | 08/21/2026 | USD | -22,000 | -741,400 | 33.70 | 34.65 | -762,300 | -20,900 | TRY |
| 1000 | Vendor | 100512 | Ege Kimya | 5100004502 | 11/04/2026 | EUR | -8,500 | -340,850 | 40.10 | 40.10 | -340,850 | 0 | TRY |
How does the report work?
- For the selected company codes, open items whose document currency (WAERS) differs from the company code currency (T001-WAERS) are read from BSID and BSIK.
- The booked local currency amount (DMBTR) and the document currency amount (WRBTR) are signed by the debit/credit indicator (SHKZG); historical rate = DMBTR / WRBTR.
- The key-date rate for the selected rate type is read from TCURR by validity date; translation follows the READ_EXCHANGE_RATE and CONVERT_TO_LOCAL_CURRENCY logic, taking the TCURF ratio factors into account.
- Revalued amount = WRBTR × key-date rate; unrealized difference = revalued amount − DMBTR.
- Customer names come from KNA1 and vendor names from LFA1; rows are subtotalled by account and currency.
Performance notes
Read BSID and BSIK with company code and currency conditions; read each currency's rate once and keep it in memory. On S/4HANA, open items can be aggregated in the database through I_OperationalAcctgDocItem.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the document number opens FB03.
- Export to Excel
- Runs as a background job Can run automatically with the month-end key date and be emailed to treasury.
- Send the result by email
Authorization objects
- F_BKPF_BUKAccounting document display authorization by company code
- F_KNA1_BUKCustomer master authorization by company code
- F_LFA1_BUKVendor master authorization by company code
Frequently asked questions
Does the report post anything?
No. The report is a preview only. The posting is still made with the standard valuation (F.05, or FAGL_FCV on S/4HANA); the report lets you check the amounts before posting.
Is a previous month's valuation taken into account?
If the valuation method reverses every month, the booked amount is enough for the comparison. For methods without reversal, earlier valuation differences are read from the valuation table and added to the booked amount; this option is set during installation.
Can G/L open items be valued too?
Yes. Open-item-managed G/L accounts such as foreign currency bank clearing accounts can be added from BSIS with the same logic; this scope adds a day or two to the effort range.
Packages that include this solution
Currency Valuation and VAT Reconciliation Pack
A four-component pack that brings period-end valuation and tax checks together: daily automatic import of central bank exchange rates, an exchange …
Related reports
Customer Receivables Aging Report
A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.