Open Forum

Expand all | Collapse all


  • 1.  Multicurrency

    Posted Nov 08, 2018 03:22 PM
    Would it be ok to use Integration Manager to import a Chart of Accounts
    from a z-US$ (functional currency) to a newly created company's COA with z-AUD functional currency?


    Sheila Hale
    Business Applications Support Analyst

  • 2.  RE: Multicurrency

    Posted Nov 08, 2018 04:58 PM
    Great question!
    Are you importing the account numbers only or are you also including history?

    Steve Burney
    GP Administrator
    Nissan Trading Corporation Americas
    Smyrna, TN United States

    Chairman, Nashville (TN) GPUG Chapter
    GPUG Ruby Award 2018
    GPUG All Star 2017
    Twitter @SteveBurney

    GP2016 R2

  • 3.  RE: Multicurrency

    Posted Nov 08, 2018 05:08 PM
    Only Account Numbers.  Fresh company with no transactions at all.

    Sheila Hale
    Business Applications Support Analyst

  • 4.  RE: Multicurrency

    Posted Nov 12, 2018 12:43 PM
    ​Hi @Sheila Reed

    You can import the COA to the company that does not use USD as their functional currency. If you are going to be reporting transactions in this company in USD the Select Account Currencies window has to be populated:

    My apologies for not being able to answer this as I am not well versed in IM, but if the import includes this window/field it will save having to create a Macro or manually enter this information after the import.

    Shari Bruno
    Accounting Operations Manager
    Bible League International
    Crete, IL

  • 5.  RE: Multicurrency

    Posted Dec 18, 2018 11:47 AM
    Thank you so much for the reply Sharon.  I will work on trying that option.  Can anyone tell me if PSTL "company copy"  may also be an option for this? To copy a USD functional COA to a different functional currency company (brand new company) by just copying the FINANCIAL module info? I would like just the COA accounts structure/accounts brought over.  No actual historical entries or anything.

    Sheila Hale
    Business Applications Support Analyst

  • 6.  RE: Multicurrency

    Posted Dec 19, 2018 02:14 PM
    Hi @Sheila Reed,

    Which version of GP are you using ?  PSTL is not able to re-assign a different currency on the fly while copying a company, because it will only offer you to select to copy the "Financials" setup without any other options. To copy the basic setup only, just leave the 'Data' checkbox blank.
    However, you can go after the copy into the new company and use the Currency Account Mass update function to change the currency of your accounts.. That should definitely do the trick.

    Financial >> Cards >> Financial >> Currency Account Update
    Use the Multicurrency Mass Account Update window to update a range of existing accounts with multicurrency information. You can select a range of accounts to mark for revaluation, update the translation method or assign additional currencies to the accounts.

    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)

  • 7.  RE: Multicurrency

    Posted Dec 19, 2018 04:24 PM
    We are using 2015R2. Basic setup is all I need copied if it includes COA.   And being able to make the new company's functional currency AUD vs USD (the originating company is USD as functional).  I will try your suggestion.  Thank you!

    Sheila Hale
    Business Applications Support Analyst

If you've found this thread useful, dive deeper into User Group community content by role