web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Multicurrency transactions and GP2010

(0) ShareShare
ReportReport
Posted on by 425

Hello,

I'm new to the world of multicurrency and would like to check how GP2010 handle this from the transaction level all the way to the Financials Statements, I have two companies doing business in UK and ASIA. There are both their own DB in GP2010 and do Business or invoice in client in more than just their funtional currency , at the end of the day all financials need to be in USA dollars so I'm trying to understand the following

1) Original Transaction Level Translation and subseguent revaluation of receivables if any?

2) Financial Reports translations from the following example

          a) Company in Uk , Functional Currency in Pounds does one invoice in YENS, so it gets converted to pounds , Do we have a receviable in YENS or in POUND? or does the receivable still in YENS until the invoices gets paid? therefore that is why the revaluation?

          b) Depending on the answer above do we need to setup a second DB for this company in order to have the final financials in USD?  so it goes from  XYZ currency transaction Level to POUND in their revaluation , them another DB to get them from UK Pound to US Dollars.

Any Help will be greatly apreciated.

 

Tony

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi Tony,

    GP Multicurrency works as you would expect.

    My thoughts on your first question:

    There are two types of currency - Functional Currency (The home currency of the company, in your case USD), and Originating Currency (The foreign currency - in your case, everything else).

    In the sub ledger (Receivables, Payables etc) you can add a transaction in any currency.

    If you add it in the Functional (USD) currency, then there is no problem, no translation to be done and no originating value to be maintained.

    If you add a transaction in any other currency, immediately GP will look for an Exchange rate beween this currency and USD. These exchange rates are maintained in FX Tables that you set up and maintain. There is a lot of functionality around these, but for now its enough to know they exist and you are responsible for maintaining them. (note that if GP cannot find a valid rate, then you can add one on the fly while creating the transaction).

    This transaction now has two values. The originating amount, and the functional amount (which was calculated by GP based on the FX rate). You can switch between displaying the functional or originating amount.

    So you post a sales invoice for GBP100.00 which equates based on that days FX rate of 1.5 to $150.00.

    When the customer pays, they pay GBP 100.00. However the FX rate between GBP and USD has changed. GBP100.00 is now worth $125.00 - so you have lost $25.00 due to FX rate fluctuation. When you apply the payment to the invoice in GP, GP calculates the FX gain/loss and posts a GL journal to reflect it (also, if you afterwards unapply the payment from the invoice, the FX effect is reversed). Note that once the originating amounts agree (GBP 100.00) then the Debtors account is cleared.

    The above are realised gains and losses - you actually have incurred them, since the customer did pay.

    At the end of a month, you might look at your outstanding sales invoices and want to revalue them as at the FX rate for the end of the month. GP has a revaluation process that does just this - calculating an unrelised gain or loss, which again is reflected in your GL.

    My thoughts on your second question:

    a) - the transaction is maintained in both Yen and Pound values (it has an originating and functional currency amount which you can swap between when looking at the transaction).

    You can revalue an unpaid invoice to create unrealised Gains and Losses...or once you apply a payment to the Invoice GP generates a realised gain/loss.

    b) - If your UK company has a home currency of GBP and you require reports in USD, GP has a third currency term called Reporting Currency. You can set a reporting currency and record the spot FX rate between this and the functional currency at a point in time. Thus, your reports will be converted at this spot rate.

    So, for your UK company:

    Functional Currency = GBP

    Reporting Currency = USD

    All other currencies are known as Originating Currencies, and an FX table with valid rates needs to be mintained so GP can convert them to GBP.

    Hope this explains. There is a lot in Multicurrency, but as I said, it works as you would expect.

    Best regards,

    Ian.

  • Eric Nixon Profile Picture
    120 on at

    In follow up to the above, let's say there is a US parent and GBP subsidary (each with own database). We must produce a set of consolidated statements in the US in USD (to include the GBP subsidary).

    How is this done in GP? When you translate the PL at average and BS at spot, does GP know to "plug" the exchange rate difference in AOCI/Equity in accordance with accounting rules?

  • Community Member Profile Picture
    on at

    The quick answer is that no, GP doesn't know straight off.

    Typically, customers adopt the approach to use FRx or MR to consolidate company financial statements. You would set the FRx column for example to use specific rates for the P&L accounts (average) and the BS accounts (Spot). Then create a calculation that calculates the balancing figure and includes this calculated amount in the AOCI/Equity account row in the report.

    Ian.

  • Community Member Profile Picture
    on at

    Hello Ian,

    I have set up Multicurrency on test box, I can enter transactions in reporting currency form sub-ledger like AP and Sales. But when I tried to enter transactions in General Ledger with reporting currency it is only showing me the $ currency symbol. And I cannot see any distribution for in reporting currency. Will you please advise on this.

    Thanks Sanjay Parab  

  • RCilli Profile Picture
    on at

    Where I am getting stuck in the process is the point of cash receipts.  My situation:

    1. So we are going to bill a client in GBP, I understand that because my functional currency is USD it will translate to USD when the transaction is posted based on the exchange rate entered during that time period.

    2. Now the client is going to issue payment to us in GBP - however our bank account is in USD so our bank will convert the funds and take a fee.  Which means that my cash receipt is going to be in USD.  How do I then properly enter the cash receipt in USD, recognize the loss/gain on exchange and close out the invoice as paid in full?

    Thanks,

    Rachel

  • Community Member Profile Picture
    on at

    If the exchange is a loss, post the payment as received from the bank and "write-off" the difference to your Gain/Loss account.

    $100 Voucher in USD

     - 80 Cash Receipt (as translated by bank)

     - 20 write off to Gail/Loss

    If the exchange is a gain, enter another Voucher to the Vendor (in USD) and post the amount to your Gain/Loss account.

    $100 Voucher in USD

    +  20 Voucher in USD

    + 120 Cash Receipt (as translated by bank) applied to both Vouchers

  • Community Member Profile Picture
    on at

    Hi Ian,

    I know this is a very old comment, but could you elaborate on your 'create a calculation that calculates the balancing figure and includes this calculated amount in the AOCI/ Equity account row in the report'? My client uses MR CU8 and GP 2013 SP2 and are building a statutory consolidation in MR (with specific consolidation GP company) and finding this exchange rate difference tricky. With legacy connector and the Historical translation type, translated beginning balances have to be entered using the currency translation routine for example their share capital. They want to maintain historical translations, but I can only think to do this by running year end balances in MR and using the translated balance with the functional currency balance to give a historical exchange rate that can be used for translating beginning balances? Then within MR, they can use a calculated column to calculate balances at the current rate to calculate the difference. Is there a better more automated way to do statutory consolidations in MR?

    Thanks,

    Annabel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans