Open Forum

Expand all | Collapse all

Functional Currency

  • 1.  Functional Currency

    Posted 01-05-2016 10:01 AM

    Our Sales Transaction Entry documents (Quote, Order, Back Order, Invoice, Return) and the types of Receivables Transaction Entry documents that we utilize (Sales/Invoices, Debit Memos, Finance Charges, and Credit Memos), are not populating the Currency ID.  The Currency ID field is actually grayed out, so the Currency ID cannot be entered.

    Our Setup:
    Version - GP 2013 (SP 2)
    We use eConnect
    We do NOT use Multicurrency

    All documents should have the Currency ID field automatically populated with Z-US$.  We need the Currency ID field to populate, as an ISV product requires the Currency ID.  The ISV product pulls the Functional Currency from GP, and then it compares that Functional Currency to the Currency ID on the document.  Since the Currency ID on these documents is blank, the transaction fails.

    Where in Setup is the Functional Currency defined, and how do I ensure it is populated in the Currency ID field on each document?

    Thank you,

    John James

    ------------------------------
    John James
    Dolese Bros. Co.
    Oklahoma City OK
    ------------------------------


  • 2.  RE: Functional Currency

    GPUG ALL STAR
    Posted 01-06-2016 08:25 AM

    John,

    Normaly you don't have  a choice... if you want those fields populated, you need to enable the multi-currency in GP... but Microsoft published an article back in the GP 10.x days about setting up functional currency when not registered for MC..

    https://support.microsoft.com/en-us/kb/861642

    Please note that if you use Management Reporter 2012, you have to leave the MC enabled, otherwise MR is going to throw errors when retrieving data.

    https://community.dynamics.com/gp/f/32/t/99657

    Hope this helps.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP MVP
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    +1-514-489-4267
    @GP_Beat http://dyngpbeat.wordpress.com/



  • 3.  RE: Functional Currency

    Posted 01-06-2016 02:42 PM

    Unfortunately, in order to have a currency show up, you need to turn on Multi Currency.
    This will assign a Functional Currency to the company in MC40000.
    There are a bunch of things that need to be done when you do this, among them:
    -Assign the Z_US$ to your company/companies.
    -Run reconcile for financials.
    -There are other issues to consider, so consider this with care.

    If you plan to ever be supporting multiple currencies I suggest creating the real ISO currency ID of "USD", and assigning that.

    If you never plan to use multiple currencies then talk to the ISV to see if they can resolve this.

    The other idea would be to use VBA to populate the Sales Transaction currency field and also populate the MC40000 with a dummy record creating the functional currency .  This might be a work around.

    Don

    ------------------------------
    Don Pugh
    GP Consultant
    Sandon Associates
    Woodside CA