eConnect, GL Transactions & Multicurrency

What I’m posting today is hopefully of use to someone out there who runs into this same problem.  Admittedly it’s rare but it took me a while to find the answer.

In this case, “I” didn’t find the answer, I found it buried in a community forums post from Sivakumar, one of the Microsoft Dynamics GP MVPs.

The Issue

I was attempting to import General Ledger transactions using eConnect via SmartConnect.  My client had multi-currency enabled and there was a default currency in place already (CAD). When you manually keyed in a journal entry, the currency ID defaults to CAD (in this customer’s case), you don’t have to select a currency.

When I was running the integration, the transactions were successfully created but the Currency ID field was blank.  Since it’s a required field, that meant manually updating them each time – not a long term solution.

The Resolution

Thanks to Sivakumar, for the resolution.  It turns out that eConnect for whatever reason cannot check to see if Multicurrency is enabled, therefore it checks the CM00100 (Chequebook Master) table instead, to see if MC is enabled.  Strange but true.  What that meant was in order for it to determine what it needs to, at least one chequebook must be configured.

In this client’s case, we were importing transactions for a holding company where they don’t use A/P or A/R at all, so they had never set up a chequebook for it.  In the past, pre-SmartConnect, Integration Manager had imported things just fine but it was slow and time for something more robust – eConnect and SmartConnect was the answer.

So we simply configured a dummy chequebook for this holding company, and from then on, the transactions imported with a proper default currency ID!

The alternative would have been to hard-code the currency ID but in this case, it was nice to find the actual cause and fix it, instead of hard-coding a value that could change.

(originally posted on, and migrated to this site in October 2017)

4 thoughts on “eConnect, GL Transactions & Multicurrency

  1. Reply
    Sivakumar Venkataraman - March 17, 2012

    Glad I was able to help and my community response was useful to you… 🙂

    1. Jen Kuntz - March 23, 2012

      It was, thank you! : )

      Glad to share it with more people too. I’ve updated the post to include links to your blog, I forgot to do that in the first place!

  2. Reply
    James - December 13, 2018


    You hit in the FIRST TRY what my client’s problem was. Here we are SIX YEARS LATER and eConnect 2016 STILL has the same problem. You just saved me a TON of time, thank you!


    1. Jen Kuntz - December 13, 2018

      Thanks James! You made my day with that comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top