Hi. Hope someone can help.
I want to close off a very old subinventory that is no longer used. It's holding stock at the moment, but the items aren't available to transact or reserve and I don't know why. They're not reserved and there's no outstanding supply/demand. It looks like the stock was put there during a warehouse migration 5 years ago and no one's been able to clear them out in subsequent moves. What I want to is either issue the stock out or transfer it to a valid subinventory. Alternatively, just purging the lines would be better than the current state. Ideally, I want to do this via forms.
The items themselves look OK, and we've been transacting them in our current subinventories, so I'm presuming it's something to do with old codes being closed off elsewhere. I just don't know where to look.
One of the items originated from a PO Receipt, so I thought I'd try a return to lower the figure at its source, but I get the "The transaction quantity 1 in primary unit of measure exceeds the available quantity 0 in the subinventory", so that's hitting the same wall.
So how can I get rid of this stock?
Thanks for the suggestion, but I keep getting error messages such as "you are trying to perform physical inventory adjustment for material that has reservations/allocations against it". But I can't find any reservations or allocations against them.
For example, for one item, I see 196 items receipted, then 195 items transferred to a different subinventory. Either they missed 1 in error, or it was already reservered/allocated somewhere. But that's all I can see. mtl_reservations doesn't have anything for it. OM doesn't show anything for it. Supply/Demand doesn't show anything.
I can only presume that I can't transact or reserve the item because the subinventory or location it's in doesn't allow me to. Still stuck.
Thanks though :)
This is good - I've at least found the transactions holding things up. They are in mmtt, but they're not in the interface.
I can see them in Pending Transactions, but that form is protected.
The data I'm seeing is...
Transaction Date 13/06/2002 11:22 05/08/2002 15:02
Transaction Temp ID 461078 1051018
Org Code YAT YAT
Subinventory Stock Stock
Transfer Subinv Suspect Despatch
Locator 4R07B 4R14D
Item INDICATOR-0004-3-000 MS2/3-0069-4-SPC
Revision 0 0
Transaction Qty 1 11
Transaction UOM EA EA
Transaction Status Allocated Allocated
Transaction Source Type Move order Move order
Transaction Type Move Order Transfer Move Order Transfer
Transaction Action Subinventory transfer Subinventory transfer
Transaction Mode On-line processing On-line processing
Process Flag 1 1
TRANSACTION_SOURCE_ID 39 233
Transaction Source Line ID 434 1294
CREATION_DATE 13-JUN-02 05-AUG-02
LAST_UPDATE_DATE 13-JUN-02 05-AUG-02
LOCK_FLAG N N
PROCESS_FLAG Y Y
I've read it's safe to do a table update to clear historic transactions on mmtt. Is there a better way - ie forms?
You need to delete the record from the temp table through the backend only.
Make sure to to delete the child records created in the LOT and SERIAL temp tables if the item is lot/serial or both controlled.