Saturday, July 28, 2012

MS Dyanmics GP10 Currency Setup

I was recently ask to setup a currency for a particular company. This is how it was done.
This article take for granted the fact that your would have already have setup your Exchange Gain Loss Acct and Financial Multicurrency Setup

Lets Begin!
Navigate to MSDynamics>>Tools>>Setup>>Financial>>Multicurrency Setup

Figure 1.1 Shows the Currency Setup (please note the Default Transaction Rate Type)
"Financial = AVERAGE ; Sales = BUY ; Purchasing = SELL"

Now that your know what are the mapped default rates for each module you now know that any foreign currency you setup much have these Exchange tables available.

Setting up a currency

MSDynamics>>Tools>>Setup>>System>>Currency

Figure 1.2 Shows the Setup for GBP currency. Please note the Accounts (bottom righthand side) need to be placed here.

Once this is completed the exchange table is next. As stated earlier an exchange table needs to be setup for each of your "default transaction rate type" eg. Buy Sell Average

MSDynamics>>Tools>>Setup>>System>>Exchange Table


Figure 1.3 Shows the Multicurrency Exchange Table setup. Please note a vaild rate needs to be enter (bottom righthand side).

Once you have created the currency and setup the exchange table you are almost done. Your last steps are the setup of the default rate types and grant the company access to the currency and associate exchange table.
To grant the company access to the newly created currency and associated exchange tables, all user must exit Dynamics GP and then you navigate to
MSDynamics>>Tools>>Setup>>System>>Multicurrency Access.
(no screenshot available sorry :( )
Within this window select the currency and check the grant privilege and do the same for the listed exchange tables.

Once you have granted the company access to the currency and exchange table click ok then navigate to MSDynamics>>Tools>>Setup>>Financial>>Rate Type


Figure 1.4 Shows the Multicurrency Rate Types. Please note the available rate types and the Selected rate types.

For this GBP BUY to function, I selected the buy rate and moved it to the selected rate type.
Now i can use this GBP currency and GBP BUY exchange table.