Skip to main content
Solved

Have Inventory Planning predict purchhase needs 466 days

  • Jan 21, 2025 10:13 AM UTC
  • 7 replies
  • 124 views
  • Translate All

Forum|alt.badge.img+1

Good morning! My company needs to place a purchase order that will give us enough stock of an item until April 2026. We have been in Acumatica for less than a year. Below is my proposed method of approach and I’m looking to see if the method will work.

Manually enter monthly forecast data for February 2025-April 2026

Increase “days of supply” for my purchased items to “453”

Should MRP then give a PO recommendation of how much inventory to purchase?

Best answer by josborn02

Because your item has a six day lead time and your forecast demand is spread over several months, Acumatica isn’t going to tell you to buy everything right now.  I’m sure you have a good business reason to buy it all right now, but Acumatica is going to time your purchases such that you’re not carrying it in inventory for very long because this is generally how folks would want it to behave.

Can you send a screenshot of your Inventory Planning Preferences? You may be able to adjust a setting there so it doesn’t recommend monthly purchases.

View original

7 replies

josborn02
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • Jan 21, 2025 3:15 PM UTC

That method would suggest you purchase everything needed from now until April 2026 right now.  Another option would be to create a blanket PO for everything you need, and then place monthly POs to draw down the blanket PO balance.

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Jan 21, 2025 3:29 PM UTC

​@josborn02 I am actually looking to purchase all that I need to get me thru April 2026 today. So that is the results I would be looking for. Would I want to make the forecast values dependent?

Translate

josborn02
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • Jan 21, 2025 3:41 PM UTC

If you want to purchase everything you need today, then your originally described method should work.  Just make sure that item is an MRP item in the Stock Item screen.

 

 

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Jan 21, 2025 5:24 PM UTC

So  it still looks like MRP is suggesting monthly ordering of this item. This item is used in BOMs (to make 10lb and 2lb versions of this item). Do I need to make sure that those items have the same “Days of Supply” in order for MRP to display 1 purchase order?

 

 

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Jan 21, 2025 5:26 PM UTC

These are the MRP settings for the purchased item.

Translate

josborn02
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • Answer
  • Jan 21, 2025 6:06 PM UTC

Because your item has a six day lead time and your forecast demand is spread over several months, Acumatica isn’t going to tell you to buy everything right now.  I’m sure you have a good business reason to buy it all right now, but Acumatica is going to time your purchases such that you’re not carrying it in inventory for very long because this is generally how folks would want it to behave.

Can you send a screenshot of your Inventory Planning Preferences? You may be able to adjust a setting there so it doesn’t recommend monthly purchases.

Translate

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Jan 22, 2025 2:36 PM UTC

Because your item has a six day lead time and your forecast demand is spread over several months, Acumatica isn’t going to tell you to buy everything right now.  I’m sure you have a good business reason to buy it all right now, but Acumatica is going to time your purchases such that you’re not carrying it in inventory for very long because this is generally how folks would want it to behave.

Can you send a screenshot of your Inventory Planning Preferences? You may be able to adjust a setting there so it doesn’t recommend monthly purchases.

I went to inventory preferences and unchecked the long term consolidation bucket checkbox and it now pays attention to my “days of supply” number and suggests 1 purchase order for those days :)

Translate