Solved

Setting up MRP to transfer from another warehouse if there is on hand inventory

  • 6 December 2023
  • 2 replies
  • 70 views

Userlevel 5
Badge

We have two warehouses that we buy material directly to. Occasionally, there are cases where we want to transfer items from one warehouse to another to fulfill the demand.

 

Can you set up MRP so it flags you to transfer from warehouse A to warehouse B to satisfy the demand? Currently our system will always tell us to buy additional units for Warehouse B despite having available stock in other warehouse?

 

 

icon

Best answer by bradmestach 6 December 2023, 16:55

View original

2 replies

Userlevel 1
Badge

I believe the logic follows this path:
If the demand quantity forces the item to go below the triggered reorder point, the system will look to the replenishment source of that item’s warehouse detail setting. 

If warehouse B’s replenishment source is set to Purchase, MRP will suggest a purchase of the item.
It warehouse B’s replenishment is set to Transfer, then it will suggest a transfer from the supplying warehouse.

We do this on a consistent basis in our company. What this forces you to have though is a single purchasing warehouse. Meaning, warehouse B could not send a signal to purchase the item from the vendor, it would suggest a transfer from warehouse A. If this Demand signal pulled the inventory of that item in warehouse A to fall below the reorder point for that item warehouse detail setting, it would trigger the replenishment source for that warehouse, which would presumably be the purchase source. 

 

Hope this helps you with the logic that my company has experienced with this scenario. 

Userlevel 1
Badge

Unfortunately in 23R2, this is no longer a viable path.

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