web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Ship to Address Roll D...
Microsoft Dynamics GP (Archived)

Ship to Address Roll Down not Working

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,850 Moderator

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

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    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.

     

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    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 Foster Profile Picture
    Tim Foster 8,515 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans