Maintaining Policy Items

This chapter provides an overview of inventory policy items, lists common elements, and discusses how to:

Click to jump to parent topicUnderstanding PeopleSoft Inventory Policy Items

Inventory Policy master records contain item-specific information about all PeopleSoft Inventory Policy Planning items. When you generate a policy, you can use this information to determine stocking policy for the items. The system defines each policy item as a unique combination of item and location within a given policy set.

Policy items contain parameters and controls that determine the manner in which the system calculates its inventory policy recommendations. These parameters include methods, arguments, and limits that are used to generate time-phased and static values for order quantity, safety stock, reorder quantity, and minimum and maximum quantities.

You can associate an individual item with more than one policy set, enabling you to create different inventory policy parameters for different stocking requirements.

After you create a master policy item, you can transfer forecasts and generate a policy for the item from a published forecast. To create an inventory policy for policy items that are contained in a published forecast:

  1. Run the Generate Policy routine by using the Transfer Forecasts option and selecting the publish name and forecast publish date for your published forecast.

  2. Create the forecast.

  3. Assign items to the forecast, and generate and publish the forecast.

  4. Create policy sets, linking the set to a map ID by using the Define Policy Sets page.

  5. Create an item import specification, and select the Create Missing IP Master field to have the system create the master policy if it doesn't exist in PeopleSoft Inventory Policy Planning.

  6. Populate PeopleSoft Inventory Policy Planning with data from PeopleSoft Inventory.

  7. Generate the inventory policy.

  8. Publish inventory policies by:

This diagram summarizes the elements and system flow for using item master policies in PeopleSoft Inventory Policy Planning with a published forecast:

Click to jump to parent topicCommon Elements Used in This Chapter

Argument

Enter a numeric value that the system uses to calculate inventory policies. When you establish policy items, you define methods for calculating replenishment points, safety stock, order quantities, and minimum and maximum inventory levels. Use arguments to establish a number of order and item policies.

Policy Set

Defines a set of the items for which the system calculates an inventory policy. You assign each policy set a unique ID and include information that defines, for example, the associated map ID, time periods, and planning horizon. You assign policy items to policy sets.

Click to jump to parent topicDefining Policy Items

To define policy items, use the IP Master component.

This section provides an overview of policy item creation and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Policy Item Creation

Use these methods to create policy item master records:

You can change information that is associated with a policy item at any time; however, the changes do not affect inventory policy values until the next time that you generate an inventory policy.

When you create or change a policy item, the system validates the changes for use with PeopleSoft Inventory Policy Planning.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Policy Items

Page Name

Definition Name

Navigation

Usage

Define Policy Items

DP_IPMASTER

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items

Define basic information for policy items.

OQ/SS Policy (order quantity and safety-stock policy)

DP_IPMASTER_2

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, OQ/SS Policy

Define order quantity and safety-stock data for individual policy items.

RP/MM Policy (reorder point/minimum and maximum policy)

DP_IPMASTER_3

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, RP/MM Policy

Define reorder point and minimum and maximum stocking policies for inventory policy items.

Price/Costs

DP_IPMASTER_4

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, Price/Costs

Set up standard cost and pricing information for policy items. You can record either a single default standard cost or a separate cost for each policy period.

Other Data

DP_IPMASTER_5

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, Other Data

Define other data for policy items. This is miscellaneous information that is associated with inventory policies.

User Fields

DP_IPMASTER_6

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, User Fields

Assign user fields to policy items. This data is specific to the organization.

Click to jump to top of pageClick to jump to parent topicDefining Basic Information for Policy Items

Access the Define Policy Items page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items).

Inventory Unit

Select an inventory unit of measure (UOM) for this policy item. This is a required field. The default value changes depending on how the item is created. For policy sets where inventory is in use, the default value is the standard inventory UOM from the inventory master. For policy sets where PeopleSoft Inventory in not in use, the default value is the base UOM from the DP_FCITEMS record.

Policy Control

Select a policy control group to assign to the item. This group contains a set of default policy parameters and methods that the item will inherit from the control group upon creation or update. Policy items that belong to the same control group should have similar order, safety-stock, and reorder policies. You cannot use an item until it belongs to a control group.

Utilization Group

Select a group with which you want this item associated. The system also uses the group that you select as a default if you do not make a selection on the Policy Controls page when you set up control groups. Utilization groups are used to group items together for cycle counting or planning purposes.

Utilization Type

Select a type with which you want this item associated. Utilization types classify inventory items based on demand and usage. By using this field, you can assign an ABC code to the item. If you leave the field blank, the counting event includes all items with defined cycle intervals until the maximum number is reached.

Inherit Controls

Select to inherit policies. Inheriting policy controls is when the system updates the policy control, and changes to the items are written to the policy items that have this check box selected. When this check box is deselected, the system writes policy control changes to policy master items only if they are selected, or the Inherit All check box is selected for the policy control group.

Method

Select a method to indicate how the system calculates the static inventory policy for this policy master record. Although PeopleSoft Inventory Policy Planning calculates time-phased values for parameters such as safety stock and reorder quantity, many systems recognize only a single, fixed value for each parameter. This method is used to calculate these static quantity values. This field is required.

Static calculations enable you to calculate a single value from the time-phased results. The system can then export that value to the organization's inventory control system. Values include:

  • Period Number: The static policy equals the time-phased policy for the current year's period that you define in the Argument field.

  • Periods to Average: The system calculates the static policy by averaging the time-phased policy values for the number of periods that you specify in the Argument field.

Argument

Enter a value as an argument for either the period or average method that you select in the Method field. This field is required.

