Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

eConnect - Do Not Add Exchange Rate to Table

Posted on by Microsoft Employee

The Multicurrency setup is to "Use Rates Without Adding to Table" and no password is specified.

When integrating a multi-currency sales invoice with exchange rate, eConnect adds that rate into the exchange table. Is there a way to stop eConnect from doing this? Completely messes up the exchange table, as we do not want these one off rates to be added into the table.

Workaround i could think of was to use a separate exchange table for these integrated invoices. Its a overhead, so was hoping that there is a way to prevent eConnect from adding to the table.

Thanks,

Sandeep.

*This post is locked for comments

  • KBRESULT111 Profile Picture
    KBRESULT111 5 on at
    RE: eConnect - Do Not Add Exchange Rate to Table

    I have just stumbled across this issue updating some prices in GP, using smartconnect that utilizes econnect adapters.

    I cannot believe that 10 years on this has not been addressed.

    We are ending up with dozens of ex rates going back 6 months, none of which are needed.

    madness

  • Suggested answer
    Andrew John Dean Profile Picture
    Andrew John Dean 1,337 on at
    RE: eConnect - Do Not Add Exchange Rate to Table

    Hi Ryan

    Probably not the best solution but a solution never-the-less, would be to place some business logic in the eConnect post-processing stored proc  (i.e  taXXXpost ).

    The SQL logic would look for the most recent entry in the table DYNAMICS..MC00100 and delete that record.

    Regards

    Andrew Dean

    Envisage Software Solutions

  • RyanSinfield Profile Picture
    RyanSinfield 115 on at
    RE: eConnect - Do Not Add Exchange Rate to Table

    Hi Sandeep,

    Sorry to resurrect an old thread. But did you ever manage to resolve this problem?

  • Re: eConnect - Do Not Add Exchange Rate to Table

    I do not know eConnect guys but if you need this issue resolved I would suggest you open a support case.

  • Jerry Higgins Profile Picture
    Jerry Higgins 751 on at
    Re: eConnect - Do Not Add Exchange Rate to Table

    Bump!

    My company is in this same predicament.  If there is any way to keep eConnect from creating new exchange rates, or at least throw an error (clumsly, I know) that can halt integration that would be helpful.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans