Requirements Planning > Requirements Planning Query

Requirements Planning Query

You use this program to view the results of the Requirements Calculation for each stock code/warehouse combination.

Toolbar and menu

Field Description
Options  
Preferences Configures options that will determine the detail you want to view within the query. See Preferences.
Reload Query after Pegging Change Automatically reloads the query whenever you make changes to the pegging using the Change icon in the Material Requirements Pegging list view.
Non-stocked View demand requirements for a non-stocked item.

When you select this option, the Warehouse is set to ** and cannot be changed. The code you enter in the Stock code field must be a non-stocked item.

Stock code Enter the stock code for which you want to view demand requirements.

If you selected the Non-stocked option, then you need to enter a non-stocked code.

You can use the Browse icon to use the Stock Codes with Requirements program to view a list of all stocked and non-stocked items for which a demand was created.

Warehouse Indicate the warehouse for which you want to view the demand requirements for an item.
[Note]

You cannot access this field if you enabled the Consolidate selected warehouses setup option (Requirements Planning Setup).

MPS view This option applies to master production scheduled items.
Build schedule Displays the build schedule information for MPS items.
Actual demand Displays the actual demand information for MPS items. Actual demand for MPS items can only be viewed at a single level of pegging.
Change Rev/Rel Change the revision/release for an ECC-controlled item.
Refresh Refreshes the information displayed.

Preferences

Field Description
Preferences  
Pegging levels to display
Field Description
All Views all levels of a pegging (up to 14 levels).

When viewing all levels and pegging is dependent on higher level demand, then these levels are displayed in the Material Requirements Pegging list view.

Single Views a single level of a pegging.

Actual demand for MPS items can only be viewed at a single level.

Warehouse information to display
Field Description
Snapshot Displays the Snapshot warehouse information from the Requirements Calculation program.
Live Displays the live warehouse information.
Only display direct parent demand When viewing all pegging levels and pegging is dependent on higher level demand, then only the direct parent source of the demand is displayed.

MRP Graph

This displays a graphical representation of the available quantity and the minimum and maximum quantities for the selected stock code.

If you are not using the Inventory Optimization module, then the static minimum and maximum quantities from the warehouse are used (Warehouse Maintenance for Stock Code).

Information

This enables you to indicate various options according to which you want to display the information as well as displaying stock code and warehouse information.

Options

Field Description
Master production Schedule  
Include forecasts Includes forecasts when viewing actual demand.
Include sales orders Includes sales orders when viewing actual demand.
Build Schedule Select Show to use the Build Schedule Maintenance program to manually create and adjust build schedule records for the stock item.
Periods  
Period selection This option enable you to indicate the period for which you wish to view material supply and demand information.
FieldDescription
SingleView material supply and demand information for a single day.
Multiple daysView material supply and demand information for a number of days. All supply and demand within the specified range of dates is indicated on a single line.
Weeks

View material supply and demand information for weekly intervals. You are prompted to indicate the first day of the week.

All supply and demand within the specified range of dates is indicated on a single line.

Months

View material supply and demand information for monthly intervals.

All supply and demand from the current system date until the end of the month is indicated on the first line. Subsequent months are each indicated on single lines.

IO Forecast calendarUse the IO forecast calendar periods.
Number of days Enter the number of days required to be used when you select a period selection of Multiple days.

For all other period selections, the system displays the defaults number of days for that period and these cannot be changed.

First day of the week Indicate the first day of the week for the period selected.

Stock information

Details defined in the Stock Code Maintenance program for the stock item are displayed in this pane.

Refer to Time Fences for details on Time Fences.

Warehouse information

Details for the warehouse indicated are displayed in this pane.

