Open Forum

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
------------------------------

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/

Original Message:
Sent: 01-05-2016 10:01 AM
From: John James
Subject: Functional Currency

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
------------------------------

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

Original Message:
Sent: 01-05-2016 10:01 AM
From: John James
Subject: Functional Currency

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
------------------------------