Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[John Ellis]

Hello:

I haven’t received a response from the Community Forum.  So, I thought that I would post, here.  I apologize.

We have twenty-one companies, in GP.  Most are US-based, but several are international.

We are going to be importing sales transactions into our US-based company as US Dollars and would like for GP to convert these amounts into British Pounds when these amounts “land” in this GP company as Sales Order Processing batches. 

Subsequently, we’ll want to post these sales batches in Pounds and have any reporting on these transactions in Pounds.

I believe that this is possible, based on our Multicurrency environment in GP.  But, I want to check.  Indeed, is it possible to process international currencies in US-based companies in GP and have the amounts posted in currencies other than US Dollars including for reporting purposes?

Thank you!

John

——————————
John Ellis
Financial Systems Manager
HireRight, LLC
Irvine CA
——————————

[Sean Reynolds]

What tool are you using to bring the SOP documents into GP?

——————————
Sean Reynolds
IT Accounting Manager & MS Dynamics GP System Administrator
Atlantic Aviation
Plano TX
————————————————————————-

[Beat Bucher]

Same Question.. .what’s the tool you’re going to use … Multi-currency is fully supported.. in our case we do use SmartConnect and do import montly GL transaction, but have to specify the currency.

So I’d say it depends on the tool & the eConnect defintions, if you can specify the currency.  If your MC is properly setup, there should be no issues.

——————————
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/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
————————————————————————-

[Bill Marshall]

So you’re integrating the Functional Currency Amount and want GP to do the Functional to Originating conversion.  I pretty sure that anything built on eConnect won’t do that conversion for you, but I’m not 100% sure. Microsoft would have had to create the currency conversion code in SQL and I don’t think they did that. 

——————————
Bill Marshall
President
mc²
————————————————————————-

[John Ellis]

Hi All:

My apologies, for the delayed response.

We use Scribe.

Regardless, please let me know if what we envision can be done.

Thank you!

John

——————————
John Ellis
Financial Systems Manager
HireRight, LLC
Irvine CA
————————————————————————-

[Rob Klaproth]

E connect requires a currency ID if you are using multi currency. Therefore it should do the conversion, i.e. If the functional currency is us $ and your originating currency ID is EUR then you will see a conversion happen on that transaction assuming your currency rate tables are all in order. 

I do not think it will go inverse.  There are not multiple fields there is only one currency ID field and econnect treats it just like you are entering the transaction in GP and you select that currency ID in the window it will convert from the ID you select to the company you are logged into. 

Sent from my iPhone

——Original Message——

Hi All:

My apologies, for the delayed response.

We use Scribe.

Regardless, please let me know if what we envision can be done.

Thank you!

John

——————————
John Ellis
Financial Systems Manager
HireRight, LLC
Irvine CA
——————————

[Bill Marshall]

Rob,

I think John is saying that he wants to bring in the data with a $US amount but have the transaction appear as a BPS transaction.  This means that the Currency ID field would have to be BPS, and if that’s the case, I believe that GP will assume the amount fields are also in BPS. Am I understanding this correctly?

——————————
Bill Marshall
President
mc²
————————————————————————-

[John Ellis]

Yes, Bill, you are! 

In fact, prior to posting this question, I had partially tested this by manually entering a transaction as GBP in the US-based company (in a test environment).

Indeed, the transaction posted and was reported on in Pounds.

So, based on what you’re saying, it sounds like what I’m envisioning will work.  Correct?

John

——————————
John Ellis
Financial Systems Manager
HireRight, LLC
Irvine CA
————————————————————————-

[Bill Marshall]

Of course, you should test this first, but I think eConnect will assume the values are PBS not USD.  When you manually enter the transaction in GP, you have the ability to view the functional and originating amount, but you may not have that flexibility with eConnect. You may need to use the PBS amounts when you bring them in via Scribe.

——————————
Bill Marshall
President
mc²
————————————————————————-

[Gerald Clement]

What I do is manually enter a transaction and look at the tables in a data browser. SOP and most of the rest of GP Tables will store multi currency transactions in the transaction and company base currency.

If you replicate the data fields from a manually entered transaction it will post with no issues.

——————————
Gerald Clement MBA
Dynamics GP 1993, Dexterity 1995
Computer Productivity Services Inc.
cps@cpsinc.ca
————————————————————————-