I’ve got a sales order for a part with 1000 pieces, it’s a Buy to Order Release. I’ve got 1000 pieces in stock in the warehouse that’s on the release. When I try shipping, I get an error “This sales order release has been allocated in other locations.”, and it’s not allowing me to ship. When I look at Part Tracker (or the PartWhse table), I see it has a quantity of 2000 in the “SalesPickingQty” field. I have two PartAlloc records against it, each with the correct warehouse but fro two differnt bin numbers at 1000 each, so there’s my 2000 in picking.
I can’t seem to get rid of the picking quantity. There was a material queue record for one of the two PartAlloc records, I removed that. Typically if it’s “In Picking”, I pull up the order in the Fulfillment Workbench and “unreserve/unallocate”, and that releases the order from being in picking.
I can’t seem to find anywhere that I can remove the allocations. Any help?
Actually, I did that. The allocation is showing as “InPicking”. If the quantity was “Picked”, at that point I’d expect it to be available in the “PickedOrders” table. Just to dot my T’s and cross my I’s, I went ahead and did the usual things for a PICKED allocation - tried unpicking it, tried to create a shipment.
Tried closing and reopening the order release - no luck there either.
I’ve got a call into Tech Support, and told the user to quantity adjust more in so they can ship. We’ll have to quantity adjust back out once we get it fixed.
I was thinking about trying the employee to override allocations - but I didn’t think that would clear my allocations. And somehow, the user got double the allocations: 1000 on hand, 1000 on order - yet 2000 total allocated.
I tried unpicking it, that didn’t work. I wasn’t expecting it to anyway, the parts are showing as “InPicking”. Normally, you can only unpick if they are showing in “Picked”. I tried anyway, I’m at the point of trying things I don’t think will work.
I’m having exactly the problem described in this thread: I’m using version 10.2.600, and I have a bunch of material stuck in “Picking” status (without MtlQueue records) that I can’t touch via Fulfillment Workbench, Material Queue, Unpick Sales Order, Customer Shipment, Picked Orders or anything else I can think of. I set an employee as Can Override Allocations, but that doesn’t seem to change anything.
I was even thinking of DMT to delete the PartAlloc records in question, but DMT doesn’t process PartAlloc records.
OK I fixed my own problem. I completed the shipment without using the material stuck in limbo, then closed the sales order. Once the sales order was closed, the PartAlloc records for it disappeared.
Well, it’s been a few years, but I happened to run across this so I figured I would give some info I’ve learned throughout my years.
InPicking - PickingQty as seen on PartWhse should be a summary of the records found in MtlQueue. By Unallocating\Reserving the order\line, you will clear those MtlQueue records and ultimately relieve the PickingQty.
