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.
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
3815 Harrison AvenueCincinnati, OH 45211contact@moremaximo.com
Join CommunityInvite ColleaguesLearn MoreAbout UsTerms of Use