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
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
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
Hi Sandeep,
Sorry to resurrect an old thread. But did you ever manage to resolve this problem?
I do not know eConnect guys but if you need this issue resolved I would suggest you open a support case.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156