I have a series of sales orders where when I go and change the ship to address code on the header and then click Yes to roll down the changes, the address ID change will not roll down to the lines. I seem to have isolated it orders that have been imported via eConnect but when I run a DEXSQL.LOG or SQL Profiler I am unable to capture the SQL command that is executing this change. Can anyone tell me the name of the stored procedure that is called when clicking Yes to roll down changes. If I could see the code maybe it might provide insight as to the cause of this issue.
*This post is locked for comments
Richard,
You should also check the status of Flags both in the Header record and the Lines. Through the interface (front end) look for the little pencils near the address code fields. If the header Ship to is set to Secondary (no Flag) and the Lines are set to Secondary (with flag) the Rolldown will not occur.
Tim
The test order I have right now has the heading primary ship to address code as Primary and the lines are Primary. If I change the header to Secondary and click Yes to roll down the changes, the lines stay Primary. What you say makes sense as to why I do not see anything in the DEXSQL.LOG. Now I also noticed that the address code is not changing on the screen either so as I scroll thought the lines the address code has not changed.
Couple things.
This is Dexterity code so no SQL stored procedure though you could do a script log to see the dexterity calls. I did one and can see a call to 'RollDownHeaderAddress' with old and new values passed to the procedure in a composite string. This code would not get captured by dexsql log except the actual update to the sop10200 table on success but it does not sound like you get any updates so you would not see it.
I think the way it works is this. If I have three lines on a sales order with a ship to on the header of 'North', two lines that have a ship to of 'North' and one that is 'West' then changing North to East would only update the two lines that said North and they will now say East but West stays west.
See what your integrated orders have on the line for Ship To address, probably they don't match the header.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156