eConnect - Do Not Add Exchange Rate to Table

(0) Share

Report

Posted on by Community Member 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

All responses (5)

Answers (0)

KBRESULT111 5 on at

Like (0)

Report

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 1,337 on at

Like (1)

Report

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 115 on at

Like (0)

Report

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?
Jonathan Fear on at

Like (0)

Report

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 751 on at

Like (0)

Report

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.