Cross Currency Clearing & FX Revaluation
Currently our GL validation is set up to allow cross currency clearing, so that a GBP balance could be cleared with a USD balance for example.
When this happens, the GL treats the transactions as closed items. However, when we run the FX revaluation, it revalues the USD balance as our FX revaluation runs on SL balances rather than GL balances, and the SL balance is treated as open still as it is not matched by attribute (i.e. different currencies).
Three questions follow from this:
1) Is it usual practice to perform cross currency clearing?
2) Should the USD balance be revaluing?
3) To clear this correctly should we be converting the GBP balance into USD before clearing? (Source system posts in GBP only although the cash is received in original currency).
Csaba Soltesz replied
perhaps you know that for exactly this purpose (splitting unrealized FX postings based on FI-SL characeristics), SAP has a built-in feauture in SAPF100. This is pushbutton "SL Extra" on the GL balances tab of SAPF100s selection screen. Pls. check out the field documentation F1-help below and consult OSS note 949971 which is describing your options quite comprehensive.
<i>Read Balances from Special Purpose Ledger
Setting this indicator means that the transaction figures from a special
purpose ledger are used and not the transaction figures from the general
You can therefore specifically valuate additional dimensions such as the
functional area or profit center within an account.
The expense/revenue is determined in accordance with the additional
dimensions of the ledger. A profit/loss therefore arises per functional
area, for example.
During posting the data from the additional dimensions is entered in
batch input fields.
Unfortunately, you cannot flag the open items in FI-SL. This is because a particular line item is transferred ONCE to FI-SL. Any changes made to the line item later in FI, say, changing the Text field or just clear the item are NOT transferred to FI-SL again, so the active connection is lost, only the references are there, but no any updates take place.
So in case you want to consider if the item was cleared meanwhile, you have no chance to decide it based on the FI-SL information as that will be unchanged since the line item was transferred to FI-SL. How to check if the item is cleared can be done via checking BSAS or you can also check directly in BSEG. (fields AUGDT, AUGBL are initial? Then it is still open). Lucky enough, if you have read the FI-SL line item, you can find the BSAS (or BSEG) record quite straightforward. It would not make your report quicker, but it could be much worse. All database selections can be assessed using primary keys so a selection is as performant as possible.
Hm, reversing and reposting an entry just because of this seems to be an extremely basic solution to me. What is the relation between the GBP values of the original (USD) item and the new (GBP) item? Which way the new GBP items are posted? Is it an interface? Is it some standard or custom report within SAP? Is it a manual journal entry? As mentioned above, cross-currency clearings are not at all an issue form an accounting point of view - of course it would be ideal if the currencies would be the same but no one can be blamed if they are not. (One should know the process behind to judge it, however).
Hope that helps, points welcome