By using this website, you agree to our Terms of Use (click here)
Looking for a way to highlight/show the Production Orders in the system where there is enough material on-hand/available to make the order.
Short of having to look at Critical Material for each Production Order, does anyone have any recommendations on a way to get this information?
Hi Sarah,
I'm very interested in a solution to this as well.
Were you able to get any feedback/help?
I think this report is a great starting point. I'd like to see this report for all Production orders in the "Released" status. Currently, it only pulls for completed or in process because it's tied to a "MOVE" transaction:
Hi Sarah, were you looking to get this visibility in a GI? If so, I was able to essentially get a yes or no result based on the following relation and formula...
I am using MYOB Advanced, so your tables may differ slightly.
If you specifically want highlighting, you can just use an IIF in the row style. In my GI, I have named the column "short", as in, the production order is short of materials.
Is the problem with this Critical Materials (AM401000) screen that it forces you to choose a Production Order, so you can only look at one Production Order at a time?
Yes! If that parameter was optional it would be an infinitely better resource for materials planning.
@tlynn Looks like someone already created a product idea for that and someone from Acumatica responded with a suggested report for them to look at:
https://community.acumatica.com/manufacturing-89/critical-material-report-30909
Thank you! We just upgraded to 2025R1 in January so we now have this available. Thank you for following up!!
@timrodmanrodman
Question for you. What table joins do I need to add this field: ProductionReadinessByProdItem/ReadinessToProd to my work order log?
My work order log tables are below:
Your help is greatly appreciated!!