alerts for item master change and new item creation

[Former Member]

hai experts

my manager has to get an alert when any update has been done in item master or when a new item master is created .

[Former Member · Accepted solution]

Hi.........

Check this query for alert.........

Quaery for New Item Creation:

SELECT T0.[ItemCode], T0.[ItemName], T0.[CreateDate] FROM OITM T0
Where DateDiff(DD,T0.[CreateDate],GetDate())<2

Query For Updation of Item:

SELECT T0.[ItemCode], T0.[ItemName], T0.[UpdateDate] FROM OITM T0
Where DateDiff(DD,T0.[UpdateDate],GetDate())<2

Above two alerts will be coming for two days........

Regards,

Rahul

[Former Member · Accepted solution]

Can we Find what is the changes made

[Former Member · Accepted solution]

Yes you can fine......

If any changes made then open that Item and go to Tools and Change Log. This will give you all the updated changes with instances and dates......

Hey If you have solved your previous doubts then please do close those threads, mark it as answered and give points because there are limits of threads raising if any open.......

Regards,

Rahul

[Former Member · Accepted solution]

ok thanks

[rahulshinde69]

T0."ItemCode", T0."ItemName", T0."UpdateDate" Where DAYS_BETWEEN(T0."UpdateDate",CURRENT_DATE)<0