Reports, MRP Explosions

This chapter contains the following topics:

Introduction to Reports, MRP Explosions

MRP Item Summary

MRP Schedule Detail

MRP Order Actions

MRP Vendor Purchase Actions

MRP Order Pegging

 

Introduction to Reports, MRP Explosions

Use these programs to print selective information from the MRP explosion data files created by the "Explode requirements"function.

If output files from more than one MRP explosion run have been saved, each of these programs will ask which MRP run you wish to access. If this occurs, use the <F1> key to display information about the various MRP runs and then enter the Run Number you want.

MRP Item Summary

This report prints time period summary information for items included in the MRP explosion output files. You may also elect to include order action messages on this report.

Select

MRP item summary from the Reports, MRP explosions menu.

The following screen displays:

Enter the information as follows:

1. Print order action messages ?

Y or N.

2. Print order action items only ?

Y or N, default is Y.

3. List planned order by

D = Due date period, or S = Start date period

4. Report sequence

I = Item #, P = Planner/buyer

If report sequence is P enter:

5. Starting planner/buyer code

Up to 3 alphanumeric characters, or Blank = Undefined, or <F1> = "All".

6. Ending planner/buyer code

Up to 3 alphanumeric characters, or Blank = Starting value.

7. Items with this Purch/Mfg code

P = Purchased, M = Manufactured, S = Super bill, T = Transient, <F1> = "All".

8. Starting item type

Up to 4 alphanumeric characters, Blank = Undefined, or <F1> = "All".

9. Ending item type

Up to 3 alphanumeric characters, or Blank = Starting value.

If report sequence is I enter:

5. Starting item #

Up to 15 alphanumeric characters, or <F1> = "All".

6. Ending item #

Up to 15 alphanumeric characters, or Blank = Starting value.

If report sequence is I, also enter Fields 7-9 as described above and enter the Planner/buyer Code range in Fields 10-11.

MRP Schedule Detail

This report prints detail information about the requirements and orders within each schedule period.

Select

MRP schedule detail from the Reports, MRP explosions menu.

The following screen displays:

Enter the information as follows:

1. Item #

Up to 15 alphanumeric characters.

2. Through schedule period beginning

6 numeric digits in MMDDYY format, or press <F1> for the next MRP run schedule period date.

Detail to include:

3. Backlog reqts by warehouse ?

Y or N.

4. Forecast balance reqts ?

Y or N.

5. Shop order material reqts ?

Y or N.

6. Parent plan exploded reqts ?

Y or N.

7. Open shop or purchase orders ?

Y or N.

8. Firm planned orders ?

Y or N.

9. Suggested planned orders ?

Y or N.

10. List planned orders by

D = Due date period, or S = Start date period.

MRP Order Actions

This report prints order action messages created by the MRP explosion.

Select

MRP order actions from the Reports, MRP explosions menu.

The following screen displays:

Enter the information as follows:

1. Report sequence

I = Item #, P = Planner/buyer

If report sequence is I enter:

2. Starting item #

Up to 15 alphanumeric characters, or <F1> = "All".

3. Ending item #

Up to 15 alphanumeric characters, or Blank = Starting value.

If report sequence is P enter:

2. Starting planner/buyer code

Up to 3 alphanumeric characters, or Blank = Undefined, or <F1> = "All".

3. Ending planner/buyer code

Up to 3 alphanumeric characters, or Blank = Starting value.

4. Items with this Purch/Mfg code

P = Purchased, M = Manufactured, S = Super bill, T = Transient, <F1> = "All".

5. Starting item type

Up to 4 alphanumeric characters, or Blank = Undefined, or <F1> = "All"

6. Ending item type

Up to 3 alphanumeric characters, or Blank = Starting value.

MRP Vendor Purchase Actions

This report prints purchase order action messages by vendor. For suggested planned order releases, the order actions are listed by Primary Vendor on the Item Master File. If available, Vendor contact and telephone numbers from matching A/P Vendor records and Vendor Item Numbers and last purchase price from matching P/O Item Source records are included.

Select

MRP vendor purchase actions from the Reports, MRP explosions menu.

The following screen displays:

Enter the information as follows:

1. Starting planner/buyer code

Up to 3 alphanumeric characters, or Blank = Undefined, or <F1> = "All".

2. Ending planner/buyer code

Up to 3 alphanumeric characters, or Blank = Starting value.

3. Starting item type

Up to 4 alphanumeric characters, or Blank = Undefined, or <F1> = "All".

4 Ending item type

Up to 4 alphanumeric characters, or Blank = Starting value.

5. Include reschedules ?

Y or N, default is Y.

6. Include suggested orders ?

Y or N, default is Y.

If you answer Y to "Include suggested orders ?", the program asks:

List suggested beyond release horizon ?

Y or N.

A Y answer to this question means that if there are suggested orders for an item within its release action horizon, any other suggested orders for the item which are beyond the release horizon will also be listed without an action message.

MRP Order Pegging

Use this report to trace the orders for selected items to related requirements, or to related parent orders and requirements.

Select

MRP order pegging from the Reports, MRP explosions menu.

The following screen displays:

Enter the information as follows:

1. Pegging type

E = End item, M = Multilevel

2. Order type

OP = Open purchase, OS = Open shop, PF = Planned firm, PS = Planned suggested,

<F1> = "All".

3. Starting due date

6 numeric digits in MMDDYY sequence, or <F1> = "Earliest".

4. Ending due date

6 numeric digits in MMDDYY sequence, Blank = Starting value, or <F1> = "Latest".

5. Report sequence

I = Item #, P = Planner/buyer

If report sequence is I enter:

6. Starting item #

Up to 15 alphanumeric characters.

7. Ending item #

Up to 15 alphanumeric characters, or Blank = Starting value.

If report sequence is P enter:

6. Starting planner/buyer code

Up to 3 alphanumeric characters, or Blank = Undefined.

7. Ending planner/buyer code

Up to 3 alphanumeric characters, or Blank = Starting value.

8. Purch/mfg code

P = Purchased, M = Mfg, S = Super bill, T = Transient.

9. Starting item type

Up to 4 alphanumeric characters, or Blank = Undefined, or <F1> = "All".

10. Ending item type

Up to 3 alphanumeric characters, or Blank for Starting value.