When we get a hot or urgent sales order entered in Acumatica, we need to find a way to identify all the orders that are created via MRP or Create Orders for this sales order.
Is there a way we can mark/tag/flag/color code the resulting orders to be able to easily pick and process accordingly?
Best answer by jeremyd45
View original
+3
You should be able to create a GI which lists all Production, Purchase, Transfer Orders which reference the Sales Order Line. Not sure the helps with the pick and process though.
Thank you for your quick response.
Yes, that would take care of the orders that are produced via Create Production Order or Create Purchase Order, but not the ones created via MRP, which is the one that crates the bulk of the orders.
+12
+16
HI
Along with the suggestions here, there is an actual Priority box on the Sales Order, that you may be able to use if you don’t have a customization. It is an editable read only field. This may be able to help you in some capacity.
Thank you @kandybeatty49 I’ll check on that.
+1
I have created GI for customer that utilize the sales priority and the purchase orders in the past. This is a good way to at least identify and help lead with the manual process of expediting sales orders.
You cannot set the priority as a factor for MRP, but that you could potentially build a gi that would mirror the exceptions page tied in with the sales order priority. If you have not looked at the MRP exceptions inquiry, this will often tell you to expedite orders based upon due dates.
+1
There is also a dispatch priority on Production orders, but also would have to be tied into a GI. When you are talking about picking, are you looking to prioritize the shipments or the production orders?
“ When you are talking about picking, are you looking to prioritize the shipments or the production orders? “
Everything!
The goal is to identify and prioritize SO’s entered into Acumatica and be able to get all the material needed, produced and/or purchased right away, to be able to ship the SO asap.
Often, we have part orders that need several parts to be produced and material to be purchased and we need everyone in production and procurement be aware of the urgency.
+1
I think your best bet would be to create a custom GI that mirrors the MRP inquiry, then you can tie the sales order priority into this. You could then break it down into a pivot table if you wanted to. There are a lot of tables that will have to be joined, so it would be a fun project, but it would be worth it to be able to prioritize by that sales order number!
You could also just use the AMRPPlan table and then just make a pivot table by product reference ID for simplicity. It wouldn’t be as clean since you would have to export it or use a subquery customization.
Thank you
Appreciate your experience and help.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
