Hello!
We wanted to capture the original shipdate (tsosolinedist.shipdate) entered into the system, so that when this value gets updated we can track how many days out from the original date we are.
So near the end of the insert trigger for tsosolinedist, I added the following code:
declare @shipdate datetime
select @shipdate = shipdate from inserted
insert into tsosalesorderorigshipdate_exi (solinedistkey, origshipdate)
values (@newkey, @shipdate)
It works! However it's only capturing one line item per sales order. What can I do to make it capture all lines?