TR_SALESORDER_UPDATE_TRANSACTIONDATETIMEWITHOFFSET (Trigger)

                
                    CREATE trigger TR_SALESORDER_UPDATE_TRANSACTIONDATETIMEWITHOFFSET on dbo.SALESORDER after insert,update not for replication
                    as begin
                        set nocount on;
                        
                        if update(TRANSACTIONDATE)
                            begin
                                update dbo.SALESORDER set TRANSACTIONDATEWITHTIMEOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(inserted.TRANSACTIONDATE, 0),
                                        CHANGEDBYID = inserted.CHANGEDBYID,
                                        DATECHANGED = getdate()
                                    from dbo.SALESORDER SO inner join inserted on SO.ID = inserted.ID                        
                            end
                        
                    end