This field value indicates either a specific period number if you selected Period Number in the Method field or a number of periods to include when averaging if you selected Periods to Average.

Note. If the Uses Inventory check box is selected for the policy set associated with the item, then the system displays a drop-down list box for the Utilization Group and Utilization Type fields. From this drop-down list box, you can select values that were created in PeopleSoft Inventory. If the Uses Inventory check box is not selected, then the system displays a text box for the Utilization Group and Utilization Type fields.

Click to jump to top of pageClick to jump to parent topicDefining Order Quantity and Safety-Stock Policies

Access the OQ/SS Policy page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, OQ/SS Policy).

Order Quantity Policy

Use this group box to establish order replenishment quantities.

Method

Select a method to control how the system determines replenishment order quantities. Each method has an associated argument. Values are:

  • Days Supply: Always order a certain number of days supply of this item. Enter the number of days in the Argument field.

  • Economic Order Quantity: Uses the economic order quantity (EOQ) calculation to determine the order quantity. The calculation is intended to establish a fixed order quantity that minimizes the cost of processing and carrying inventory.

  • Fixed Quantity: Always order a fixed quantity of this item for this location. Enter the quantity in the Argument field.

  • Lot for Lot: Order exactly what is needed to satisfy the immediate requirements (demand) for the lead time.

  • None: The system does not use a specific order method.

Limits

Places upper and lower limits on reorder quantity, which the system calculates by using the methods specified in the Method field definition. Values are:

  • Days Supply: Order no more than the number of days supply that is indicated in the Upper and Lower limit fields.

  • Fixed Quantity: Order no more than the fixed quantity that is specified in the Upper and Lower limit fields.

  • None: The system does not set limits on the order quantity.

Lower

Enter the minimum quantity or minimum number of days to be applied to the order quantity. If you select Fixed Quantity or Days Supply, you must enter the upper and lower limits for this item. Otherwise, you can leave this field empty.

Upper

Enter the maximum quantity or maximum number of days to be applied to the order quantity. If you select Fixed Quantity or Days Supply, you must enter the upper and lower limits for this item. Otherwise, you can leave this field empty.

Order Multiples

Enter the item quantity to which the system should round when placing an order. The system compares calculated order quantities to the order multiple and rounds up to an integer when you use the order policy calculation type. The system makes the comparison when it generates the order quantity during policy processing.

Order Quantity

Displays static data that represents the current fixed order quantity. During policy generation, the system uses the parameters that are indicated on the static calculation policy to calculate order and safety stock values. You cannot change this value. The system recalculates the value each time that it regenerates the inventory policy.

Safety Stock Policy

Use this group box to set up levels of inventory that assist in planning for demand and supply fluctuations.

Method

Select a safety-stock method. Values are:

  • % Cycles Without Shortage (percentage of cycles without shortage): The system sets the safety-stock level so that a percentage of inventory cycles can occur without creating a shortage. Enter the percentage in the Argument field.

  • Days Supply: The safety stock is a specific number of days of forecast demand for this item. Enter the number of days supply in the Argument field.

  • Fixed Quantity: The appropriate safety stock is a specific quantity of inventory that the system uses as the level to maintain. Enter the quantity in the Argument field.

  • Maximum Lead Time Usage: Bases the safety-stock level on demand history. The system sets the level to the maximum usage that is likely to occur during the item's purchase lead time. An argument is not required.

    Note. The system calculates maximum lead-time usage only during the transfer of forecast information to PeopleSoft Inventory Policy Planning. This means that a change in the method by which it calculates the maximum lead time for an inventory policy item won't take effect until the next time it transfers a forecast.

    To determine the manner in which the system calculates usage, use the Historical Usage Calc Method (historical usage calculation method) field on the Other Data page. Normally you use this method when the demand for an item is low or intermittent, but sufficient stock must always be available.

  • None: Safety stock isn't required. You do not need to enter a safety-stock quantity in the next field.

  • Percentage Demand Fill: The system sets the safety-stock level to a particular service level that will prevent running out of inventory. You enter the service level percentage in the Argument field.

Limits

Select a limits method. The system uses this parameter to place upper and lower limits on the safety-stock quantity. Values are:

  • Days Supply: Safety stock is not more than the number of days supply that you define as the upper and lower limits.

  • Fixed Quantity: Safety stock must be within the fixed quantity that you specify in the Lower and Upper limits fields.

  • None: The system does not set limits on the safety stock for this item.

Lower

Enter the minimum quantity or minimum number of days to be applied to the safety stock.

Upper

Enter the maximum quantity or number of days to be applied to the safety stock.

Safety Stock

Displays the static data that represents the current inventory safety stock quantity. During policy generation, PeopleSoft Inventory Policy Planning uses the parameters that are indicated on the static calculation policy to calculate order and safety stock values. You cannot change the value. The system recalculates the value each time that it regenerates inventory policy.

Click to jump to top of pageClick to jump to parent topicDefining Reorder Point and Minimum and Maximum Policies

Access the RP/MM Policy page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, RP/MM Policy).

Reorder Point Policy

Use this group box to create a policy that determines the stockkeeping inventory level at which you launch a replenishment order.

Method

Determines how the system calculates the reorder point for a policy item. Each method has an associated argument. Values are:

  • Days Supply: Calculates the reorder point as a specific number of days of supply of this item's forecast. Enter the number of days in the Argument field.

  • Fixed Quantity: Calculates the reorder point as a fixed quantity. Enter the quantity in the Argument field.

  • Lead Time + Safety Stock: Calculates the reorder point as the quantity that is required to meet forecasted demand over the vendor lead time plus the safety stock of the item.

  • Lead Time Demand: Calculates the reorder point as the quantity that is required to meet forecasted demand during the vendor lead time.

  • None: The system does not use a reorder point calculation.

