customer open items ledger

[Former Member]

when i run customer ledger i got it in two currencies because i have two receivebles in euro and usd , but i have discrepencies the balance in euro and it is equivalent in usd not matching for example in euro the balance is 100 euro but inthe equivalent in usd 600 usd , i thought it is due to error in posting incoming payments how to slove this problem

[Former Member]

Hi,

Miantain GL account for foreign exchange gain or loss in OBA9. As you said this is a payment, clear it against the invoice, the difference will go to foreign exchange gain or loss account.

Regards

Milind Sonalkar

[Former Member]

what is the path please to maintain it and how thank you

[Former Member]

Hi,

T.code to Maintain the exchange is OB09 and Path is SPRO - Financial Accounting (New)-General Ledger Accounting (New)-Business Transactions-Open Item Clearing-Define Accounts for Exchange Rate Differences EXCUTE

Read the following Notes

In this activity you define the numbers of the accounts to which you want the system to automatically post realized exchange rate differences when clearing open items.In clearing open items, the system posts any realized gains or losses

(realized exchange rate differences). You therefore need to define gain and loss accounts. To automatically post exchange rate differences when clearing open items, you have to specify the reconciliation accounts for customers and vendors in the "G/L account" field. If, for example, you want to clear a foreign currency open item on the debit side, you have to enter a receivables account in the "G/L account" field. To automatically post exchange rate differences when clearing bank sub-accounts, you have to enter the numbers of the bank sub-accounts in the "G/L account" field.

Hope the above Notes and Path will Help in solving your Issue.

Thanks

Goutam

[Former Member]

it is very helpful