issue of making the invoice date default to one of the user defined dates from the originating order.
1 comment
May 20th of '10 at 01:16 PM
From JonWire
Currently proposed solution as posted by Sagi88:
CREATE TRIGGER [Invoice_DOCDATE] ON SOP10106 FOR INSERT AS
Update SOP10100
Set DOCDATE = SOP10106.USRDAT02
From SOP10100, SOP10106
Where SOP10100.SOPTYPE = SOP10106.SOPTYPE AND
SOP10100.SOPNUMBE = SOP10106.SOPNUMBE AND
SOP10106. SOPTYPE in (select SOPTYPE from inserted) and
SOP10106.SOPNUMBE in (select SOPNUMBE from inserted) and
SOP10106.SOPTYPE = 3
CREATE TRIGGER [Invoice_DOCDATE] ON SOP10106 FOR INSERT AS
Update SOP10100
Set DOCDATE = SOP10106.USRDAT02
From SOP10100, SOP10106
Where SOP10100.SOPTYPE = SOP10106.SOPTYPE AND
SOP10100.SOPNUMBE = SOP10106.SOPNUMBE AND
SOP10106. SOPTYPE in (select SOPTYPE from inserted) and
SOP10106.SOPNUMBE in (select SOPNUMBE from inserted) and
SOP10106.SOPTYPE = 3
Sign in to comment.