ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
Rate Icon Rate Icon Rate Icon Rate Icon Rate Icon
 
Reports - MRP

To obtain the MRP reports, depress the Reports button.The following screen will appear:

Select the output you desire by clicking on the radial.Choose from Screen, Printer, XL File, TXT File, or PDF.

Highlight the report.

Depress the option tab (if aplicable)

Depress the OK button

 

MRP Action Report - PO Actions - MRP Report of all recommended PO Actions for all "BUY'" parts that have at least one action within the "Last Action Date" filter on the MRP screen.

The following report is printed:

MRP Action Report - WO Actions - MRP Report of all recommended PO Actions for all "BUY'" parts that have at least one action within the "Last Action Date" filter on the MRP screen.

The following report is printed:

Inventory Part View by Manufacturer - This report displays the inventory information, supply, demands and action messages for a part that are the results of the latest MRP run.

For Inventory Part View By Manufacturer, depress the Options tab:

Select the Part Number Range desired. To clear the range entries, click on the radial.

Depress the OK button. 
 
This report is divided into three sections:  Inventory; Demands/Supply; and Actions
 

The following report is printed:

Order Action Report - This report displays the inventory information, purchase history, open PO's and MRP actions for 'BUY' parts that are the results of the latest MRP run.

Depress the Options tab.

Select the Part Number Range desired.  To clear the range entries, click on the radial.

Depress the OK button.

NOTE:  The MFGR and MFGR part number will only be printed in the Order Action Message Section if the order policy for the part is LOT for LOT. 

 

The following report is printed:

Projected Excess Inventory List - This report list the projected excess inventory that is on hand but not needed after MRP requirements.

Depress the Options tab.

Click on the radial for All Inventory, Internal Inventory or In-Plant Store Inventory. 

Depress the OK button.

Note:  The Projected Excess Inventory report runs off of the entire MRP run, not just based off of the MRP find filter that might be applied.  
 

The following report will print:

 

MRP Horizontal Planning Summary  - This reports displays the supply and demand for each part on the MRP action list with the quantities in weekly buckets.    
Note:This report requires Legal size paper.

The following message will appear:

Depress the OK button and the following report will be printed:

Multi Division Purchase Order Action Report   -  NOTE:  The system does NOT require that you have Multi-Divisions setup to utilize this report.

Depress the Options tab.

Select the Part Number Range desired, then enter the Last Action Date.   
 
To clear the range entries, click on the "Clear Range Entries" radio button. 

Select the Part Class from the pull down. Select the Supplier List from the pull down.

Select the radio button for the report to list:  All Contact Suppliers, a Single Contract Supplier, Parts with no Contract Supplier, All Parts Contract & Non-Contract.

Select Buyer from the pull down.
 
Depress the OK button.
 

The following report will be printed:  The report is intended to break down the PO actions from the MRP run by Buyer, then part number.

MRP Action Report - PO Actions by Supplier - MRP Report of all recommended PO Actions for all "BUY'" parts that have at least one action within the "Last Action Date" filter on the MRP screen by Supplier

Depress the Options tab.

Select Apply All "Find" Filters or Apply only Date Filter by clicking on the radial.

Select the Supplier from the pull down.

Click on the radial if you want the report to List:   All Default Suppliers, a Single Default Supplier, Parts with no Default Supplier, All Parts Contract & Non-Contract.

Select to Show only #1 pref or Show all Preferences by clicking on the radial.

Depress the OK button.

 

The following report will print:

MRP Action Analysis by Part Number 

Depress the Options tab.

Depress the down arrow next to the Part Number box.

 

Use the slider to reach the Part Number of interest.

Highlight it and click. The Actions will be displayed.

Depress the Ok button.

 

The following report is available:

Customer Projected Excess  - This report list the projected excess inventory that is on hand but not needed after MRP requirements for a selected customer.  
Note: This report requires Legal size paper.

Depress the Options tab.

Select All Inventory, Internal Inventory or In-Plant Store Inventory by clicking on the radial.

Select a Customer fron the pull down.

Select to Sort by System Part Number or Customer Part Number by clicking on the radial.

Depress the Ok button. 

Note:  The BOM MUST be associated to a Customer for the report to work.   
 If you select a customer, the program will find all the assembly’s and sub assembly’s assigned to that customer find all the parts on those BOMs. Then it will exclude the parts that are used on the BOM of a different customers.
 

The following report will be printed:

MRP PO Action Report by Buyer - MRP Report of all recommended PO Actions for all "BUY'" parts that have at least one action within the "Last Action Date" filter on the MRP screen.
Note:  A default Supplier MUST be linked to the inventory part before it will display on the report. 
 
The following report will print:

 

 

 

 

 

Article ID: 743