Skip to Content
0
Jun 05, 2020 at 09:41 AM

field change log in Sales order Document in SAP Business One

113 Views

Hello Experts,

I have one filed in Sales order i.e "Report to production Date".if any one update this filed i want the update date for this filed only.

if user is update any of the filed in Sales order other than this field (Report to production Date) . i don't require any change log.

if user is change the perticular filed than only i need this change log with update date.

My Query :

declare @fdate datetime declare @tdate datetime set @fdate=:FromDate set @tdate=:ToDate select distinct t0.DocNum ,t2.lastName + ' '+t2.firstName 'SalesOrder Owner' ,t0.CardCode ,t0.CardName ,t1.ItemCode ,t1.Quantity ,t1.U_dPrdConf 'Confirmed delivery date' ,a.U_FE_REPDATE 'Report Production Date ' ,a.updatedate 'Report Date field fulfilled' from ORDR t0 inner join RDR1 t1 on t0.DocEntry = t1.DocEntry left join OHEM t2 on t0.OwnerCode =t2.empID left join (select a0.updatedate, a1.U_FE_REPDATE, a1.DocEntry,a1.LineNum,a1.ItemCode from ADO1 a1 inner join ADOC A0 on a1.DocEntry = a0.DocEntry and a0.LogInstanc=a1.LogInstanc where a0.objtype='17' and a1.U_FE_REPDATE<>'') a on t1.DocEntry = a.DocEntry and t1.LineNum =a.LineNum and t1.ItemCode =a.ItemCode where t0.CANCELED = 'N' and t0.UpdateDate >=@fdate and t0.UpdateDate<=@tdate

please help on this issue.

thanks,

Pratap