Question

Demand Forecast Model for Stock Transfers.

  • 14 July 2023
  • 5 replies
  • 67 views

Userlevel 5
Badge

Hello,

I have a below scenario I need some guidance/inputs on.

We have a Main Warehouse and few Retail Store Locations that operate as individual Warehouses.

The Main Warehouse serves the Distribution Center to replenish all the Store Locations. 

We are using Demand Forecast Model with Moving Average to replenish the Main Warehouse (Distribution Center). This is working fine.

 

Here is the requirement:

We replenish the Sore Locations by using Replenishments of type Transfer with the Main Warehouse being the Source Warehouse. We want to use Demand Forecast Model to replenish the Store Locations. From what I tested, the Demand Forecast Model to replenish the Store Locations by using the Replenishment of type Transfer is not calculating the Mins. and Maxes. 

Any thoughts if this can be worked out?


5 replies

Userlevel 5
Badge

@Chris Hackett - No l, I haven’t out of the box. Looks like this is something we need to customize. 

Userlevel 7
Badge +16

 

HI @RohitBhandurge 

The system will not create a sales order type of TR unless the item is marked for purchase as the source.

  1. Ensure that you have Transfer as the source, unless you want an SO of the TR type created.
  1. Then prepare the Replenishment:
  1. The system automatically creates the receipt:

 

 

  1. If you want to create the SO, make sure the inventory item has Purchase as the source
  1. You would then Prepare the Replenishment as about and then Create Transfer Orders
  1. This will then create an SO of the TR type:

*side note, make sure the Mark for PO is unchecked to create the shipment.

Userlevel 5
Badge

@kandybeatty49 - The Replenishment Methods works perfectly fine for both “Purchase” and Transfers”. I am trying to see if “Demand Forecast Model” works for Replenishments of type “Transfers”. We want the system to calculate the Min. and Max. for Replenishment of type Transfer.

Userlevel 7
Badge +16

Hi @RohitBhandurge 

Have you looked at the Calculate Replenishment?

https://help.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=6fd9f00f-9ed5-4f00-8bb2-9cdfee222074

Userlevel 7
Badge

Hi @RohitBhandurge were you able to find a solution? Thank you!

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