Reorder Point

Displays static data that represents the current reorder point. During policy generation, the system uses the parameters that are indicated on the static calculation policy to calculate order and safety stock values. You cannot change this value. The system recalculates the value each time that it regenerates inventory policy.

Order Quantity

Displays static data that represents the current fixed order quantity. During policy generation, the system uses the parameters that are indicated on the static calculation policy to calculate order and safety stock values. You cannot change this value. The system recalculates the value each time that it regenerates the inventory policy.

Minimum and Maximum

Use this group box to establish minimum and maximum values as warning limits. The limits that you establish are only warnings; they do not determine actual inventory levels. An Argument field is available for both minimum and maximum method arguments.

Minimum Method

Select the method that controls the calculation of an overall minimum quantity for the item. Values are:

Days Supply: The minimum inventory level is a sufficient quantity to cover a specified number of days of forecasted demand for this item. Enter this quantity in the minimum method Argument field.

Fixed Quantity: The minimum inventory level is a specific quantity of inventory that appears in the minimum method Argument field.

None: Minimum inventory is not required. You do not need to enter a value in minimum method Argument field.

Safety Stock: The minimum inventory level equals the safety-stock level.

Maximum Method

Select the method that controls the calculation of an overall maximum quantity for the item. Values are:

  • Days Supply: The maximum inventory level is a sufficient quantity to cover a specified number of days of forecasted demand for this item. Enter this quantity in the maximum method Argument field.

  • Fixed Quantity: The maximum inventory level is a specific quantity of inventory that appears in the maximum method Argument field.

  • None: Maximum inventory is not required. You do not need to enter a value in the maximum method Argument field.

  • Safety Stock + Order Quantity: The maximum inventory level equals the safety-stock level plus the order quantity.

Static Data

This group box displays static values that represent the current minimum and maximum fixed order quantity. The minimum value appears in the Minimum field and the maximum value appears in the Maximum field. During policy generation, the system uses the parameters indicated on the static calculation setting to calculate order and safety stock values. You cannot change this value, but the system recalculates it each time that it regenerates inventory policy.

Click to jump to top of pageClick to jump to parent topicSetting Up Price and Costs

Access the Price/Costs page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, Price/Costs).

Along with price and cost data, this page provides graphical time-phased data for the item. You can manually enter or update values, including total period costs, for the item.

Standard Cost/Price

Use this group box to define cost and price data for individual policy items.

Standard Price

Enter a sales price for the item.

Carrying Cost % (carrying cost percentage)

Enter the cost percentage that is associated with holding inventory for the policy item for one year. The system applies this percentage to the standard cost of the item. For example, if the standard cost is 10 EUR and the carrying cost is 15 percent, then the system applies an additional 1.50 EUR to the item's cost, making it 11.50 EUR.

Standard Cost

Enter the cost for one inventory unit of this policy item. The system uses this amount as the inventory's value when an item cost is required for planning operations.

Order Cost

Enter the cost of placing and executing an order for this item. The system assumes that ordering costs include all aspects of ordering, including administrative costs, handling, and quality control costs. It doesn't include carrying costs that the system automatically applies.

All Values per

Displays the UOM for the values that you entered on this page. Define the UOM in the Inventory Unit field on the Description page.

Period Cost

PeopleSoft Inventory Policy Planning uses the static standard cost for any periods that indicate a zero period cost; therefore, you must enter only exceptions to the static standard cost. Use the Cost field to change the cost that is associated with a period.

Click to jump to top of pageClick to jump to parent topicDefining Other Data for Policy Items

Access the Other Data page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, Other Data).

Lead Time

Enter the amount of time that is needed to complete an order for this policy. This includes ordering, vendor lead time, handling, inspection, and warehouse putaway.

Lead Time UOM (lead time unit of measurement)

Displays the default lead-time UOM, which is Day. This is the only lead-time UOM.

Volume

Displays a value that represents the volume of the item. This value is populated from the PeopleSoft Inventory master item if you selected the Uses Inventory check box on the policy set. The system can use this value for inquiries and publishing inventory policy values. You can overwrite the value.

Volume Unit

Enter the unit of measure that is associated with the item's volume.

Weight

Displays a value that represents the weight of the item. This value is populated from the PeopleSoft Inventory master item if you selected the Uses Inventory check box on the policy set. The system can use this value for inquiries and publishing of the policy values. You can overwrite the value.

Weight Unit

Enter the unit of measure that is associated with the item's weight.

Maximum Historical Usage

Enter the maximum historical usage that the system considers during calculating orders for an item.

Historical Usage Method

Select a method for calculating historical usage. Based on a review of the historical demand, the safety stock or minimum is set to a constant value, which is the same for all periods. If you leave this field blank, the systems enters the static value by default when you save the data. Values are:

  • Static: The system uses the data that you enter in the Argument field as the maximum lead time usage. No further calculation is performed.

  • Lead Time Daily Usage (lead time estimated daily usage): The system prorates historical demand on a daily basis and then multiplies it by the number of days lead time for each historical period. It then uses the maximum period value as the safety- or minimum-stock level. Use this method for items that have a steady demand pattern throughout each period.

  • Lead Time Period Usage: The system rounds up the purchase lead time to a specified number of periods. The system calculates historical demand as the maximum usage during these periods, and the safety- or minimum-stock level is set to this value. Use this method for items that have few demand instances for each period.

  • Maximum Possible Usage: The system rounds up the purchase lead time to a specified number of periods and adds an additional period. It calculates the historical demand as the maximum usage during these periods, and sets the safety- or minimum-stock level to this value. Use this method for items that have sporadic, low levels of demand.

    Note. The system calculates maximum lead time usage only during the transfer of forecast information to PeopleSoft Inventory Policy Planning. This means that a change in the method for calculating the maximum lead time for an inventory policy item doesn't take effect until the next time that a forecast is transferred.

