Information lost when tried to update an existing SOP Order detail info with eConnect 12

(0) Share

Report

Posted on by EllaL

Hi All,

When i tried to update an existing sales order detail info using eConnect 12, i found that the following information is lost.

-ALL Markdowns (aka Discounts) get removed from all line items

-Country Code gets removed from all line items.

Questions:

1. It seems that the line item is deleted first and then recreated when updating the SOP Order detail info using eConnect. Is it right?

2.If i want to keep the initial Markdowns(Disaccounts) and Country code info, how could i do?

Thank you.

*This post is locked for comments

All responses (22)

Answers (1)

soma 24,406 on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Have you separately posted (community.dynamics.com/.../135985.aspx) this issue in Community Forum?
EllaL on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Thank you very much for your reply.
soma 24,406 on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Just now I have tried this on my environment and got the same result (CCode is missing). I will keep trying and let you know once I get the solution for this issue.
EllaL on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

I have ever tried this on via eConnect schema instead of using SQL stored procedure, and the country code is also missing. As the pre script has been modified in my test environment, i use the SQL stored procedure to do some more research on this issue to ignore the effect which maybe caused by the modification of the pre script.

Thank you.
soma 24,406 on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Ellal,

I will check this on my environment and let you know once find the solution for the same.

Additionally, Have you tried this on via eConnect schema without using SQL stored procedure?

Keep posting!!!
EllaL on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

After i ran the store procedure to update the item quantity from 2 to 3...
EllaL on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Sorry, i made a mistake when posting the detail info, and the country code is there before updating. Right screenshot has been posted, please have a look. Thank you.
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Based on your screen shot the CCODE is also empty in SQL before updating the order ORDST2338.

Please click the arrow mark near by the Ship To Address ID in SOP line details and check whether the CCode is available.

Hope this helps!!!
EllaL on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

The related detail information is as follows:

The initial sales order info:

The customer info:

The ShipToAddress Info:

The initial info in my company database:

The parameter info when calling the storeprocedure 'taSopLineIvcInsert':

Info after updating:

The "CCode" value is missing, while other address information is kept including the value of "Country" field.
soma 24,406 on at

Like (0)

Report

RE: Information lost when tried to update an existing SOP Order detail info with eConnect 12

Click the arrow near by "Ship To Address ID" on the SOP line details window and check whether the Country Code is available.