Maximo Open Forum

 View Only

 Need to create query to show Expired Items on Result Set

Jump to  Best Answer
  • Inventory
Naveed Wasay's profile image
Naveed Wasay posted 02-17-2026 01:39

Hi,

I am trying to create a query to track expired items which are marked as LOTTED.

But INVBLANCES.USEBY is non persistent and cannot queried or displayed on Start center.

Any work around possible

-Naveed

Steven Shull's profile image
Steven Shull posted 02-17-2026 08:19  Best Answer

You need to setup a report object structure that includes the INVLOT object as a child object of INVBALANCES. Because this is a 1:1 relationship, you can safely display this on the start center result set. This is where Maximo stores the expiration information for an item based on its lot. 

Related Content