Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Item level details in sales order with foreign currency customer will be updated automatically by using eConnect

(0) ShareShare
ReportReport
Posted on by 10

Hi Experts, 

I met an issue. I have a sales order that it's customer is setup with a foreign currency such as canadian customers (non US $) .When I need to update a sales order by eConnect , It will update some item level details like  site id , Price Level, Ship to address, and Shipping method  automatically .I didn't pass them in eConnect XML ,So it is strange they were updated to other value. I think it was caused by the foreign currency customer . Could anyone please help on this issue ?

Thanks.

Categories:
  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Item level details in sales order with foreign currency customer will be updated automatically by using eConnect

    Hi Reggie, 

    When you use the UpdateIfExists function you are replacing the whole line with your new changes.  So there is a chance that if you do not pass in certain parameters in your XML, they would be changed to the default parameters for the Customer ID/Item that is being inserted which may not match what was originally entered.  

    From the eConnect Programmers guide it shows this for the parameter: 

    <taSopLineIvcInsert>*

    Element name

    Data type

    Length

    Required

    Default

    Description

    UpdateIfExists

    i4

    2

    N

    0

    Used to add or modify existing documents; 1=Add/modify—entire line will need to be resent

    My guess is that maybe these foreign Customer IDs have some out of the ordinary defaults or something that is making them change from what was originally entered or integrated on the sales document since you are not mapping them in your XML when you do the update. 

    I hope this helps!

    Isaac Olson

    Microsoft Support  

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans