Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Ship to Address Roll Down not Working

Posted on by 75,730

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

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Ship to Address Roll Down not Working

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Ship to Address Roll Down not Working

    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.

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: Ship to Address Roll Down not Working

    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.

     

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans