web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect - Do Not Add ...
Microsoft Dynamics GP (Archived)
Suggested Answer

eConnect - Do Not Add Exchange Rate to Table

(0) ShareShare
ReportReport
Posted on by Community Member

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

  • Jerry Higgins Profile Picture
    Jerry Higgins 751 on at

    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.

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

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

  • RyanSinfield Profile Picture
    RyanSinfield 121 on at

    Hi Sandeep,

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

  • Suggested answer
    Andrew John Dean Profile Picture
    Andrew John Dean 1,337 on at

    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

  • KBRESULT111 Profile Picture
    KBRESULT111 5 on at

    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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans