Automating the MRP process

Note: You can only automate MRP if Enforce logon has not been selected in System Administration.

Using the Windows Scheduled Tasks option, you can schedule MRPMaterials Requirements Planning (MRP). MRP recommends purchase orders, transfers and work orders to balance supply and demand. to run automatically at a given time.

Note: Demands must be read in MPSMaster Production Schedule (MPS). The planning of production (usually end item production), to satisfy current and forecast sales orders. The sum of MPS items must equal the agreed sales and operations plan for the items over each planning period. Planning periods are normally a month or a four week period. Items planned within MPS are exploded by MRP (Materials Requirements Planning) to produce the material and capacity requirements. before running automated MRP. There is no automated process for this at present.

To automate the MRP process

Create a batch (.bat) file

Open: Start > All Programs > Accessories > Notepad.

In inverted commas, enter the path to the file Sage.Manufacturing.AutomatedMRPRun.exe.

Note: If defaults were accepted at installation, this would be "c:\Program Files\Sage\Sage200\Sage.Manufacturing.AutomatedMRPRun.exe".

Save the file as a batch (.bat) file.

Select File > Save.
Enter a File name, such as AutoMRP.bat.
Select the Save as type, All Files.
Click Save.

Copy the command line with the company logon details

Open: Planning > MRP > Processing > Run MRP.

In the Run MRP window, click here at the foot of the window for information on automating the process.

In the Automated MRP Run window, click here to copy the command line for the current company to the clipboard.

Note: This is the second here in the Automated MRP Run window. Clicking on the first here will provide a list of command line options for your reference. This is not required in order to automate the MRP process.

To close the Automated MRP Run window, click Close.

Paste the command line into the batch (.bat) file

Open: Start > All Programs > Accessories > Notepad.

Open the batch (.bat) file you created (see above).

Select File > Open.
Enter Files of type, All Files.
Locate the File Name.
Click Open.

Leave a space after the closing inverted commas in the file and paste the contents of the clipboard, that you copied above (see above).

Save the file.

Select File > Save.

Set up a windows schedule task

Set up a windows scheduled task to run the file at the desired time. For more information refer to your Windows documentation.