Bank-Reconciliation in foreign currency

[david_stegnitz3]

Dear SAP B1 Experts,

our Local Currency in SAP B1 is GBP (OADM.MainCurncy). But we do have a USD Bank Account from which we are also paying other Foreign Currency Invoices (e.g. CHF) and Suppliers in other foreign Currencies. Hence the setting in the Chart of Accounts for the USD Bank Account must allow 'All Currencies' (OACT.ActCurr = '##').

Now the issue comes when we are trying to reconcile the USD Bank Account (Banking - Bank Statements and External Reconciliation - Reconciliation). It asks us to reconcile the Account in GBP (the Local Currency) and not in it's Bank-Currency which is USD. The external Bank Statement of course is in USD. In that way it is very difficult to reconcile.

Is there any way to reconcile a GL Account with the 'All Currency' setting in a currency other than the Local Currency?

Thanks, David

[jitin_chawla · Accepted solution]

Hi,

A multi currency Account/Business Partner can be reconciled in the Local Currency only. You can find the same documented in the Online Help file.

regards,

Jitin C

[david_stegnitz3]

Thank you for your response. I was afraid that there is no way to define the Reconciliation-Currency separately from the Local/Account Currency.

[msundararaja_perumal]

Hello,

All the bank accounts must follow their respective account currency. Since it cannot be restored, I suggest you create new G/L Account and proceed from there for future reconciliations.

If the update to multicurrency was done recently, then you may consider restoring the backup.

All the other currency transaction that are not same as the bank account currency can be handled using manual Journal Entries, you will need to an interim account to handle the exchange gain/loss, end of the day after the manual JE, the interim account must be of zero balance.

Thanks.