|
Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password
|
 |
|
The following screen will be displayed, select Material Planning/Material Requirements Planning (MRP)/Material Requirements Planning (MRP) Module
|
 |
The following screen will be displayed:
Tips on Using the Material Requirements Planning Find Screen
Selection of at least one parameter will reduce the time to retrieve the information. The Find by Parent BOM is specific down to the Revision level.
If no information is selected in a Find operation, all part numbers with MRP actions will be displayed.
Pressing the Find action Button displays the following sequences:
Definition of Material Requirements Planning Find Fields:
|
Starting Part Number and an Ending Part Number
|
Be sure to enter all prefixes, dashes, spaces and alpha characters to find the exact number you are trying to locate. To find one item, enter the part number in the 1st box, depress the return key and only that record will display. To view a series of items, enter the first and last part number of the series and all items numbered between will display. If you want All part numbers, leave this area blank.
If an incorrect part is entered into the range that does not exist within inventory, or there are no MRP records for the part entered user will receive the following message:
|
| Buyer |
Select Buyer from the pull down menu. If you want ALL buyers, leave this area blank. Assigned Buyer will bring up all items assigned to that particular Inventory Buyer within the Inventory Control Management module. The Buyer assignment is setup in Part Class and Type System Setup Defaults or in the Inventory Control Management module/Item Master tab.
|
| Part Class |
Select the Class from the pull down menu Part Class and/or Part Type will bring up only those items that match all entries made. If you want all Classes, leave this field blank. |
| Part Type |
If you selected a Class, depressing on the down arrow will bring up a list of Types within that Class. Select the Part Type within the Class selected. If you want all of the Types within the Class, leave this field blank.
|
| Find by Parent BOM |
The "Find by Parent BOM" is specific down to the Revision level. This filters MRP results per Selected Bill of Material. You MUST enter the exact part number and revision of the Parent BOM to get only the parts with actions per that BOM. Note: Only parts listed on the BOM with MRP action messages will be displayed. Parts with all actions from all sources will be shown on the screen if the part has actions from the entered BOM and other demands. A part may appear on the list even if there are not direct actions from the entered BOM if there are actions from the demands or such actions as Cancel PO/WO. There is no way to filter out the actions just to those actions resulting from demands from entered BOM. |
| Rev |
Revision of Parent BOM. If applicable this MUST be entered to located the exact Parent BOM. The "Find by Parent BOM" is specific down to the Revision level. If the exact part number and revison of the Parent BOM is not correct user will receive the following message:
|
| Parent Project |
If you select to find by a Project this is going to filter and display only parts that are assigned or associated to a project, but will display , ALL actions for that part , not just those that are associated with the project. If you had 3 actions for a part, each assigned to a different project, all three actions would be displayed when you Find by any of the three projects. |
| Actions |
Select the action from the pull down. There are the various Material Requirements Planning actions, which the user may filter on such as: All Actions, All Purchase Order Actions, All Work Order Actions, Pull-Ins, Push-Outs, Release Purchase Orders, Release Work Orders, Cancel Purchase Orders, and Cancel Work Orders.
Note: When you filter by any of the selections, MRP will filter through the actions and display ONLY the parts that have an action that matches the selection. If it finds a match it will display all the the actions against that particular part.
For example: if you select to filter by "Release PO Actions". MRP will display ONLY the parts that have "Release PO Actions". If it finds a match it will still display all the other PO actions against that particular part. If it didn't users may overlook the fact that there are other PO actions for that particular part as well. However, it does filter out all the parts that "DO NOT" have any "Release PO Actions" against it.
|
| Days |
Type in the number of days (from the current date), changes the Date Filter accordingly. This is a short-cut to the horizon date.
|
| Date Filter |
The horizon date for the Material Requirements Planning actions. Parts with actions beyond this date are excluded from the report.
|
| MRC |
Select the Material Risk Code from the Pull Down, which are setuup in System Setup/ Material Risk Code Setup . |
The filtered information will populate the Material Requirements Planning Actions screen, as displayed below:
| 