Last Change

Displays the date that the item policy was last changed.

Policy Item Units of Measure

Inventory Unit

Displays the inventory unit of measure for this policy item.

To Unit

Select a UOM to which you want to convert the current UOM. When the system initially creates policy items, it automatically assigns EA (each) as the default inventory unit. During conversion processing, the system replaces this UOM with the item-specific unit that you select here unless there is a weight or volume UOM for the item. In this case, the system first uses the weight value and then the volume value. This field is required.

The system determines available units by values that you set up using PeopleSoft Financials and Supply Chain Management.

See Defining UOMs and UOM Conversions.

Conversion Factor

Enter a value for converting from the inventory unit to the to unit. A conversion factor is applied to the inventory-unit quantity to convert it to the equivalent to-unit quantity. To create new conversions, select to values from the drop-down list.

You can change conversion factors at any time, which only affects future uses of the factor in calculations. Make sure that the conversion factor is not being referenced in other parts of the system before deleting it.

Click to jump to top of pageClick to jump to parent topicAssigning User Fields to Policy Items

Access the User Fields page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items, User Fields).

Use user-defined fields to maintain policy item data that is specific to the organization. User data codes that are associated with each policy set determine the number of fields and their contents. Fields that appear on this page vary according to each organization's definition of its data.

User Field

Displays the user-defined field that is associated with the policy set to which this item policy belongs. You cannot change this value. You define user-defined fields by mapping them to existing planning fields. The purpose is to provide you with a means of naming a field so that the data that is contained in the field is more meaningful to you. You must define the fields as Field In Use.

User Data

Displays data that the system has imported for an item. You can replace existing values.

Click to jump to parent topicPopulating Inventory Policies with PeopleSoft Inventory Data

You can populate or update records directly from PeopleSoft Inventory. During record creation, the system uses data from Inventory as well as from the default control group that is assigned to the policy set that you are populating.

When you run the Populate Policy Items process (DP_IPPOPULAT), the system loads data from PeopleSoft Inventory. The system loads user-defined fields according to how you map the fields.

This section discusses how to populate policies with PeopleSoft Inventory data.

See Also

Fields Imported and Published by PeopleSoft Inventory Policy Planning

Click to jump to top of pageClick to jump to parent topicPage Used to Populate Inventory Policies with PeopleSoft Inventory

Page Name

Definition Name

Navigation

Usage

Populate from Inventory

DP_IPPOPULATE

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Populate from Inventory

Populate policies with PeopleSoft Inventory data. During processing, the system applies control group default values to the items.

Click to jump to top of pageClick to jump to parent topicPopulating Policies with PeopleSoft Inventory Data

Access the Populate from Inventory page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Populate from Inventory).

Status

Use this group box to define the status that an item should have for populating PeopleSoft Inventory Policy Planning items fields. Assign these statuses to items on the General page in Items feature. For example, to populate only items that are active in PeopleSoft Inventory, select Active.

Active

Select to populate fields of data for items that have an Active status in PeopleSoft Inventory.

Pending Approval

Select to populate fields of data for items that have a Pending Approval status in PeopleSoft Inventory. For example, you might have an item that's not ready for use in PeopleSoft Inventory, but you have a forecast for it and want to create an inventory policy for it. You can begin planning for the item. Items with Pending Approval status are in the last status before they become active items, and the system enables some functions to be performed with the items in this status.

Both

Select to populate fields of data for items that have an Active or a Pending Approval status in PeopleSoft Inventory.

Inventory Item

Use this group box to have the system populate fields for PeopleSoft Inventory or noninventory items. Define an item as an inventory item that PeopleSoft Inventory tracks on the General page in the Items feature.

Yes

Select to populate fields with only PeopleSoft Inventory items. The system populates fields based on the selection that you make in the Inventory Item and Status group boxes.

No

Select to populate fields for items that are not set as inventory items. This means that you can create policies for items that aren't in inventory. You might want to do this, for example, when you plan for items that you buy from a vendor and ship directly to a customer. Creating policies for the item helps you collaborate with the vendor to ensure that you do not experience stockouts.

Both

Select to populate PeopleSoft Inventory Policy Planning item fields of data using inventory and noninventory items.

Other Fields

Policy Control

Use this field to select which control group to use with the policy set for this run control ID.

Delete Non-Matching IP Items (delete nonmatching inventory policy items)

Select this check box to have the Populate process delete policy items that do not exist in the DP_IP_MASTER or BU_ITEMS_INV record. This process also deletes items that have had settings as a PeopleSoft Inventory Policy Planning item in the BU_ITEMS_INV record changed to N.

Note. When you run the Populate process, it loads the item into the policy set only if it doesn't already exist. If you want to update existing items, use the Refresh feature.

Items to Select

By using selection criteria, you can further filter which items are populated in PeopleSoft Inventory Policy Planning. Items that you select come from the BU_ITEMS_INV record, where the item has been designated as a policy planning item. If you leave the grid empty, the system populates all eligible items.

