DID YOU KNOW: You can now schedule Material Requirements Planning (MRP) regeneration to happen automatically!
A common question we get during Microsoft Dynamics GP Manufacturing implementation projects is “How often should I run MRP regeneration?”
The answer to this depends, of course, on several factors – including, but not limited to – the speed of your database server, the size of your database, the number of items, the depth of your bills of material, and the time horizon you need to cover for MRP regeneration. Even with all these factors, most Dynamics GP users find that MRP regenerates in minutes when run on newer hardware. Even so, older versions of Dynamics GP required a user to log into the system and submit MRP. Therefore, some clients opted to run MRP weekly or as needed, as opposed to every day.
Now, in Dynamics GP 10.0, it’s easy to set up MRP to run automatically every night (or multiple times during the day) if needed.
To set this up, you’ll need to do a couple things:
- Make sure that the SQL Server Agent service is running on your SQL Server database server. You may need to check with your database administrator.
- However, this is usually set up to run on a properly configured SQL Server.
Log into Dynamics GP as the ‘sa’ user or as a user with similar SQL administrative privileges. - Schedule MRP – this is done from the Manufacturing System Setup>>MRP window. Screen shots below:
Go to the following setup menu:
Note – you may need a system menu password if your system requires one
Next, choose the “Schedule MRP” button:
Next, set your options, the time and frequency of the regeneration, and when you click the “Save” buttons, the job will be set up to run automatically on your SQL Server.
Note – the “Full Regeneration is scheduled” or “Net Change is scheduled” checkboxes will be checked after you save the job.
Here’s how the job looks in SQL Server:
And it's that simple!
