2220851 - Clearing local curr. Flowchart: How to avoid F5263
Symptom
You want to clear in local currency, some line items of a G/L account, from a document flow, where there are at least 2 documents posted, in some foreign currency, at different exchange rates.
Amounts selected to be cleared might seem to be matching*.
However, error F5263 ("The difference is too large for clearing") avoids the clearing.
*At manual clearing transactions, after simulating, F5263 is displayed, ( if the difference isn´t displayed clearly at the first "processing open items" screen, select button to change from clearing currency to local currency: the difference will be displayed better).
Reproducing the Issue
SCENARIO 1
Starting point: For a Company Code with local Currency EUR, there are documents posted in USD as follows:
Go to transaction F-03
Enter account 100019, and currency EUR (local currency)
Select 2 items for documents posted in USD 1000576: (929,45 EUR) and 1000574 (970,00- EUR)
Simulate
F5263 is displayed for SCENARIO 1. (See second blue box at the bottom of flow chart at the end).
SCENARIO 2
Starting point: For the same Company Code, there are documents posted to a different G/L account, also in USD as follows:
Go to transaction F-03,
Enter account 100020, and currency EUR (local currency)
Select 2 items for documents posted in USD: 1000577 (929,45 EUR) and 1000578 (970,00- EUR)
Simulate
F5263 is displayed for SCENARIO 2. (See second blue box at the bottom of flow chart at the end).
Cause
There is an amount difference in some currency that can´t be redirected automatically to other account.
Customizing settings are set to avoid the clearing in local currency in both scenarios.
Let´s analayze these customizing settings in detail: pay special attention to 2 relevant fields at T-code FS00: "Only Manage Balances in Local Currency" (XSALH), and "Tolerance Group for G/L Accounts" (TOGRU).
As indicator SKB1-XSALH isn´t set for account 100020, there is an additional relevant customizing setting, (at the Company Code definition), for SCENARIO 2: It is the indicator "No forex rate diff. when clearing in LC" (T001-XSLTA). It can be displayed at T-code OBY6.
Notice that indicator T001-XSLTA is irrelevant for clearing G/L accounts that keep balances only in local currency ( SKB1-XSALH "X": SCENARIO 1, Account 100019).
1) trying to clear in local currency some account (100019) that keeps balances only in local currency (SKB1-XSALH = "X"),
2) and the difference is bigger than what tolerances allow.
1) trying to clear in local currency some account (100020) that doesn´t keep balances only in local currency (SKB1-XSALH empty),
2) Company Code settings don´t allow recalculation of open items when clearing in local currency (T001-XSLTA = "X"),
3) and the difference is bigger than what tolerances allow.
Resolution
You might want the system to post the difference (as a profit or as a lost) automatically in two potential ways:
1) "KDF Solution": Post realized exchange rate difference to the KDF account, (account for exchange rate differences foreseen at your account determination customizing). Prerequisite: Ex. rate difference accounts are defined for transaction type KDF at T-code OBA1, or at Implementation Guide (IMG from transaction SPRO) step: "Define Accounts for Exchange Rate Differences". Without right account determination, F5063 "Ex.rate diff.accts are incomplete for account" will arise.
2) "DSA Solution": Post some accepted difference via tolerances to the DSA account, (the account foreseen at your account determination customizing for amounts allowed by tolerances). Prerequisite: Accounts are defined for transaction type DSA at T-code OBXZ, or at Implementation Guide (IMG / transaction SPRO) step: "Create Accounts for Clearing Differences". Without right account determination, F5113 "Acct determination not defined for trans. DSA" will arise.
-If you would like to take "KDF Solution" : Quit the idea of clearing in local currency, and use a non local currency to do clearing in T-code F-03, such as USD.
-If you would like to take "DSA Solution": You will have to change customizing settings: increase the permitted tolerances at transaction OBA0.
-Quit the idea of clearing in local currency, and use a non local currency to do clearing in T-code F-03, such as USD.
- Or change customizing settings: remove the flag "No forex rate diff. when clearing in LC" (T001-XSLTA) in transaction OBY6.
-If you would like to take "DSA Solution": You will have to change customizing settings: increase the permitted tolerances at transaction OBA0.
CAUTION: if you want to change any customizing setting, it should be checked deep in a test environment.
See Also
TIP: If F5236 is displayed at the log of transaction F.13 (Automatic clearing program SAPF124, see note 1038853) and also try the manual clearing with transaction F-03.)
2249505 "No forex rate diff. if clear in LC" Scope (T001-XSLTA)
391532 Update currency in line items
335608 Trnsln of 2nd and 3rd lcl crcy fm 1st lcl/trns crcy
1566790 Unexpected exchange rate differences due to rounding
175108 Edit open items: unexpected amount in LC
1224960 FB05: Large exchange rate differences due to effective rate
1143378 FB05: Exchange rate difference lines cannot be explained
1870321 Although the percentage rate 99.9% for tolerance check is maintained, error F5263 is displayed in T-code FB1S
783877 Currency translation: FAQ
538416 TCURR: Rates with reference currency as "To" currency
150103 Extent and effects of the indirect quotation
73848 Change currency not allowed in client maintenance!
Keywords
Additional currencies. Clearing in local currency. Flowchart: How to avoid F5263, Clear G/L Account, F5 263, The difference is too large for clearing, local currency ,F-03, LC, OB22 [T001A], OB08 [TCURR], EWCT Currency Test Converter, OBY6, T001-XSLTA, BKPF-KURSF, BKPF-KURS2, BKPF-KURS3, BSEG-WRBTR, BSEG-DMBTR, BSEG-DMBE2, BSEG-PSWSL, BSEG-PSWBT, BSEG-HWMET, KTOSL, SKB1-XSALH, FB1S, SAPDF05X, AUSGLEICH_PRUEFEN, POSTAB-WRBTR, T001-XSLTA, No forex rate diff. when clearing in LC, (XTLSA XTLSA), Exchange Rate Dif.: Open Items/GL Acct, FWA Exchange rate differences, KDF, F5063,DSA, OBA1, OBXZ, F5113, Tolerances, OBA0, Differences arising on G/L acct clearing.
Products
This document is referenced by
Attributes
Available Languages
日本語 (Machine Translation)
Português (Machine Translation)
Español (Machine Translation)
中文 (Machine Translation)
Français (Machine Translation)
Italiano (Machine Translation)
Русский (Machine Translation)
한국어 (Machine Translation)
Deutsch (Machine Translation)
Rate this document
Was this KBA helpful?
| Products | |
| SAP ERP 6.0 | |
| SAP Note/KBA | Component | Title | |
| 2679832 | FI-GL-GL-A | Error F5063 in T-code:F.13 | |
| Key | Value | |
| Other Components | FI-AR-AR-A (Posting/Clearing/Special General Ledger) | |
| Other Components | FI-AP-AP-A (Posting/Clearing/Special General Ledger) | |