Inventory Requirements Planning
Navigation
Select Inventory Requirements Planning > Main > Inventory Requirements Planning.
Overview
Use this window to generate the IRP data file that is used to calculate demand. The following information is used to determine quantity requirements:
- Sales order line items
- Work ticket materials (for steps that do not have a Purchase status)
- Current inventory
- Supply from work tickets being made
- If planning by inventory item, supply from incoming purchase orders that are not linked to work tickets
- Reorder points and minimum order quantities defined in Reorder Maintenance
- Information that's been manually entered in Maintain Projected Demands
Inventory items assigned a procurement type of Buy to Stock, Buy to Order, Make to Order, and Make to Stock are included in the IRP data file.
Warning! The generated data is stored in a file that is not user-specific. If someone else generates the data, the previously generated data is overwritten.
After you generate data:
- If the Inventory Requirements Planning module is integrated with Production Management and items that need to be produced are included, click to manage the items that need to be produced and create work tickets. If Production Management is not integrated, click to view a report of inventory demand.
- If the Inventory Requirements Planning module is integrated with Purchase Order and if items that need to be purchased are included in the data, click to manage the items that need to be purchased and create purchase orders. If Purchase Order is not integrated, click to view a report of inventory demand.
Tips:
- If you are using this task to create both purchase orders and work tickets, you should create the work tickets first. The purchasing data will then be updated to reflect the material requirements for the newly created work tickets.
- You should generate the IRP data file at least once a day so that the latest information is reflected in the recommended quantities.
Note: If Inventory Requirements Planning is integrated with Production Management and you're exploding subassemblies, we recommend using Enhanced Scheduling to properly schedule work tickets. For more information, see Set Up Enhanced Scheduling.
For more information, see The IRP Generation Process.
Fields
Enter a setting or click the Save button to create a new setting with your saved selections.
button to view a list of settings. After selecting options, you can click theSelect this check box to save the current selection setting as the default setting.
Enter a description of the selection setting.
Select one of the following options:
- Select Inventory to plan materials procurement for items on work tickets, items on sales orders, and inventory items that need replenishment due to reorder point requirements.
- Select Work Ticket Number to plan materials procurement for inventory items associated with work tickets.
Select an option to determine which items are included in the procurement planning:
- Select Production to include inventory items that are assigned a procurement type of Make to Stock or Make to Order in Item Maintenance.
- Select Purchase to include inventory items that are assigned a procurement type of Buy to Order or Buy to Stock in Item Maintenance.
- Select Both to include all inventory items, regardless of the assigned procurement type.
Enter the date that represents the end of the planning period. This date is used to select items based on the promise date for sales orders and work tickets and the required date for purchase orders. Items with a promise date or required date that exceeds the cutoff date are not selected when you generate the data.
Tip: It's important to enter a cut-off date when generating the IRP work file to ensure that the recommended quantities require action by or before this date.
Click the Calendar button to select a date from the calendar.
Enter the date to determine component requirements for all bills. Click the Calendar button to select a date from the calendar.
This field is available only if the Base Effective Date on Release Date of Demand check box is cleared in the Inventory Requirements Planning Options window.
When this check box is selected, an item's primary vendor's lead time is included in the calculation of demand and supply with regard to the specified cutoff date, plus a 1 day buffer to allow for receiving processing.
Clear this check box to disregard vendor lead times in the calculation.
Select this check box to include the quantity amount of a parent item in an open work ticket.
If this check box is cleared, only released work tickets are included.
This field is available if the Inventory Requirements Planning module is integrated with Production Management.
Select this check box to include sales order quotes in the generated data.
Clear this check box to exclude sales order quotes.
This check box is available if the Inventory Requirements Planning module is integrated with Sales Order.
Select an option to determine how the excess demand for bills with a procurement type of Make to Order or Make to Stock are processed.
- Select Parent Item to only see the bill and not explode any levels on a multi-level bill.
- Select Parent and Component Items to explode all levels of a multi-level bill. When this option is selected, you will see the bill and all the required components to make the bill.
This field is available only if the Bill of Materials module is set up for the current company.
Select an option to determine where materials are pulled from:
- Select Bill of Materials to use materials from the bill when the work ticket is created.
- Select Template to use materials from the template when the work ticket is created.
- Select Bill and Template to use materials from both the bill and template when the work ticket is created.
Note: This field is available if the Inventory Requirements Planning module is integrated with Production Management and Parent and Component Items is selected at the Explode Make Action field. If Parent Item is selected at the Explode Make Action field, the Create Work Ticket with Materials From field defaults to Bill of Materials and can only be viewed.
Enter the number of days to use as the lead time if the primary vendor's lead time for an item is zero. The primary vendor's lead time is defined in Item Vendors Maintenance.
Lead time is the time to acquire the material from the vendor.
This field is available if the Include Lead Time check box is selected.
Enter the number of days to build a product from its components.
Enter the number of days to prevent the IRP generation process from creating an action of "Push-out" for purchase orders or work tickets that have a required date that precedes the demand required date. The action of "Push-out" is suppressed when the difference between the supply date and demand required date is greater than the number of days specified in this field.
To allow time for unpacking and placing the items in a warehouse, a purchasing agent may want to have parts arrive two days prior to the time that they are required for production. Because the required date for the purchase order precedes the required date for production, the system may recommend that you push out the purchase order by two days. If this was a common practice and there were many parts and purchase orders, the number of suggested actions would be overwhelming. When running the IRP generation process, you can enter a default number of days at the Advanced Arrival Allowance (Days) field that prevents the system from making push-out recommendations if the required date is within the number of days specified.
Select this check box to include the projected demands from Maintain Projected Demands in the generated data.
Enter a starting date for the projected demands data or click the Calendar button to select a date from the calendar.
The module date is the default date, but you can change it.
This field is available if the Include Projected Demands check box is selected.
Enter an ending date for the projected demands data or click the Calendar button to select a date from the calendar.
The default date is a month out from the module date, but it can be changed.
This field is available if the Include Projected Demands check box is selected.
Select an operand to limit your selection to a particular value or range of values. When selecting a value using the Lookup button or entering a value directly into the value's field, the operand automatically changes to Equal to. Likewise, when selecting a value using the Lookup button for a range or entering values directly into both value fields, the operand automatically changes to Range.
The following operands are available:
Operand |
Operand Function |
---|---|
All |
Selects all information for the Select Field. |
Begins with |
Selects only the information for the Select Field that begins with the value entered in the Value field. |
Ends with |
Selects only the information for the Select Field that ends with the value entered in the Value field. |
Contains |
Selects only the information for the Select Field that contains the value entered in the Value field. |
Less than |
Selects only the information for the Select Field that is less than, but not equal to, the value entered in the Value field. |
Greater than |
Selects only the information for the Select Field that is greater than or equal to the value entered in the Value field. |
Range |
When Range is selected, two Value fields are used. Information is selected that is greater than or equal to the first value entered and less than or equal to the second value entered in the Value fields. Entering a range of account numbers produces different selection results than entering a range of main accounts and segments. When you specify a range of account numbers, all account numbers in that range are selected. When you specify a range of main accounts, all accounts beginning with the specified main account numbers are selected. Main account selections override account number selections. Note: Entries in the "From" Value field may change to the entry made in the "To" Value field, if the "From" Value contains a lowercase letter and the "To" Value contains an uppercase letter. This occurs because lowercase letters are greater than uppercase letters. For example, if 01a is entered in the "From" Value field and 01C is entered in the "To" Value field, the "From" Value field changes to 01C. |
Equal to |
Selects only the information for the Select Field that is equal to the value entered in the Value field. |
Not Equal to |
Selects only the information for the Select Field that is not equal to the value entered in the Value field. |
Additional operands are available for date Select fields. The system date is used to calculate the date ranges. When one of the date operands is selected, the Value fields automatically default to the appropriate dates.
Multiple values can be entered using a comma (,) to expand the selection criteria. You can also use alternate separators (other than the reserved comma) to separate multiple selection values. Alternate separators include: ~ ! @ # $ % ^ & * ( ) = [ ] \ ; " / _ + { } | : < > ?
Notes:
- When alternate separators are used, the value list must end with the alternate separator character.
- If you enter a value that contains
a comma (for example, if a vendor number is
01-SAGE,WEST ), then you must enclose the value with an alternate separator (for example,%01-SAGE,WEST% ). Because the comma is a separator, if the value is not enclosed in alternate separators, the system can search for two incorrect values (for example, "01-SAGE" and "WEST", instead of "01-SAGE,WEST").
Enter a value based on the operand entered, or click the Lookup or Calendar button to select a value from the list. Multiple values can be entered by using a comma or alternate separators to separate values.
For customer number, vendor number, and item code select fields, you can start typing a customer name, vendor name, or item description to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list.
You can enter single or multiple values as follows:
Operand |
Value |
---|---|
All |
Selects all information for the Select Field. |
Begins with |
Multiple values are separated by a comma or alternate separator. An OR condition is assumed. |
Ends with |
Multiple values are separated by a comma or alternate separator. An OR condition is assumed. |
Contains |
Multiple values are separated by a comma or alternate separator. An OR condition is assumed. |
Less than |
Only single values are allowed. |
Greater than |
Only single values are allowed. |
Range |
Both Value fields are used to define a range. Only single values are allowed at each Value field. |
Equal to |
Multiple values are separated by a comma or alternate separator. An OR condition is assumed. |
Not Equal to |
Multiple values are separated by a comma or alternate separator. An AND condition is assumed. |
Note: If you
enter a value that contains a comma (for example, if a vendor number is