Change Log For BoM- SAP Business One

[joseph_antony]

Hello,

I'm trying to create a report for the change in quantity made on a BoM.

SELECT
T0.Code,
T1.Code,
T1.Quantity 'Current Qty',
T2.Quantity 'Old Qty',
T1.LogInstanc,
T2.LogInstanc,
T0.UpdateDate,
T3.USER_CODE 'Updated By'
FROM OITT T0
INNER JOIN ITT1 T1 ON T0.Code = T1.Father
INNER JOIN ATT1 T2 ON T2.Code = T1.Code
INNER JOIN OUSR T3 ON T3.USERID = T0.UserSign2
WHERE
T0.Code = '10596860'AND
DATEDIFF(DD,T0.UpdateDate, GETDATE()) <=1
AND T1.Quantity <> T2.Quantity

This report gives me multiple lines (I can see based on the T2.loginstance) and I would like to see only the latest change to the quantity made.

Also, how to get the details of components added or removed from the ITT1 Table?

Any assistance would be appreciated.

Regards,

Joseph

[joseph_antony]

Hi Lothar,

Thanks for your feedback.

I think it works, i;ll do some more testa dn share my feedback with you.

Do you also know how to track if rpws were added or deleted from the BoM? Is there a way to get this information as well?

Regards,

Joseph