Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Tasoplineivcinsert StoreProcs update Exchange Rate?

Posted on by 18,265

Hello Team,

I am using the storeProcs 'Tasoplineivcinsert'  to update the SOP line Items only.  It seems to be when the line Item get update for Multi Currency Transactions it goes and create new Exchange Rate too.

Is there any way we can stop it? 

FYI- I do not want to use the eConnect C# to just update the line as I have to pass all the information i.e. Header and Line Details.  Currently I am updating the Location only using 'Tasoplineivcinsert'.

Thanks much
Sandip

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Tasoplineivcinsert StoreProcs update Exchange Rate?

    I am at this point searching for some obvious plan.

    MyCCPay Login

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Tasoplineivcinsert StoreProcs update Exchange Rate?

    From what Microsoft tells me if you set UpdateIfExists on the line you must also set UpdateExisting on the header. This forces eConnect to completely rebuild the document. I will be honest this was a painful experience. You set fields and then perform an import and see what works and what does not work. Eventually you will have a working solution.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Tasoplineivcinsert StoreProcs update Exchange Rate?

    Hello Richard,

    Much appreciated for your reply.  I am doing the update only on line items for Location change.  Do you still think it recreate the Header Record as well as inert new Exchange Rate in GP?

    Thanks much

    Sandip

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Tasoplineivcinsert StoreProcs update Exchange Rate?

    I had a similar issue when all I wanted to do was update quantities. I found just calling Tasoplineivcinsert was not enough. I have to insert the header as well.. It seems that eConnect will delete the header and reinsert it so it is almost as if you were creating the invoice for the first time.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans