on 11-01-2014 2:40 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.