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

(0) Share

Report

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

All responses (1)

Answers (0)

Dwight Brown 5 on at

Like (0)

Report

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

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