Travis,
You are exactly right. When issuing in the inventory application it does not take into account reservations. But, when issued from the work order application and selecting reserved items to issue from everything updates properly. We've been struggling with this for a number of yearsL Now to clean up our mess and start with the new and improved procedure! I'm excited to get there.
Thanks,
Gina Ordaz
Procurement Manager | Idaho Milk Products
Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us
Original Message:
Sent: 4/9/2024 10:48:00 AM
From: Travis Herron
Subject: RE: Reserved Items
Interesting; I don't think I've ever done it that way, so I'm intrigued to see what you find. Just trying to take a look at it, doing it that way, the Inventory application calls the Issue Current Item dialog box, which is built on a Relationship called ISSUECURRENTITEM. The ISSUECURRENTITEM non-persistent table, judging by the fields/attributes it includes (that is, I'm not looking at JavaDocs), doesn't have anything that makes me think it is looking at or considering Reservations. Other ways that we typically issue parts, such as Issues & Transfers or on Work Order Actuals, use a relationship to the MATUSETRANS table, which does have a Reservedqty field.
So I suspect issuing it from an Inventory record isn't considering Reservations at all, and that's why you're getting the result you're getting. But I could be wrong, never tried it in real life.
------------------------------
Travis Herron
Pensacola Christian College
------------------------------
Original Message:
Sent: 04-09-2024 10:22
From: Gina Ordaz
Subject: Reserved Items
Travis,
You are correct that our Org setting is set to "On Complete". I think that the inventory clerk is issuing direct from the inventory screen. I'll do some trials using different methods in our test system to see if any specific method releases the reservation. Thanks for the help.
Thanks,
Gina Ordaz
Procurement Manager | Idaho Milk Products
Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us
Original Message:
Sent: 4/9/2024 8:48:00 AM
From: Travis Herron
Subject: RE: Reserved Items
As Christopher has pointed out, definitely check the Org setting. It sounds like you already have that set to "On Complete." Other than that, AFAIK, a reservation should end when the Item is issued in the correct (the reserved) Quantity from the correct Storeroom. So it kinda sounds like maybe there's something astray in the process -- most likely issuing it from a different Storeroom.
I'd look into this: when Procurement/Inventory makes the issue transaction, how are they doing it? Which UI screen (Work Order Tracking --> Actual Materials, Issues & Transfers, Inventory --> Issue Current Item, Inventory Usage record)? Which buttons are they using (New Row, Select Reserved Items, etc.)?
Are you seeing this problem on every Reservation, or just some? If just some, you'd have to find the common pattern. Look closely at the Storeroom, Quantity, Conversion factor, logged-in user, Itemnum, and what "billing info" was used -- assetnum, location, gl account, wonum.
------------------------------
Travis Herron
Pensacola Christian College
Original Message:
Sent: 04-08-2024 15:19
From: Gina Ordaz
Subject: Reserved Items
We're using Maximo 7.6.2. We're using PM's to reserve items. When items are issued to the PM/WO, unless the status of the WO is changed to complete the item remains reserved.
Has anyone else had this and other than changing the status of the work order, once the items are issued to the work order, have you been able to get the reservations to update without changing status of the work order?
In our case, procurement/inventory issues the items to the work order. But until the status of the work order is changed to complete the item is still reserved for that work order.
Any help you can give would be appreciated.
Gina
#Procurement
------------------------------
Gina Ordaz
Idaho Milk Products
------------------------------