Topic Options
#9731 - 08/22/07 03:07 PM multi currency questions
Jing Hui Offline
Adagio Buff

Registered: 08/08/07
Posts: 56
Loc: bc canada
Our company used PO tracker to record the receipts of inventory from foreign vendors before we turned to Purple just recently. I found that the exchange gain or loss acccount is not the actual gain or loss. For example, we received goods from Europe in May, the exchange rate is 1.5495, the invoice amount is euro 104413.81, we record 0.5495x104413.81=57375.39 as exhange gain, this is not actual ex gain because PO tracker has no foreign currency function. and this gain should not show up in income statement in May, June until it is paid in July. We paid this invoice in July, when the exhange rate is 1.4374276, so the actual gain should be (1.5495-1.4374)*104413.81=11704.79 and should show up in July income statement. right? But after I post the payment, the G/L entry is:

DR accounts payable 148998.71
CR BANK 150087.29

DR SALES 45673.48
CR EXHANGE GAIN OR LOSS 44584.90

104413.81*1.4270(the rate when the invoice generated from PO tracker)
150087.29-104413.81=45673.48

I don't know why debit sales, which makes sale number incorrect. Also where is the amount of 44584.90 from cause it is not the amount we entered as we received the inventory in May, which is 57375.39. and this amount shows up in May income statement.
It looks reasonable if we debit exhange gain or loss account instead of sales when we actually paid the invoice,credit it when we received the inventory in May and the difference will be the actual exhange gain or loss. and the actual gain will only show up in the income statement of the month the invoice was paid. Now my July income statement shows that exhang gain or loss is 44584.90 which is not true. How can I adjust my exhange gain or loss GL account? Thanks a lot.

Top
#9748 - 08/28/07 01:36 PM Re: multi currency questions [Re: Jing Hui]
Ryan Brohman Offline
Adagio Pro

Registered: 01/03/07
Posts: 10
Loc: Waterloo, Ontario
Hi Jing,

There had been a bug in previous versions of Purchase Orders for Adagio that produced similar journal entries related to gain/loss on Exchange. What date version of POA are you running? (When you are in POA in the top left menu bar the version and the date of the build are listed - ie. "Purchase Orders for Adagio 2.1 (17-April-2007)".

The most current version is April 17. If you have an older version than this, you should upgrade. You can download this most recent service pack from:

http://www.stiefgroup.com/shownews.asp?newsid=54

Alternatively, you can contact your dealer who will be able to install this for you. (You will need to obtain a password for the zip file from your dealer if you decide to install it yourself anyways).
_________________________
Ryan Brohman

Kitchener, ON


Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 79 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30