The policy set determines the items and business units that are available for you to define as selection criteria. Select Item ID in the Field Namefield to select specific items to populate from PeopleSoft Inventory.

Select Business Unit in the Field Namefield to select items to populate from specific business units in PeopleSoft Inventory. This record represents items at specific locations.

See Defining Selection Criteria.

Click to jump to parent topicRefreshing Policies with PeopleSoft Inventory Data

In addition to populating policy items, you can refresh item data from PeopleSoft Inventory records. During the Policy Item Refresh process (DP_IPREFRESH), the system updates certain data elements by default; you can select others as needed.

Note. You can refresh only items that already exist in PeopleSoft Inventory Policy Planning. To add new items, use the Populate feature.

This section discusses how to refresh policies with PeopleSoft Inventory data.

Click to jump to top of pageClick to jump to parent topicPages Used to Refresh Policies with PeopleSoft Inventory Data

Page Name

Definition Name

Navigation

Usage

Refresh From Inventory

DP_IPREFRESH

Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Refresh from Inventory

Refresh policies with PeopleSoft Inventory data.

Selection Criteria

DP_IPPOPSEL_SEC

Click in the Items to Select group box to filter data on the Refresh from Inventory page.

Select which business units or items to include in selection criteria.

Click to jump to top of pageClick to jump to parent topicRefreshing Policies with PeopleSoft Inventory Data

Access the Refresh from Inventory page (Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Refresh from Inventory).

Warning! The Refresh process overwrites changes that you make to the items manually.

The items that you can work with on this page are associated with the set that you enter in the Policy Set field.

Select the Delete Non-Matching IP Items (delete nonmatching inventory policy items) check box to have the Refresh process delete policy items that do not exist in the DP_IP_MASTER or BU_ITEMS_INV record. This process also deletes items that have had a setting as a PeopleSoft Inventory Policy Planning item in the BU_ITEMS_INV record changed to N.

With selection criteria, you can further filter which items are refreshed in PeopleSoft Inventory Policy Planning. Items that you select come from the BU_ITEMS_INV record, where the item has been designated as a policy planning item. In the Field Name field in the Items to Select grid, the following choices are available:

Item ID

Use to select specific items to refresh from PeopleSoft Inventory.

Business Unit

Use to select items to refresh from specific business units in PeopleSoft Inventory.

See Defining Selection Criteria.

Use the Field Name field in the Fields to Refresh grid to indicate which fields to refresh. The system refreshes the fields based on the selection criteria that you define for the Policy Item Refresh process. Click the Select All button to refresh all fields.

Click to jump to parent topicDeleting Policy Items

This section describes how to delete policy items.

Click to jump to top of pageClick to jump to parent topicPage Used to Delete Policy Items

Page Name

Definition Name

Navigation

Usage

Delete Policy Items

DP_DEL_IPMASTER

Inventory Policy Planning, Process Deletions, Policy Items

Define selection criteria for deleting policy items, preview policy items for deletion, select a deletion method, and delete policy items.

Click to jump to top of pageClick to jump to parent topicDeleting Items

Access the Delete Policy Items page (Inventory Policy Planning, Process Deletions, Policy Items).

The Process Deletions feature enables you to delete a variety of inventory policy elements. You can delete a single element or multiple elements. Using the Delete Policy Items page, you can define selection criteria for the items that you want to delete. You can immediately delete the items online or use the Process Scheduler to delete the items the next time you run the Delete IP Master Items (DP_IPMDEL) process.

To delete policy items immediately:

  1. Complete the selection criteria, and click the Preview button.

    The system populates the Preview grid box with the items that match the criteria you entered.

    See Defining Selection Criteria.

  2. Review the items and locations in the list.

  3. Click the Delete Now button.

    The system prompts you with a message indicating that you are about to delete these policy items for the policy set.

    Warning! You should use this button only to remove small numbers of policy items. When processing large volumes, the system might issue an error message when you delete them immediately. Use the run control ID to submit a batch process to delete large volumes of forecast items.

  4. Click the Yes button.

    The system permanently removes the items.

To delete items later using the Process Scheduler, select a run control ID that runs the Delete IP Master Items process. The system prompts you with a message indicating that you are about to delete the policy items. The items will be permanently deleted when the process is run.

Click to jump to parent topicMaking Mass Changes to Policy Items

This section provides an overview of mass changes to policy items and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Mass Changes to Policy Items

You use mass changes to apply item changes to multiple items at the same time. For example, you can add five percent to the price values for all items that are in the policy set, or you can update the average cost for a certain group of items that is in the policy set. The system stores specifications that you define for mass maintenance in the DP_IPPMASS_HDR record.

To make mass changes:

  1. Create a specification to use for the fields to which you want to make changes for policy items.

  2. Select mass maintenance groups to be included in the specification.

  3. Define how you want the system to apply changes to target fields.

  4. Process mass changes for policy items using the IP Mass Change (DP_IPMASCALC) process.

The system validates information that you enter in the Target and Source fields against values contained on policy item and control group pages. This validation is established using the Update Operations page and prevents you from entering a mass maintenance choice that would not be valid for policy items. PeopleSoft provides mass maintenance groups that make it possible for you to perform updates for multiple inventory policy items with control group updates.

Mass maintenance groups are combinations of target fields that relate to a specific type of mass update that you might want to perform. For a maintenance group, you can specify the type of action (operator) that should be performed against a target field. This includes, for example, adding a value that the system places in the target field during the mass change processing or extracting a value from a source field that you can move to a target field.

This table describes the actions for operators:

Operator

System Action

Requirements

Add

Divide

Multiply

Subtract

