MRP Best Practices from the Field Dave Phillips

MRP Best Practices from the Field • Dave Phillips (davphill@microsoft. com)

Agenda • Introduction • MRP Overview • Troubleshooting MRP • In the weeds with MRP • Questions • Conclusion

Introduction • Linked. In • AX since the beginning • 15+ years with MSFT and even more with GP • Support and Consulting • Premier MRP Assessment • Unenviable task of dedicating only 50 minutes to MRP, spanning 100 – 400 knowledge levels, over several releases. • Possible skimming to fit it all in 50 minutes • 10 minute Q&A and I will make some files available

Introduction • MRP Assessment (portions moved into D 365 FO) • Tests for configuration best practices • Tests for data integrity • Tests for key missing MRP KBs • MRP support case trends • • • Configuration, data, missing KBs Performance Quantity and date questions Net Requirements Database (Chad Aberle) Bugs • D 365 FO One. Version

Introduction • Best practice - do not modify MRP

MRP Overview MRP is a set of techniques that uses bill of material data (and Routes), inventory data, and the master production schedule to calculate requirements for materials. It makes recommendations to reorder materials. Furthermore, because it is time-phased, it makes recommendations to reschedule open orders when due dates and need dates are not in phase. Time-phased MRP begins with the items listed on the Master Production Schedule and determines the quantity of all components and materials required to fabricate those items and the date that the components and material are required. Time-phased MRP is accomplished by exploding the bill of material, adjusting for inventory quantities on hand or on order and offsetting the net requirements by the appropriate lead times. *Source is APICS (see also Orlicky)

MRP Overview

MRP Overview

MRP Overview (Forecast)

MRP Overview (Coverage Search)

MRP Overview (Fences)

MRP Overview (Margins)

MRP Overview (Margins)

MRP Overview (Full versus Net Change)

MRP Overview (Demo) How I assess a MRP environment • MRP Parameters • One or Two Plan • Coverage • Master Plan • Log • • Coverage Groups Item Coverage Planned Orders Eventually a run of MRP (Helpers and Tasks/Bundle)

Troubleshooting MRP (Demo) • Turn off Futures • Turn off Actions • Turn off the Processing filters • https: //blogs. msdn. microsoft. com/axsupport/2016/09/19/speed-up-masterplan-when-you-have-large-number-of-inactive-items/ • • • Turn off Capacity Run an Explosion with the Enable Trace flag turned on Process Task Duration flag AX/D 365 FO Trace (10 – 15 seconds) MRP Tracing scripts

Weeds (Random weedy MRP topics) • BOM checks script (and IV Parameters BOM Circularity Check) • select BOMLEVELRECALCULATIONNEEDED, PLANNINGBOMLEVELRECALCULATIONNEEDED, * from BOMLEVELRECALCULATION • select CHECKBOM, * from BOMTABLE • • • Making old BOM’s Inactive script (future work) Net Requirements personalization to help with Reservations Req. Plan. Version script (D 365 FO rename) AX 2012 or less Kernels and D 365 FO PU Scheduling DLLs Orphan script (good link) • https: //docs. microsoft. com/en-us/business-applications-releasenotes/April 19/dynamics 365 -finance-operations/improved-removal-obsolete-planningdata

Weeds (MRP Performance) • https: //blogs. msdn. microsoft. com/axmfg/2014/12/29/checklist-for -improving-mrp-performance-part-1 -how-to-run-mrp/ • http: //community. dynamics. com/ax/b/dynamicsaxmanufacturingr dteamblog/archive/2015/01/02/checklist-for-improving-mrpperformance-part-2 -how-to-setup-planning-parameters • https: //docs. microsoft. com/en-us/dynamicsax-2012/appuseritpro/tools-for-monitoring-performance • https: //blogs. msdn. microsoft. com/axmfg/2012/12/05/logging-and -tracing-dynamics-ax-mrp-runs/

Questions • What is Blocking? • https: //community. dynamics. com/ax/b/galynafedorovaaxblog/archive/20 18/08/21/msdyn 365 fo-mrp-and-inventory-blocking • Other questions?

Conclusion • MRP Overview • Troubleshooting MRP • Weeds

Thank You and Thanks for Supporting AXUG