Topic Options
#36582 - 04/16/13 04:09 PM Using Multicurrency with AP
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
We are using Multicurrency with AP (as well as other modules). Our Home Currency is CAD.

We are entering an Invoice batch for USD Vendors.

In AP Invoices as well as Checks, as soon as we enter the Vendor code & press tab, the Currency on the Header displays: USD (which is correct). However, the Exchange Rate displays as 0.00000.

We have to go in to this field to select the Rate.

Can’t we have the Rate default automatically to the Rate that we have entered in the Multicurrency Rates, based on the Date on the transaction?

(Adagio would know which Rate Type to use as the default, since it has been entered on the Vendor's Ctrl Account Set.)
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#36583 - 04/16/13 04:19 PM Re: Using Multicurrency with AP [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
In Multicurrency, you define how the rate gets selected in the "Date Matching" area of the rate definition. If you say "Exact date" then you need a rate entry for every day. If you say "Lower" then you only need a rate until it changes.
_________________________
Andrew Bates

Top
#36587 - 04/16/13 07:10 PM Re: Using Multicurrency with AP [Re: Retired_Guy]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
That is correct.
We are using "Lower". So if we use an exchange date of say April 1, and our transaction date is later in April, I would expect that the default rate would be equal to what we entered for April 1.
But instead, the Rate still shows 0.0000 on the Invoice/Check screen. We still have to select or enter a value.
Shouldn't the April 1 rate automatically appear as the default rate?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#36588 - 04/16/13 07:30 PM Re: Using Multicurrency with AP [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Try "Higher".
_________________________
Andrew Bates

Top
#36590 - 04/17/13 05:34 AM Re: Using Multicurrency with AP [Re: Retired_Guy]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
No difference.

"Higher" or "Lower" - I tried them both, and in each instance the Rate on the Header screen remains at 0.00000. (And BTW, "Exact" as well gives the same results.)

It does not default to the appropriate Rate. We still have to click into this field.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#36631 - 04/18/13 09:10 AM Re: Using Multicurrency with AP [Re: Samuel Kopstick]
Patricia B. Offline
Adagio Maestro

Registered: 06/26/08
Posts: 1160
Loc: Langley, BC
Even if you have AV (or other Rate Type) in the Company Profile the Rate Type that is used is the one in the Control Account Set. You either need to change the Control Account Set or create the appropriate table.
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060





Top
#36642 - 04/18/13 01:07 PM Re: Using Multicurrency with AP [Re: Patricia B.]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
It bothered me that the AP is not displaying the Currency Rate automatically, and I do not think that this is how it should work. All the multi-currency settings are setup properly.

So, I went into the Multi-currency Sample Data and after many tests and poking around, I found what we are missing.

The Control Account screen has to be completely filled in, otherwise the Rate does not calculate automatically.

We had the "Exchange rounding error" field blank. I filled in the GL account, and now the Rates do kick in automatically.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#36654 - 04/19/13 08:20 AM Re: Using Multicurrency with AP [Re: Samuel Kopstick]
Bob Wisener Offline
Adagio Conductor

Registered: 03/19/02
Posts: 561
Loc: Vancouver, BC
Perhaps this is the same client that converted from ACCPAC. With any conversion, the supporting tables and options should be reviewed for accuracy. For example control accounts, banks, terms and company profile options. Perhaps that's why a blank exchange error acct/dept was introduced.
_________________________
Bob Wisener
Dakota Software

Top


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