2220851 - Clearing local curr. Flowchart How to avoid F5263

作者:郑德鼎 约 4 分钟阅读 更新日期:2024-02-22 2 年前更新 标签:Data Engineering, SD, 数据工程, 销售分销
目录

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

To sum it up

SCENARIO 1 IS

F5263 is displayed when

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.

SCENARIO 2 IS

F5263 is displayed when

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.

FOR SCENARIO 1

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

FOR SCENARIO 2

-If you would like to take "KDF Solution", there are 2 ways

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

Notes about currency translations in a SAP system

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

Generic Notes about Currencies in a SAP system

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

郑德鼎

关于作者:郑德鼎

企业信息化与 SAP 技术顾问,长期专注 SAP ABAP、FI/CO、MM、SD 等模块的技术分享与实战经验总结。查看更多介绍

来源说明:本文内容由「2220851 - Clearing local curr. Flowchart How to avoid F5263.docx」整理生成,仅用于内部技术分享与学习交流。