Solved

Replenishment - Daily Demand Forecast

  • 17 November 2022
  • 3 replies
  • 166 views

Userlevel 5
Badge

Is there a way for the Daily Demand Forecast calculation within the replenishment parameters to consider production demand?

We are looking to use replenishment feature for the material that goes into an order, but looks like it ignores production demand and only considers items included on a completed Sales Order. Which would be our finished good and not the material used to make the finished good.

 

 

 

icon

Best answer by Hannah Barnes 17 November 2022, 19:55

View original

3 replies

Userlevel 5
Badge +4

Hi jwarren,

Inventory Replenishment and its forecast features are based on sales statistics.

You can read more about this in this help article:
https://help-2022r1.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=d7a2e645-5987-4292-ab62-c703fd849e35

To calculate forecasts for material component items in production orders, Acumatica uses the MRP feature.

Inventory Replenishment and Manufacturing MRP are 2 distinct features within the system.

I hope this helps!

 

Userlevel 5
Badge

In an ideal world, we could use some of the functionality from the Replenishment features for the materials on our BOMs.

 

We will typically buy material in bulk based on min/maxes rather than on an order by order basis.

 

Example:

  • Each production order has anywhere from 1 to 25 screws let’s say.
  • We like to hold at least 500 screws on hand at any given time. We buy in boxes of 100.
  • If using MRP, system tells us to purchase only the amount per production order (i.e. 4 for AM0002, 6 for AM0003, etc.)
  • Ideally, the system would automate the purchase of 1 box of 100 once the on hand inventory balance drops below 500.

Am I missing something about MRP that satisfies this need?

 

 

Userlevel 5
Badge +4

Yes, you can use Safety Stock of 500 with Lot Sizes on Vendors set to 100 to meet this need.
You can also use a combination of Min. Order Qty. and Lot Size to fine tune the calculation further.


This help article has some good general information in it that might be helpful as well:
https://help-2022r2.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=626338f7-e0f2-47fd-bbb3-58e3f855439f
 

See especially the Stock Items in MRP section:

 

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