Topic Options
#40119 - 02/05/14 08:43 AM OE Sales in USD?
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
We are currently using OE 8.1F in CAD without multi-currency. We have a customer that would like us to Invoice them in USD. I am trying to figure out it if there is a way to do this. I thought an option might be to create an Invoice in OE at the USD amount and print it on a spec that says USD and give it to the customer. Then, credit it back in full and re-invoice it in CAD. When the payment arrives to us in USD, debit the USD bank and debit Foreign Exchange Expense for the difference. I thought this might work but I'm confused because debiting Foreign Exchange Expense increases the expense so the sale appears to be a loss. What am I doing wrong? Is there a way to accomplish this? Any help would be appreciated. Thank-you.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#40144 - 02/06/14 11:42 AM Re: OE Sales in USD? [Re: SusanTennier]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1736
Loc: Waterloo, Ontario, Canada
Hi Susan,
You're taking the long way home. Seriously, if this invoice is going to be a regular occurrence, get and install Adagio Multi-currency. This is the easiest and best solution. This should be your first choice unless this is clearly a "one off" single invoice situation.

If this is a one off situation, simply create a new AR control account for USD customer(s) and simply leave in "Par" dollars in OE and AR. After posting the invoice and retrieving into AR, adjust your AR GL balance with the exchange with the offset being sales if the balance is outstanding over month-end. If not (ie. paid in the same invoiced fiscal period), just deposit the cash into your USD bank account when paid, and adjust your GL bank account for the exchange pickup and credit your sales. Your sales analysis will be incorrect with this workaround, but it is simply an alternative solution.

Adagio Multi-currency should fall into "Best Practices", if you are either buying product for inventory or incurring expenses in another currency other than your domicile country, or if you are selling into another country with a different currency. Multi-currency isn't just a good solution, it is an outstanding Adagio solution that more people should be considering if they want an easy way to manage multi-currency transactions for effective financial reporting.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#40153 - 02/07/14 11:14 AM Re: OE Sales in USD? [Re: Brian Stief]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Thanks Brian. We appreciate the direction. We will consider our options with this information.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 47 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 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