You can view the material demands for ECC controlled components with WIP allocations against which the Deplete oldest rev/ref first setup option (Bill of Materials Setup) is enabled, in the Deplete oldest WIP field. (per event 66553

IO Min/Max Levels

The information in this pane only applies if you are using the Inventory Optimization module.

The module is used to calculate and output minimum and maximum (min/max) stock levels for stock items by calendar period. The IO current min/max levels (in the IopStockLevel table) are copied to the snapshot MRP min/max stock level table (MrpStockLevel) and used by the Requirements Calculation to derive an optimal requirement.

Multi-grade co-products are not supported in the context of min/max levels in Inventory Optimization.

No min/max levels are displayed for Notional parts; only for their Co-products.

See also: IO and MRP.

Material Requirements

This indicates the Material Requirements Details and Material Requirements Pegging information for the stock code/warehouse combination selected.

Material Requirements Details

The title of this pane indicates your selection at the Periods option in the Options section of the Information pane.

For MPS items, you can select to view the Build schedule or the Actual demand at the MPS View option.

Column Description
Period

Indicates the period of the demand/supply. The date is relevant to your selection at the Periods option.

not loaded is displayed for any supply falling into the date range January 1st, 2040 to December 31st, 2045.

This column cannot be sorted as it contains both text and date fields. To sort by date, you need to sort on the Start date column.

Available

Indicates the stock on hand less the allocated stock plus the stock in transit due to be received plus stock in inspection, for each stock code/warehouse combination (i.e. it is the quantity available netted off with the supply and demand from the previous period).

This is zero for MPS items where you have enabled the Build schedule option at the Include in requirements calculation field (Requirements Planning Setup). The available quantity on lines after the first line will be the previous line's result carried forward.

The calculation of the quantity available depends on the Requirements Planning Setup options selected. The calculation begins with the warehouse quantity on hand and adjusts this quantity depending on what you included in the MRP calculation.

For example:

  • If you include jobs and you are reserving lots and serials, then the quantity reserved is removed from the quantity on hand.
  • If you include jobs and you are reserving material allocations (WIP Setup) then the quantity reserved is removed from the quantity on hand.

  • If you are not including sales orders, then the quantity allocated to sales orders is removed.
  • If you are not using the full Goods in transit system, then the quantity in transit is removed.

The quantity in inspection (less the quantity scrapped) is added to the quantity on hand.

Supply

Indicates one or more of the following (depending on the Requirements Planning Setup options selected): quantity in transit, existing job, existing purchase order, estimate, suggested job, suggested purchase order requisition, existing purchase order requisition, IO min/max levels and associated batching rules if Inventory Optimization is in use.

[Note]

When using Inventory Optimization, the Target Service Level – defined against the policy (IO Policies) – is crucial in determining the resultant min/max levels.

The higher the Target Service Level, the higher the suggested Minimum, and by implication, the higher the suggested Maximum. The current min/max levels are used by the MRP calculation to address demand, in conjunction with Batching Rules set against the Inventory Master.

Therefore, the higher the target service level, the higher the suggested supply made by MRP. Suggested MRP supply must be critically reviewed for feasibility in relation to the target service level set.

Therefore, suggested supply generated via min/max levels are a sensitive issue in MRP, potentially affecting the profitability of your company. Suggested MRP supply must therefore be critically reviewed for feasibility in relation to the target service level set before any action is taken.

Demand Indicates one or more of the following (depending on the Requirements Planning Setup options selected): safety stock, sales orders, existing job allocations, suggested job allocations, build schedules, estimate allocations, forecasts.
Result Indicates the available quantity plus the supply less the demand. The Result for the current period is equal to the Available for the following period.
Start date

Indicates the start date of the selected period (for example for Months, it is the first day of the month).

When MRP calculates that a supply should be cancelled, the date is moved out beyond 31/12/2045 and therefore the Start date is displayed as 01/01/2046.

End date Indicates the end date of the selected period (for example for Months, it is the last day of the month).

Material Requirements Pegging

Field Description
Change

Change the pegging for the line currently highlighted in the list view.

When changing requisition stores transfers, both the supply and demand side of the pegging are updated.

When you change a component or a sub-assembly of a job, you are prompted to indicate whether you want to update the Job Header (see Job Entry) or to Change the Available Date (see Change Material Availability Date).

Zoom View additional information on the line currently highlighted in the list view.
Listview columns

This list view displays the reason for the supply or demand over the time period for the line currently highlighted in the Material Requirements Details list view.

When viewing all levels of pegging (i.e. when Pegging levels to display is set to All):

  • The supply date of the higher level pegging causing the demand on the current level is filtered on at the higher level. This will continue up the chain.

  • If a parent source key is duplicated on the current level, then only the first occurrence of the higher level source is exploded.

  • The Requirements Calculation ignores any purchase order (it actually physically deletes the lines from snapshot) that is part of a Call off single P/O which is not fixed and not in a status of completed or cancelled and therefore no supply is recognized against active live lines and no pegging is output.

    Because no existing supply is output, all demand raised is satisfied by raising a suggested requisition. Thus the MRP Requirements Planning Query can only reflect the pegging as suggested requisitions.

Column Description
Where-used structure This column can be selected as the default sequencing column. If you sequence on this column in ascending order, then all the higher level where-used structures will occur after the current level pegging.
Date Indicates the period in which the demand or supply occurred. This column cannot be sorted.
Quantity Indicates the quantity affected. A negative quantity indicates demand and positive quantity indicates supply.
Pegging source

Indicates the reason for the demand or supply and can be one of the following:

  • Estimate

    Demand caused by an allocation within estimate.

  • Finished stock code

    Supply caused by the finished part to make of estimate.

  • Existing job - Finished stock code

    Demand caused as a result of an allocation within job number.

  • Suggested job - Finished stock code

    Demand caused as a result of an allocation within a suggested job.

  • Existing job

    Supply caused by the finished part to make of job number.

  • Suggested job

    Supply caused by the finished part to make of suggested job number.

  • Sales order

    Demand as a result of sales order.

  • Existing purchase order

    Supply as a result of purchase order.

  • Existing requisition

    Supply as a result of existing requisition. The requisition originator code is MRP.

  • Suggested requisition

    Supply as a result of suggested requisition.

  • Requisition stores issue

    Demand as a result of a requisition stores issue.

  • Requisition stores transfer

    When viewing all levels, both the source warehouse pegging and the target warehouse pegging is displayed.

  • Safety stock

    This indicates the safety stock level.

  • Quantity in transit

    This indicates the quantity in transit between warehouse as a result of an inter-warehouse transfer.

  • Forecast <date> line: <line> Plan bill no: <stock code>

    This message indicates that a demand has been made due to a forecast for the date indicated.

    The Plan bill no: part of the message is only displayed for a planning bill part.

  • Build schedule <date> line: <line>

    This message indicates that a demand has been made due to a build schedule record for the date indicated

Source ID Indicates the number for the item displayed in the Source column (for example the job number, sales order number, etc.)
Level Indicates the level at which the demand/supply occurred. This is only displayed when you select to view All Levels in Pegging from the View menu.

Notes and warnings

Restrictions and limits

  • Although this program changes pegging and demand records according to changes made to the source transactions, it will not re-schedule the associated supply/demand.

    For example, if the Requirements Calculation program creates a job suggestion (supply) in response to insufficient stock being available for a sales order (demand) and you change the delivery date of the order, then the delivery date of the job remains unchanged.

  • The option Material Requirements Pegging (Requirements Planning Setup) is not applied in this program. Past due forecasts will generate past due supplies as displayed in the Material Requirements Pegging listview.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.