ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon Sales
DrillDown Icon Inventory Management
DrillDown Icon Material Planning
DrillDown Icon Purchase Order Management
DrillDown Icon Material Requirement Planning (MRP)
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon Find a Material Requirements Planning (MRP) Record
DrillDown Icon Add (Generate) A Material Requirements Planning (MRP)
DrillDown Icon Drilling Down In MRP
DrillDown Icon Create POs from MRP Action List
DrillDown Icon Reports
DrillDown Icon FAQs
DrillDown Icon MRP Hot List
DrillDown Icon Purchase Setup
DrillDown Icon In-Plant Store (IPS) (OPTIONAL Module)
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Administration
DrillDown Icon Accounting
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Find a Material Requirements Planning (MRP) Record

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:

 

 

Article ID: 5252