cancel
Showing results for 
Search instead for 
Did you mean: 

Price Change Alert

richard_thurlow
Participant
0 Kudos

Hello,

I have 6 different price lists in SAP B1.

It has been known for the department that is supposed to alter all of the prices in the pricelists to forget one or two.

What I am wanting to do - is to setup an alert that should the price be altered in Pricelist 1 - then it should indicate the ItemCode, ItemName, Original Price, New price, Date Changed - such that I can double check that the prices in all pricelists have been altered.

I am unsure how to write a query to this affect.

Can someone please assist?

Regards

Rick

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rick,

Try:

SELECT T0.ItemCode,T0.ItemName, T1.Price, T2.Price

FROM OITM T0

JOIN ITM1 T1 ON T1.ItemCode=T0.ItemCode AND T1.PriceList = 1

JOIN AIT1 T2 ON T2.ItemCode=T0.ItemCode AND T2.PriceList=1

Where Getdate(dd,T2.UpdateDate,GetDate())=0

Thanks,

Gordon