Using the operator, the system adds, divides, multiplies, or subtracts the operand against the target and stores the result. If you select a source, the system applies the operand to the Source field value and stores the result in the Target field.

The Operand field is required if a source is selected.

Blank

The system blanks out the target field and stores the result.

None

Replace

The system replaces the Target field value with the operand and stores the result.

The Target and Operand fields are required.

Move

The system copies data from the Source field to the Target field.

The Target and Source fields are required and must be different fields. The system does not allow incompatible matches between fields, such as text to numeric, numeric to Boolean, and so forth.

The next table lists the mass maintenance groups provided by PeopleSoft Inventory Policy Planning. It also shows the fields for each group and the operators available for the fields, along with information about the group:

Mass Maintenance Group

Target Fields/Operators

Source Fields

Operands/Attributes

General Policy Item Data

Policy Control (Replace only)erit Controls (Replace only)Description (Replace and Blank)

Inventory Unit (Replace only) Utilization Group (Replace and Blank)

Utilization Type (Replace and Blank)

For the Description target field, you can enter text or select DP_ITEMCODE: DP_LOCATION in the Source field.

Attributes include:

  • The policy control prompt table is DP_POLICYCTRLS.

  • You select whether to replace inherited policy controls.

  • If the system is using PeopleSoft Inventory for the policy set associated with the control group, then the system displays a list of Inventory created groups for the utilization group. These groups have the Use for Planning check box selected in Utilization Groups under Items-Define Controls. If the Uses Inventory check box is not selected, then the system displays a text box for the Utilization Group field.

  • If the system is using inventory for the policy set associated with the control group, then the system displays a list of PeopleSoft Inventory created types for the utilization type. If the Uses Inventory check box is not selected, then the system displays a text box for the Utilization Type field.

Minimum And Maximum

Minimum Method (Replace only)

Minimum Argument (Add, Divide, Move Multiply, Replace, and Subtract) Maximum Method (Replace only)

Maximum Argument (Add, Divide, Move Multiply, Replace,and Subtract)

For both the Minimum Argument and Maximum Argument fields, the Source field values include:

  • Maximum Argument or Minimum Argument (for the corresponding argument).

  • Order Quantity Argument.

  • Reorder Point Argument.

  • Safety Stock Argument.

  • Static Calculation Argument.

Attributes include:

  • Operand values that include: None, Days Supply, Fixed Quantity, and Safety Stock for the Minimum Method. Instead of Safety Stock, the Maximum Method uses Safety Stock + Order Quantity.

  • If the Minimum Method field value is None or Safety Stock, then the Minimum Argument field must be equal to zero.

  • If the Minimum Method field value is Days Supply or Fixed Quantity, then the Minimum Argument field must be greater than zero.

  • If the Maximum Method field value is None or Safety Stock + Order Quantity, then the Maximum Argument field must be equal to zero.

  • If the Maximum Method field value is Days Supply or Fixed Quantity, then the Minimum Argument field must be greater than zero.

  • If the minimum method is equal to the maximum method then the minimum method argument must be less than the maximum method argument.

Order Details

Lead Time (Replace only)

Volume (Add, Divide, Move Multiply, Replace, and Subtract)

Volume Unit (Replace only)

Weight (Add,Divide, Move Multiply, Replace,and Subtract)

Weight Unit (Replace only)

Historical Usage Method (Replace only)

Maximum Historical Usage (Add, Divide, Multiply, Replace, and Subtract)

For the Volume field, the Source field value is Weight.

For the Weight field, the Source field value is Volume.

Attributes include:

  • The system automatically sets the control group lead time to one if you attempt to save the update operation with a value of zero.

  • Operands for the Volume Unit and Weight Unit fields are retrieved from the list of values stored in the UNITS_TBL record.

Order Quantity Policy

Order Quantity Method (Replace only)

Order Quantity Argument (Add, Divide, Move Multiply, Replace,and Subtract)

Order Quantity Limit Method (Replace only)

Order Quantity Lower Limit (Add, Divide, Move Multiply, Replace,and Subtract)

Order Quantity Upper Limit (Add, Divide, Move Multiply, Replace, and Subtract)

Order Multiples (Add, Divide, Multiply, Replace, and Subtract)

For the Order Quantity Argument field, the Source field values are:

  • Maximum Argument

  • Minimum Argument

  • Reorder Point Argument

  • Safety Stock Argument

  • Static Calculation Argument

For the Order Quantity Lower Limit field, the Source field values are:

  • Order Quantity Upper Limit

  • Safety Stock Lower Limit

  • Safety Stock Upper Limit

For the Order Quantity Upper Limitfield, the Source field values are:

  • Order Quantity Lower Limit

  • Safety Stock Lower Limit

  • Safety Stock Upper Limit

