Solved

Update Picking Location after Physical Inventory

  • 6 February 2023
  • 6 replies
  • 83 views

Userlevel 6
Badge +4

Hi, 

 

Is there a process that will update the picking location on a shipment after doing physical inventory?

Example, we sell item EGI123 and it’s located in location “A”.

A shipment is created and the picking location is “A”.

After doing a physical inventory count we find that it’s actually in location “B” and we update accordingly using the physical inventory process. 

We now need the picking location on the picking sheet to be updated to “B” so the pickers can find it.

icon

Best answer by Dave Gutman 9 February 2023, 17:05

View original

6 replies

Userlevel 3
Badge

When the shipment is created, the location would be where the available/allocated inventory actually is located. The Item has the Default location that could be updated using mass actions or an import scenario. Hope that helps.

Userlevel 3
Badge

I think you would need to update those shipments. Typically you would complete the open shipments before starting the physical inventory. 

Userlevel 3
Badge

Hi @Jeff96 Yes, I see your sequence - Shipment is created which sets the picking Location to ‘A’ on a line, then a Count is created, performed, and finished which moves the items on the Shipment line from ‘A’ to Location ‘B’.  At this point you have to manually update the location on the Shipment line to ‘B’ before picking begins. 

Please add this in the Ideas section of the Community so we can track the votes on it.  

Thanks,

Userlevel 6
Badge +4

Hi @Jeff96 Yes, I see your sequence - Shipment is created which sets the picking Location to ‘A’ on a line, then a Count is created, performed, and finished which moves the items on the Shipment line from ‘A’ to Location ‘B’.  At this point you have to manually update the location on the Shipment line to ‘B’ before picking begins. 

Please add this in the Ideas section of the Community so we can track the votes on it.  

Thanks,

 

Thank you. I created an idea. Process to automatically update picking location

Userlevel 6
Badge +4

When the shipment is created, the location would be where the available/allocated inventory actually is located. The Item has the Default location that could be updated using mass actions or an import scenario. Hope that helps.

What if the shipment was created before the physical inventory and the old location is populated in the shipment?

Userlevel 3
Badge

Thanks @Jeff96 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved