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

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) / SO Reqequsted Ship Dat...
Microsoft Dynamics GP (Archived)

SO Reqequsted Ship Date - Should it fill down or not???

(0) ShareShare
ReportReport
Posted on by Drew Brassard 255

In our GP 10.0 system, if you change the Requested Ship Date header it does not fill down to the Requested Ship Date on the line items.   Ship Method does, but Requested Ship Date does not.  The issue is that we can't figure out if it use to or whether it stopped working when we installed ISV solutions.  We're just starting the implementation so no one knows or can remember and i'm getting conflicting information from various parties.  If anyone responds and says it works in their system then at least I'll know if does fill down.

*This post is locked for comments

  • Dwight Brown Profile Picture
    Dwight Brown 5 on at

    The requested ship date only rolls down to the lines at the time that the order is created.

    One method to roll down requested ship dates from the header to the lines would be in a SQL Server trigger. The following trigger would do the trick, but needs more thorough testing. It checks to make sure that the Requested Ship Date was changed on the header. It also will only change the Requested Ship Date only if it doesn't already match the header.

     

    Use [COMPANYDB]

     /*  put whichever DB you want to apply the trigger to inside of the brackets */SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:                            Dwight Brown, Systematica, Inc.-- Create date: 10/10/08-- Description:   Rolls down the reqshipdate from the header to all lines-- Only rolls down if the date on the header has changed-- =============================================CREATE TRIGGER tr_SOP10100ReqShipDateRollDown   ON  dbo.SOP10100   AFTER UPDATEAS BEGIN                -- SET NOCOUNT ON added to prevent extra result sets from                -- interfering with SELECT statements.                SET NOCOUNT ON;               

                    IF UPDATE(ReqShipDate) --

    /*this ensures that the ReqShipDate was actually changed during this database update, trying to prevent excessive writes*/

        BEGIN                                                 UPDATE LineItems set LineItems.ReqShipDate = Header.ReqShipDate                                                FROM SOP10200 LineItems INNER JOIN                                                SOP10100 Header on LineItems.SOPNumbe = Header.SOPNumbe INNER JOIN                                                Inserted On Header.SOPNumbe = Inserted.SOPNumbe                                                Where Header.ReqShipDate <> LineItems.ReqShipDate

                                                    /* Aliases used here in order to allow an update with joins */

    END                ENDGO

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans