Skip to main content
Solved

How to use all of bulk while utilizing MRP?

  • January 14, 2025
  • 5 replies
  • 111 views

Forum|alt.badge.img

Hey there! Our business repacks seed potatoes and I’m wondering if there is a way for us to use MRP in such a way that allows us to not have to do any calculations outside of Acumatica (example in excel).

 

We buy seed potatoes in bulk and repack into 4 different sizes based on weight. Each of these items have their own stock item.

Right now MRP is running and consolidating sales orders so that we can create production orders. This works great as long as well sell exactly how much we have purchased, but if we sell less we will still want to repack the remaining into various sizes (ideally at the same time of repacking for sales orders). Our work around is to export the production orders out of ACU, put it into an excel sheet, change the “Qty To Produce” of the production order using calculations in the excel sheet, and importing those chanes for those production orders.

Is there anyway to utilize inventory planning so that all of the remaining bulk is put into an additional production order?

I hope that all makes sense! Thank you!

Best answer by deaster93

@SBaldwin  Some of this solution may come down to timing.  When do you know how many of each of the items you want to produce? When you buy the bulk item?  

Have you considered creating a forecast for each of the items and then building to order and to forecast?  If you create a forecast for the amount you want to produce of each item, MRP should drive production for the forecast and if it is dependent, for each sales order as well.

Do you have more you can share on this part of the planning?

Thanks

Dennis

5 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • January 14, 2025

Is your base UoM different than your Purchase UoM? (for the Stock Item)


Forum|alt.badge.img
  • Author
  • Varsity I
  • January 14, 2025

Our bulk stock item has a base and purchase unit of LBS (pounds)

The manufactured sizes have a base, sales, and purchase unit of EA with a conversion in the conversion table for LBS to EA

Example

AmaRosa PVP OG Bulk

  • Base and Purchase unit is LBS

This bulk can be manufactured into 4 possible stock items

AmaRosa PVP OG 45 lbs

  • Base, Sales, and Purchase unit of EA
  • Conversion table
    • To Unit: EA
    • From Unit: LBS
    • Divide
    • Conversion Factor: 45

AmaRosa PVP OG 25 lbs

  • Base, Sales, and Purchase unit of EA
  • Conversion table
    • To Unit: EA
    • From Unit: LBS
    • Divide
    • Conversion Factor: 25

AmaRosa PVP OG 10 lbs

  • Base, Sales, and Purchase unit of EA
  • Conversion table
    • To Unit: EA
    • From Unit: LBS
    • Divide
    • Conversion Factor: 10

AmaRosa PVP OG 2 lbs

  • Base, Sales, and Purchase unit of EA
  • Conversion table
    • To Unit: EA
    • From Unit: LBS
    • Divide
    • Conversion Factor: 2

Forum|alt.badge.img
  • Author
  • Varsity I
  • January 17, 2025

@angierowley75 just tagging you to see if you had any more insight :) Thank you!


Forum|alt.badge.img+1
  • Jr Varsity III
  • Answer
  • January 20, 2025

@SBaldwin  Some of this solution may come down to timing.  When do you know how many of each of the items you want to produce? When you buy the bulk item?  

Have you considered creating a forecast for each of the items and then building to order and to forecast?  If you create a forecast for the amount you want to produce of each item, MRP should drive production for the forecast and if it is dependent, for each sales order as well.

Do you have more you can share on this part of the planning?

Thanks

Dennis


Forum|alt.badge.img
  • Author
  • Varsity I
  • January 22, 2025

@SBaldwin  Some of this solution may come down to timing.  When do you know how many of each of the items you want to produce? When you buy the bulk item?  

Have you considered creating a forecast for each of the items and then building to order and to forecast?  If you create a forecast for the amount you want to produce of each item, MRP should drive production for the forecast and if it is dependent, for each sales order as well.

Do you have more you can share on this part of the planning?

Thanks

Dennis

that is a great idea and something I am implementing in our test site today! Thank you!