Attributes include:

  • Operand values for the Order Quantity Method field include: None, Days Supply, Fixed Quantity, Economic Order Quantity, and Lot for Lot.

  • Operand values for the Order Quantity Limit Method field include: None, Days Supply, and Fixed Quantity

  • Order quantity method and limit method arguments include:

    • If the Order Quantity Method field is None, then the Order Quantity Argument, Quantity Limit, Lower, and Upper Limit fields should equal zero.

    • If the Order Quantity Method field is Days Supply, and the Order Quantity Limit Method field is Days Supply, then ensure that the Order Quantity Upper Limit field value is greater than the Order Quantity Lower Limit field value.

    • If the Order Quantity Method field value is Days Supply, and the Order Quantity Limit Method field value is Fixed Quantity, then ensure that the Order Quantity Upper Limit field value is greater than the Order Quantity Lower Limit field value.

    • If the Order Quantity Method field value is Fixed Quantity, the system displays an error message when the corresponding method is blank or zero. The argument must be greater than zero.

    • If the Order Quantity Method field value is Fixed Quantity, the Order Quantity Limit Method, Order Quantity Lower Limit, and Order Quantity Upper Limit field values must equal zero.

    • If the Order Quantity Method field value is Economic Order Quantity or Lot for Lot, then the Order Quantity argument field value must equal zero.

    • If the Order Quantity Method field value is Economic Order Quantity and the Order Quantity Limit Method field value is distinct of None, then ensure that the upper limit is greater than the lower limit.

  • The Order Quantity Lower Limit field is used only when the Order Quantity Limit Method field values are Days Supply or Fixed Quantity. The target field must be numeric.

  • The Order Quantity Upper Limit field is only used when the Order Quantity Limit Method field values are Days Supply or Fixed Quantity. The target field must be numeric.

  • The Order Multiples field value can be zero or greater.

Reorder Point Policy

Reorder Point Method (Replace only)

Reorder Point Argument (Add, Divide, Move Multiply, Replace, and Subtract)

For the Reorder Point Argument field, the Source field values are:

  • Minimum Argument

  • Maximum Argument

  • Order Quantity Argument

  • Safety Stock Argument

  • Static Calculation Argument

Attributes include:

  • The Reorder Point Method field values include these operands:

    • None

    • Days Supply

    • Fixed Quantity

    • Lead Time Demand

    • Lead Time + Safety Stock

  • If the Reorder Point Method field is None, Lead Time Demand, or Lead Time + Safety Stock, then the argument must equal zero.

  • If the Reorder Point Method field is Days Supply or Fixed Quantity then the argument must be greater than zero.

Safety Stock Policy

Safety Stock Method (Replace only)

Safety Stock Argument (Add, Divide,Move Multiply, Replace, and Subtract)

Safety Stock Limit Method (Replace only)

Safety Stock Lower Limit (Add, Divide, Move Multiply, Replace, and Subtract)

Safety Stock Upper Limit (Add, Divide,Move Multiply, Replace, and Subtract)

For the Safety Stock Argument field, the Source field values are:

  • Minimum Argument

  • Maximum Argument

  • Order Quantity Argument

  • Safety Stock Argument

  • Static Calculation Argument

For the Safety Stock Lower Limit Argument field, the Source field values are:

  • Order Quantity Lower Limit Argument

  • Order Quantity Upper Limit Argument

  • Safety Stock Upper Limit

For the Safety Stock Upper Limit Argument field, values are:

  • Order Quantity Lower Limit Argument

  • Order Quantity Upper Limit Argument

  • Safety Stock Lower Limit Argument

Attributes include:

  • The Safety Stock Method field values include these operands:

    • None

    • Days Supply

    • Fixed Quantity

    • Percentage Demand Fill

    • % Cycles Without Shortage

    • Maximum Lead Time Usage

  • If the Safety Stock Method field is None, then the remaining target fields should equal zero.

  • If the Safety Stock Method field value is Days Supply or Fixed Quantity, then entries are required for the Safety Stock Lower Limit and Safety Stock Upper Limit fields if Limit Method field value is Days Supply or Fixed Quantity.

  • If you enter values for the Safety Stock Lower Limit and Safety Stock Upper Limit fields, the upper value must be greater than the lower value.

  • If the Safety Stock Method field value is None or Maximum Lead Time Usage, you must enter a zero in the Safety Stock Argument field.

  • If the Safety Stock Method is Days Supply or Fixed Quantity, then the argument must be greater than zero.

  • If the Safety Stock Method field value is Days Supply and the Safety Stock Limit Method field value is None, then you must enter a zero for the upper and lower arguments.

  • If the Safety Stock Method field value is Days Supply or Fixed Quantity, then you must enter a value greater than zero in the Safety Stock Argument field.

Standard Cost/Price

Standard Price (Add, Divide, Multiply, Replace, and Subtract)

Standard Cost (Add, Divide, Multiply, Replace,and Subtract)

Carrying Cost % (carrying cost percentage) (Add,Divide,Move Multiply, Replace,and Subtract)

Order Cost (Add, Divide, Move, Multiply, Replace, and Subtract)

For the Standard Price field, the Source field values are:

  • Order Cost

  • Standard Cost

For the Standard Cost field, the Sourcefield values are:

  • Order Cost

  • Standard Price

For the Order Cost field, the Sourcefield values are:

  • Standard Cost

  • Standard Price

None

Static Calculation Policy

Static Calculation Method (Replace only)

Static Calculation Argument (Add, Divide, Move Multiply, Replace, and Subtract)

For the Static Calculation Argument field, the Source field values are:

  • Maximum Argument

  • Minimum Argument

  • Order Quantity Argument

  • Reorder Point Argument

  • Safety Stock Argument

Attributes include:

  • Two operand values are available for the Static Calculation Method field. They are period number and periods to average.

  • The arguments for static calculation include:

    • If you select a period number or periods to average, the value of the argument must be at least one.

    • If you select a period number or periods to average, the argument cannot be greater than the maximum periods on the policy set.

User Data Fields used by the Policy Set

Character Fields (Replace Move and Blank)

Numeric Fields (Add, Divide, Move Multiply, Replace, and Subtract)

For the Numericfields, the Source field value is Other Numeric User Data Fields in use.

Attributes include:

  • For user data fields DP_UD01 through DP_UD40, you can use the Replace, Move and Blank operators.

  • For user data fields DP_UD41 through DP_UD50, you can use the Add, Multiply, Divide, Move, Replace and Subtract operators.

