Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

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

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.

  • 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans