Skip to main content
Solved

Have Inventory Planning predict purchhase needs 466 days

  • January 21, 2025
  • 7 replies
  • 34 views

Forum|alt.badge.img

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
Did this topic help you find an answer to your question?

7 replies

josborn02
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 50 replies
  • January 21, 2025

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 54 replies
  • January 21, 2025

@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?


josborn02
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 50 replies
  • January 21, 2025

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.

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 54 replies
  • January 21, 2025

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?

 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 54 replies
  • January 21, 2025

These are the MRP settings for the purchased item.


josborn02
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • 50 replies
  • Answer
  • January 21, 2025

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 54 replies
  • January 22, 2025
josborn02 wrote:

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 :)


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings