Huber Cooney posted on April 05, 2011 16:29
MRP Lite
Issue
We occasionally encounter clients running Dynamics GP’s Manufacturing module who want to identify future raw material shortages but don’t want the trouble of setting up, administering and then interpreting the results from the Manufacturing Resource Planning (MRP) tool in Dynamics GP. What they want is MRP Lite.
Solution
For customers who want basic MRP info without the fuss of running the MRP tool, we have developed reports that identify potential shortages of raw materials based only on open sales orders for finished goods and open purchase orders for the raw materials. No need to even run the MRP tool, much less configure it!
The logic is simple: The report reads the Promised Ship Dates of open sales orders for finished goods out into the future and groups them into weeks. Then it explodes the demand for finished goods into raw material demands through Bill of Materials. Next it compares the aggregate demand for the raw materials that week to the amounts of the raw materials that will be available that week based on beginning of week on-hand quantities, plus expected receipts that week read from the Purchase Order module. Shortages show up as negative on-hand quantities at the end of the week. The report would show week-by-week how raw materials are consumed and replenished. A typical planning period would be 16-20 weeks, but any period can be chosen. If desired, the user can filter the report by components of one finished good. Finally, the report can be exported to Excel for further analysis with one click.
As with all reports in SQL Server Reporting Services (SSRS), the user can subscribe to the report and have it sent to him or her every night in Excel.
