This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I've tried to built an sql statement in which the system will retrieve the items that have a current balance that is less or equal than the reorder point ('curbal' <= 'minlevel'). Whenever I run this query through a where clause the system retrieves all the items or if I remove the single quotes from the statement I will get an error. I'm not sure how I'm suppose to built the query.
Dear,
This what you should type in the where clause of inventory application:
minlevel > (select sum(curbal) from invbalances where itemnum=inventory.itemnum and location=inventory.location and siteid=inventory.siteid)
Best regards,
Amir Anwar
Senior Software Engineer
Beshay Steel Egypt
________________________________
From: shirleyfanmail <shirleyvelez.pmtech@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Tuesday, June 11, 2013 6:38 PM
Subject: [MAXIMO List] Inventory Report
I've tried to built an sql statement in which the system will retrieve the items that have a current balance that is less or equal than the reorder point ('curbal' <= 'minlevel'). Whenever I run this query through a where clause the system retrieves all the items or if I remove the single quotes from the statement I will get an error. I'm not sure how I'm suppose to built the query.