Click to jump to top of pageClick to jump to parent topicPages Used to Make Mass Changes to Policy Items

Page Name

Definition Name

Navigation

Usage

Mass Change

DP_IPPMMSPEC_FLT

Inventory Policy Planning, Process Policy, Mass Change Specification

Select fields to include in mass change specifications by defining specific criteria for making mass item changes. The system bases the available values on the value that you enter on the Record Selection page.

Update Operations

DP_IPPMMSPEC_OPER

Select the Update Operations tab on the Mass Change Specification page.

Define mass change specifications.

Define Update Operation

DP_IPP_MMSPEC_SEC

After selecting a mass maintenance group, click the Add button on the Update Operations page.

Define update operations for mass changes.

Mass Change

DP_IPPMASSCALC

Inventory Policy Planning, Process Policy, Mass Change

Process mass changes. Run the Item Mass Maintenance process.

Click to jump to top of pageClick to jump to parent topicSelecting Fields to Include in Mass Change Specifications

Access the Mass Change page (Inventory Policy Planning, Process Policy, Mass Change Specification).

Mass change specifications control how the system makes mass changes to inventory policy items. Within the specification, you create data subsets that are made up of records that are contained in individual fields. You create data subsets by establishing selection criteria for the field. For example, suppose that you want to limit the number of items for a specific location, you can select a range of records to limit the Item Code or Location fields.

Record selection enables you to control and filter ranges of data or types of data that are placed in the file that you want to publish.

Note. The list of available field names for selection criteria is determined by the policy set that you selected when you created the specification.

Use the Specification Description field to provide more information about the specification.

See Also

Defining Selection Criteria

Understanding Mass Changes to Policy Items

Click to jump to top of pageClick to jump to parent topicDefining Mass Change Specifications

Access the Update Operations page (Inventory Policy Planning, Process Policy, Mass Change Specification, select the Update Operations tab).

You use the Update Operations page to add and update mass maintenance group parameters for the specification. This page initially appears with no values. To define an update operation, select a mass maintenance group, and click the Add/Update button. After you define update operations, and return to the Update Operations page, you can select the Add/Update button to define additional update operations or make changes to an existing update operation.

Click the Delete button to removes all entries for the selected mass maintenance group from the Mass Maintenance Group Changes grid. The delete button is activated when you select a group from the Mass Maintenance Group field that already exists in the Mass Maintenance Group Changes grid.

Edit Operation

Click the Edit Operation button to access the Define Update Operations page where you can update existing values for operators and operands and for target and source fields.

If there are no operations available, select a mass maintenance group in the Mass Maintenance Group field, and click the Add/Update button.

Sequence

Displays a system-defined number that determines the order in which the record is processed. You cannot update the sequence, but you can sort the Sequence column.

Mass Maintenance Group

Displays a single group or multiple groups to which you want to apply to this specification. Mass maintenance groups are combinations of target fields that relate to a specific type of mass update that you might want to perform.

Target Field

Displays the field to which changes are going to be applied when you run the IPP Mass Change process.

Operator

Displays the type of action that the system performs on the source and target fields.

Operand

Displays the value that the system uses to validate the data in this field against the data type in the Target field.

Description

Displays the description of the operand when a description is available.

Source Field

Displays the field where data that you want to maintain resides. The source can be any numeric field on the DP_IPMASTER record such as arguments, volume, weight, standard cost, standard price, carrying cost, and user data fields in use or predefined values such as the Description field. The source is dependent on the operand that you select. The system validates the field type against the operator.

Mass Maintenance Group

Select a group of inventory policy fields for which you want to make changes.

See Also

Understanding Mass Changes to Policy Items

Click to jump to top of pageClick to jump to parent topicDefining Update Operations

Access the Define Update Operation page (click the Add/Update button on the Update Operations page).

Use this page to add and change update operations for a mass change specification. An update operation determines how the system processes individual fields within a mass maintenance group. Available fields on this page depend on the value you selected on the Mass Change Specification page. For example, if you select to make mass changes to the Minimum & Maximum mass maintenance group, this page displays the target fields for the minimum and maximum methods and arguments. The Operator, Operand, and Source fields also vary based on the selected group.

Information about field values available for each mass maintenance group is described in the Understanding Mass Changes to Policy Items section.

See Understanding Mass Changes to Policy Items.

Target Field

This column displays the available target fields for the selected mass operation group. The target field stores the results of the update. Target values can be any non-key field and are dependent on the operand that you select. For example, if you select a numeric operation, such as Add or Subtract, then the target field only includes numeric field types.

Operator

Displays the type of action that the system performs between the target field and the operand or source field.

Operand

Select the value that the system will use to validate data against the data type in the Target field. Operands can be numeric or available in a list of values. A description of the operand also appears after the operand if a description is available.

Source Field

Select the field from where data that you want to maintain resides. The system validates the field type against the operator.

Cancel

Click to return to the Mass Change page without saving any changes that you made on the Define Update Operation page.

Clear

Click to clear the Operand and Source Field values. This saves you from deleting individual field entries.

See Also

Understanding Mass Changes to Policy Items

Click to jump to top of pageClick to jump to parent topicProcessing Mass Changes

Access the Mass Change page (Inventory Policy Planning, Process Policy, Mass Change).

You use this page to run the IPP Mass Change process (DP_IPMASCALC ) based on parameter settings in the mass change specification. Select the policy set and the specification. An Edit Maintenance Specification link is available to facilitate changes to the specification.