# Foreign Currency Open Items Exchange Difference Preview Report

> 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.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/foreign-currency-open-items-exchange-difference-report/


## 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.

### Closest standard alternatives

- F.05: Performs and posts the foreign currency valuation; does not offer a flexible preview summary.
- FBL5N: Lists the document currency amount; does not revalue at the key-date rate.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| BSID | Customer open items: document and local currency amounts (driving table) | Read | - | ECC + S/4 |
| BSIK | Vendor open items: document and local currency amounts | Read | BSIK-BUKRS = BSID-BUKRS | ECC + S/4 |
| T001 | Company code currency | Read | T001-BUKRS = BSID-BUKRS | ECC + S/4 |
| TCURR | Exchange rate valid on the key date | Read | TCURR-FCURR = BSID-WAERS AND TCURR-TCURR = T001-WAERS AND TCURR-KURST = P_KURST | ECC + S/4 |
| TCURF | Ratio factors for the currency pair | Read | TCURF-FCURR = TCURR-FCURR AND TCURF-TCURR = TCURR-TCURR AND TCURF-KURST = TCURR-KURST | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = BSIK-LIFNR | ECC + S/4 |

## BAPIs and functions used

- READ_EXCHANGE_RATE: Reads the valid rate and factors for the key date and rate type
- CONVERT_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 |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes |
| S_KUNNR | Customer | Range / multiple | BSID-KUNNR | No |
| S_LIFNR | Vendor | Range / multiple | BSIK-LIFNR | No |
| S_WAERS | Document currency | Range / multiple | BSID-WAERS | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_KURST | Exchange rate type | Single value | TCURR-KURST | Yes |
| P_CUST | Include customer open items | Checkbox | - | No |
| P_VEND | Include vendor open items | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Company code | BSID-BUKRS |
| Account type | Calculated: Customer when the item comes from BSID, Vendor when it comes from BSIK |
| Account | Calculated: BSID-KUNNR or BSIK-LIFNR |
| Account name | Calculated: KNA1-NAME1 or LFA1-NAME1 |
| Document | BSID-BELNR |
| Posting date | BSID-BUDAT |
| Document currency | BSID-WAERS |
| Amount in document currency | BSID-WRBTR |
| Booked local amount | BSID-DMBTR |
| Historical rate | Calculated: DMBTR / WRBTR |
| Key-date rate | TCURR-UKURS |
| Revalued amount | Calculated: WRBTR × key-date rate (with TCURF factors) |
| Unrealized exchange difference | Calculated: Revalued amount − DMBTR |
| Local currency | T001-WAERS |

## How does the report work?

1. 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.
2. The booked local currency amount (DMBTR) and the document currency amount (WRBTR) are signed by the debit/credit indicator (SHKZG); historical rate = DMBTR / WRBTR.
3. 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.
4. Revalued amount = WRBTR × key-date rate; unrealized difference = revalued amount − DMBTR.
5. Customer names come from KNA1 and vendor names from LFA1; rows are subtotalled by account and currency.

## Authorization objects

- F_BKPF_BUK: Accounting document display authorization by company code
- F_KNA1_BUK: Customer master authorization by company code
- F_LFA1_BUK: Vendor 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-foreign-currency-open-items-revaluation-preview
