Does anyone know of a way to generate production tickets from MRP for the total quantities that are in demand for an item. Currently it is showing the same item multiple times and if you generate tickets it will create one by one instead of a sum of the quantity. If we manually sum the qty and create a work order for that quantity, mrp still shows the demand one by one until it’s complete. Quite cumbersome to keep on track. Any suggestions?
MRP Grouping Quantities When Creating Produxtion Tickets
That’s what Group Planning is used for. The system groups/consolidates all planned orders on an item with a date within the number of days that you specify for that item, see screen shot below. The first planned order selected determines the starting date for grouping.
Note that MRP will still show MRP plan (demand) for item individually in MRP Display and that is useful to track where the demand comes from but you use group planning to create production order in with sum/consolidated qty.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/ab340c62-ff7f-4576-a518-13fcf5af4a62.png)
For more detail and see example, check link below:
https://help-2021r1.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=0061f06b-a125-4dff-be21-40998e23af81
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9e46a668-b976-4094-b5ff-46b4ccb17e44.png)
Ah that’s really helpful thank you. I will test this out.
It would be helpful to be able to set this at the item class level so you would not have to worry about it on every single stock item. It would also be helpful if there was an indicator on the screen to provide a subtotal for the group, or let you know that it is a group production type. (Yes, there is the group number, but a simple indicator could also help)
An update to this, you can manually add in the group number (it may be obvious to some, but I wanted to put it out there) when you choose the Purchase or Manufacture process button. You can override or add in a group number and it will consolidate. It would be nice if it gave you a total somewhere though.
RE: It would be helpful to be able to set this at the item class level so you would not have to worry about it on every single stock item.
You can use a generic inquiry to update this at the item class level. Select or create an inquiry that includes the field(s) which you want to update globally by Item Class. On the “Entry Point” tab check the box next to “Enable Mass Record Update”. A new tab will appear called “Mass Update Fields”. Add Group Planning (and other fields as needed). In the inquiry there should now be an “Actions” drop down where you can select Update or Update All. Group Planning can be selected in the pop up window and the Value entered. (Test on one or two parts initially….)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/b15e507c-b180-4ecc-8ad4-a91041a3147f.png)
Hope this helps..
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.