Exchange gain/loss

Soulz

Hi, I have a problem with calculating exchange gain/loss with 1 of my transaction.

My LCY is USD.
A few months ago, I have purchase a stock in FCY SGD @ exchange rate of 1 : 1.65.
Dr Stock 165(SGD)
Cr Bank 165(SGD)

Now i plan to write off my stock to my P&L account in USD but my exchange rate now is 1 : 1.6.
Dr P/L 100(USD)
Cr Stock 100(USD)

But if i post the above transaction, my Stock account will have a debit balance of $5(SGD) and $0(USD). How do i post this $5(SGD) to my exchange gain/loss account?

Any help will be appreciated. Thanks in advance.

ara3n

There is report called Adjust Exchange Rates. Report 595. When you run this report it will adjust the additional currency. Please run it in your test environment and once you are happy with it run it production.

Soulz

ara3n wrote:

There is report called Adjust Exchange Rates. Report 595. When you run this report it will adjust the additional currency. Please run it in your test environment and once you are happy with it run it production.

Hi, i have tested using the "adjust exchange rate" report. There won't be any exchange gain/loss generated for this transaction as it is not post to a vendor/customer/bank account. So there wont be any exchange gain/loss created. The debit and credit accounts are both G/L accounts.

ara3n

It adjust general Ledger as well. There is an checkbox in option tab called
Adjust G/L Accounts for Add.-Reporting Currency. Checkboxing this field will adjust general ledger.