Easier/Faster way to unpick sales order

We are testing converting from Avg cost to standard cost. In order to do an effective cost rollup, we must unallocate/unreserve all parts. However, there are many parts that are in Picking or picked status. Has someone found a way to unpick several orders? I having to go and unpick sales orders one at a time. And I am under a deadline to get this resolved quickly.

Go into Fulfillment Workbench, filter the records on the criteria “In Picking”, then select All the returned lines

Actions | Unallocate Unreserve

That should sort all the orders out in 1 go

2 Likes

I don’t understand the impact of Reserved/Allocated/In Picking on an effective Cost Roll. At least I’ve never seen any.
For us in the back, can you elaborate?

Thanks!

This will walk back anything in ‘Picking’

@CDingas is asking how to walk back something that has already been picked. (I think)

I am not aware of a way to do this, I believe you need to do it one at a time VIA Unpick Sales Order.

1 Like

We are converting from AVG to STD. In order to do this, there has to be no inventory so a standard cost can be added then a cost rollup can be completed. The issue I was having to see if there was a fasted way to unpick something without going through UnPick Sales Order.

On 10.2.500, probably not.
I checked to see if there was a DMT extension for this but there is not.
Next would be using a REST call, looping through a dataset with some script, like PowerShell… but I don’t recall how mature 10.2.500 REST was.
Even then, it would depend on how many you have to go through… as it would take time to query, format into a proper list, write the script and then run it.

Looks like the REST (v1) call would be something like:
https://[YourAppServerURL]/api/v1/Erp.BO.UnpickTransactionSvc

2 Likes

That sounds like a viable work around. Right now, I am trying to figure out why things are showing up as allocated (After I went to unpick several hundred orders) when I run a query, but Fulfillment WB does not show anything.

1 Like