on 05-25-2015 9:50 AM
Hi,
Before I run the schedule alert by displaying the min inventory level by item on specific WH.
But now I wish to run the query if the sum of the (sum of all WH).onhand < oitm.minlevel.
Can anyone please help.
Thanks
Hi Olga,
Please try below query and revert back.
Select A.ItemCode, A.ItemName, A.MinLevel, A.Onhand
from OITM A
Where A.MinLevel > A.Onhand
Thanks
Unnikrishnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you help me on this issue?
http://scn.sap.com/thread/3746845
Regarding the min level inventory as well.
Thanls
User | Count |
---|---|
86 | |
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.