This chapter provides an overview of inventory policy items, lists common elements, and discusses how to:
Define policy items.
Populate inventory policies with PeopleSoft Inventory data.
Refresh policies with PeopleSoft Inventory data.
Delete policy items.
Make mass changes to 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:
Run the Generate Policy routine by using the Transfer Forecasts option and selecting the publish name and forecast publish date for your published forecast.
Create the forecast.
Assign items to the forecast, and generate and publish the forecast.
Create policy sets, linking the set to a map ID by using the Define Policy Sets page.
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.
Populate PeopleSoft Inventory Policy Planning with data from PeopleSoft Inventory.
Generate the inventory policy.
Publish inventory policies by:
Publishing static policy data to PeopleSoft Inventory.
Publishing time-phased stock period data to PeopleSoft SCM.
Exporting policy data to external systems.
This diagram summarizes the elements and system flow for using item master policies in PeopleSoft Inventory Policy Planning with a published forecast:
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. |
To define policy items, use the IP Master component.
This section provides an overview of policy item creation and discusses how to:
Define basic information for policy items.
Define order quantity and safety-stock policies.
Define reorder point and minimum and maximum policies.
Set up price and costs.
Define other data for policy items.
Assign user fields to policy items.
Use these methods to create policy item master records:
Manually create the item for simulation purposes or set it up before extracting PeopleSoft Inventory data.
Create the item when transferring forecast information from Oracle Demantra Demand Management.
Select the Create Missing IP Master check box when you generate a policy. The system uses the Uses Inventory check box on the Policy Sets page to determine how to use default information to create the items and when it should create items.
Populate policy items from PeopleSoft Inventory.
For policy sets that have the Uses Inventory check box selected, the Populate feature enables you to create items and update them from the PeopleSoft Inventory master data.
Import from external systems.
Create an item import specification to import policy master data from an external inventory system. This enables you to determine what data is updated and if and when the system creates items.
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.
Page Name |
Definition Name |
Navigation |
Usage |
DP_IPMASTER |
Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Define Policy Items |
Define basic information for policy items. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
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. |
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. |
|
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. |
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:
|
|
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.
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:
|
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:
|
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:
|
Limits |
Select a limits method. The system uses this parameter to place upper and lower limits on the safety-stock quantity. Values are:
|
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. |
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:
|
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:
|
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.
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. |
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.
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:
|
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. |
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. |
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. |
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
Page Name |
Definition Name |
Navigation |
Usage |
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. |
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.
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.
Page Name |
Definition Name |
Navigation |
Usage |
DP_IPREFRESH |
Inventory Policy Planning, Define Policy Elements, Inventory Policy Items, Refresh from Inventory |
Refresh policies with PeopleSoft Inventory data. |
|
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. |
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.
This section describes how to delete policy items.
Page Name |
Definition Name |
Navigation |
Usage |
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. |
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:
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.
Review the items and locations in the list.
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.
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.
This section provides an overview of mass changes to policy items and discusses how to:
Select fields to include in mass change specifications.
Define mass change specification.
Define update operations.
Process mass changes.
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:
Create a specification to use for the fields to which you want to make changes for policy items.
Select mass maintenance groups to be included in the specification.
Define how you want the system to apply changes to target fields.
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:
|
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:
|
Attributes include:
|
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:
|
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:
For the Order Quantity Lower Limit field, the Source field values are:
For the Order Quantity Upper Limitfield, the Source field values are:
|
Attributes include:
|
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:
|
Attributes include:
|
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:
For the Safety Stock Lower Limit Argument field, the Source field values are:
For the Safety Stock Upper Limit Argument field, values are:
|
Attributes include:
|
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:
For the Standard Cost field, the Sourcefield values are:
For the Order Cost field, the Sourcefield values are:
|
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:
|
Attributes include:
|
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:
|
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. |
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
Understanding Mass Changes to Policy Items
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.
|
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
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
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.