Defining Item Control Values

This chapter provides an overview of item control values and discusses how to set definitions for item control values.

Understanding Item Control Values

With PeopleSoft Inventory, you can organize and group inventory items according to many different characteristics, or attributes. To set up item attributes, use the components in the Define Controls menu. When defined, these attributes become selection options and defaults on pages that are used for defining new items.

Setting Definitions for Item Control Values

To define item family routings or item group routings, use the Item Family Routing Assignment component or the Item Group Routing Assignment component.

This section discusses how to:

Define charge codes.
Assign item default values.
Assign items to item families.
Assign items to groups.
Define item numbering.
Establish item templates.
Group items in demand priority families.
Define stocking periods.
Define utilization types.
Define utilization groups.

Pages Used to Set Definitions for Item Control Values

Page Name	Object Name	Navigation	Usage
Brand Names	BRAND_NAMES_INV	Items, Define Controls, Brand Names	To associate inventory items with brand names that are valid over specific time periods, use the Brand Names (PROD_BRAND_NAME_GBL) component. Brand names that are defined on this page are informational only and are not used by PeopleSoft Inventory. Note. If you select the Item Approval Required option on the Installation Options - Overall/GL (installation options - overall/general ledger) page, items must be approved before you can assign brand names.
Charge Codes	CHARGE_CODE_INV	Items, Define Controls, Charge Codes	Define charge codes that define how items should be charged when consumed from a par location.
Grades	PRODUCT_GRADE_INV	Items, Define Controls, Grades	To define internal rating levels for items and lots, use the Grades (PRODUCT_GRADE_INV_GBL) component. The information defined on this page is used on the Define Item - General: Classifications page, the Item Templates page, and the Lot Control Information page.
Hazard/Disposal Codes	HAZARD_TYPE_INV	Items, Define Controls, Hazard/Disposal Codes	Define codes for any special handling instructions. The information that is defined in this page is used on the Item Templates page and the Define Item - General: Classifications page.
Item Attributes Group	EN_CHGOVER_GRP	Items, Define Controls, Item Attributes Group	If you use PeopleSoft Supply Planning, use the Item Attributes Group (EN_CHGOVER_GRP_GBL) component to set up attribute groups. Items that belong to specific attribute groups can be assigned to specific resources (for example, crews, machines, and tools). Note. If you are using PeopleSoft Supply Planning, you must define item attribute groups to assign resource changeover penalties on the Crews - Changeover page, the Machines - Changeover page, or the Tools - Changeover page in the PeopleSoft Manufacturing application.
Item Default Values	INV_ITEM_DEFAULTS	Items, Define Controls, Item Default Values	Define item default values to establish item attributes that are automatically assigned to each new item. All inventory items in the setID can share these attributes.
Item Families	PROD_FAMILY_INV	Items, Define Controls, Item Families	Establish item family options.
Family Rtg Assignment (family routing assignment)	EN_RTG_FAMILY	Items, Define Controls, Item Family Routing, Family Rtg Assignment	Assign items to item families by using the Item Family Routing (EN_RTG_FAMILY_GBL) component. If you are using PeopleSoft Manufacturing, you can define a routing for each item that you manufacture. To reference another item's routing, use the Define Business Unit Item - Manufacturing: General page.
Item Groups	INV_ITEM_GROUP	Items, Define Controls, Item Groups	Assign items to item groups to group similar items together.
Group Rtg Assignment (group routing assignment)	EN_RTG_GROUP	Items, Define Controls, Item Group Routing, Group Rtg Assignment	Use the Item Group Routing (EN_RTG_GROUP_GBL) component to assign items to item groups. If you are using PeopleSoft Manufacturing, you can define a routing for each item that you manufacture.
Item Number Control	ITEM_NBR_CONTROL	Items, Define Controls, Item Number Control	Define item numbering to determine whether new inventory items are sequentially numbered or manually numbered.
Item Templates	INV_ITEM_TEMPLATES	Items, Define Controls, Item Templates	Establish item templates to create various sets of item attribute defaults, which are used when defining new items.
Item Types	INV_ITEM_TYPES	Items, Define Controls, Item Types	To group inventory items by function, use the Item Types (INV_ITEM_TYPES_GBL) component. For example, you can group expense, service, or inventory items. The information that is defined on this page is used on the Define Item - General: Classifications page and the Defining Purchasing Item Categories page.
Manufacturers	MANUFACTURER	Items, Define Controls, Manufacturers Set Up Financials/Supply Chain, Product Related, Procurement Options, Purchasing, Manufacturer	Select a default universal item ID for a manufacturer, and determine whether the manufacturer is locally owned. See Using Universal Item Identifiers.
MSDS Identifiers (material safety data sheet identifiers)	MSDS_ID_INV	Items, Define Controls, MSDS Identifiers	To create IDs for items that require a material safety data sheet (MSDS), use the MSDS Identifiers (ITEM_MSDS_ID_GBL) component. PeopleSoft Inventory does not provide standard MSDS documents. Instead, you define an informational code to be used when processing items in the system. The information that is defined here is used on the Define Item - Inventory: Shipping/Handling page.
Packing Codes	PACKING_CODE_INV	Items, Define Controls, Packing Codes	To create informational codes for items that require special packing routines. The information that is defined on this page is used on the Define Item - Inventory: Shipping/Handling page, on the Define Business Unit Item - Inventory: Weight/Volume page, in the Packing Session component (PACK_EST_SHIP_GBL), and on the Item Templates page.
Demand Priority Family	PL_PRIO_FAMILY	Items, Define Controls, Demand Priority Family	Group items in demand priority families by setting up demand priority groups that you can then associate with an item.
Potency Codes	POTENCY_CODE_INV	Items, Define Controls, Potency Codes	To create informational codes to specify an item's potency, use the Potency Codes (POTENCY_CODE_INV_GBL) component. The information that is defined on this page is used on the Define Item - General: Classifications page.
Replenishment Classes	INV_REPLEN_CLASS	Items, Define Controls, Replenishment Classes	To create groupings for items that are subject to automated periodic replenishment within a business unit, use the Replenishment Classes (REPLENISH_CLASS_GBL) component. The information that is defined on this page is used on the Define Business Unit Item - Inventory: Replenishment page, the Replenishment Parameters page, and the Replenishment Options page.
Stock Types	INV_STOCK_TYPE	Items, Define Controls, Stock Types	To create ownership information codes for items that are leased or consigned, use the Stock Types (INV_STOCK_TYPE_GBL) component. A stock type must be assigned during putaway of non-owned items. The information that is defined on this page is used on the Define Item - General: Classifications page, the Item Templates page the Define Item - Inventory: Shipping/Handling page, the Manual Staging page, and the Express Putaway page.
Stocking Periods	STOCK_PERIOD_INV	Items, Define Items and Attributes, Stocking Periods	Define stocking periods by setting up time-phased safety stock and excess stock levels for PeopleSoft Supply Planning. You can also populate this page by either uploading data from a third-party forecasting system or using PeopleSoft Inventory Planning and Demand Planning.
Storage Rules	STOR_INSTRUCT_INV	Set Up Financials/Supply Chain, Product Related, Inventory, Storage Rules	To define special storage requirements for items, use the Storage Rules (STOR_INSTRUCTION_GBL) component. The information that is defined on this page is used on the Define Item - Inventory: Shipping/Handling page, the Item Templates page, and the Putaway Detail page.
Universal Item ID Types	UPN_TYPE_CD	Items, Define Controls, Universal Item ID Types	Define universal item ID types at the setID level, and determine whether the ID represents a GTIN. See Using Universal Item Identifiers.
Utilization Types	UTIL_TYPE_INV	Items, Define Controls, Utilization Types	Define utilization types define the ABC classifications to use in the environment. For example, you may decide to classify items as A, B, and C, or High, Medium, and Low. The Utilization Type Calculation process assigns utilization types to individual items by business unit and utilization group. Note. On the Perform Physical Accounting pages, utilization types are selected in alphabetical order.
Util Group Inv (utilization group - inventory)	UTIL_GROUP_INV	Items, Define Item Controls, Utilization Groups	Define utilization groups for each ABC utilization grouping that you want to maintain in the system. For example, establish utilization groups for cycle counting, planning, material handling, or performance reporting. Each utilization group can use different parameters to assign items to a specific utilization type. For example, the inventory control supervisor may consider an item to be a C item because it is a slow mover, but the purchasing department may consider that same item to be a B item because of its lead time.

Defining Charge Codes

Access the Charge Codes page.

The information that is defined on this page is used on the Define Par Location - Line page, the Consumer Usage page, and Consumer Usage Entry page. You can also capture the charge code during material usage tracking and pass it to a third-party billing system.

See Also

Managing Par Inventory

Assigning Item Default Values

To assign item default values, use the Item Defaults (ITEM_DEFAULTS_GBL) component.

Access the Item Default Values page.

Note. Modification of the item default values do not change existing item data.

Item Tracking	Select a value to define the type of stocking control that is most commonly used by items in this setID.
Lot	Select when inventory items are either produced or otherwise grouped in distinct and identifiable subsections, often referred to as lots. Lots often represent production runs. Default values for items that are not lot-controlled are defined on the Installation Options - Inventory page.
Serial	Select when each inventory item in stock is managed in units of one. Default values for items that are not serial-controlled are defined on the Installation Options - Inventory page.
Ship Serial	Select when serial tracking is required only at the time of shipment. Ship-serial items can be moved throughout the inventory business unit without serial control, which simplifies transaction processing and entry. Serial numbers are then assigned at the time of shipment to provide serial tracking on products that are shipped to customers, internal locations, and other inventory business units.
Non-Owned Item	Select if the majority of the items are maintained in inventory but not owned by the business unit.
Create Product	Select when a product ID is to be created the majority of the time. The product ID will be created when you save the Define Item component.
Item Type	Select an item type if the majority of the items will use the same value.
Costing Group	Select a cost profile group if the majority of the items will use the same value.
Category Code	Select a category code if the majority of the items will use the same value.
Cost Element	Select a cost element if the majority of the items will use the same value.
GTIN Type Code	Select a universal item ID type code to be used for entering a global trade item number within a setID. This value also determines which universal item identifier represents GTIN data when you are publishing to the UCCNet, and the GTIN to use when you are generating RFID tags..

Managing Consigned Purchases Inventory

Assigning Items to Item Families

To create item families, use the Item Families (INV_PROD_FAMILIES_GBL) component.

Access the Item Families page.

In PeopleSoft Inventory, you can categorize items by groups and families. No formal relationship exists between item groups and item families, but you can use an item family to further classify an item group. For example, you can define the hardware group as consisting of families of printers and monitors.

The information that is defined on this page is used on the Define Item - General: Common page when you are setting up cycle counting events on the Event Creation Process page, as an alternate search key for item ID, and as a selection criteria when you are running the Inventory Value report, the Cost Profiles report, the Basic Item Listing report, and the Stock Status report.

When you associate an item with a family on the Family Rtg Assignment page or with a group on the Group Rtg Assignment page, you can also associate it with a reference routing item ID. Floor stock, expensed items, and planning items, however, cannot be specified as a reference routing. When this information is defined, you can set up master routings by item family or by item group on the Define Business Unit Item - Manufacturing: General page.

See Also

Structuring Routings

Assigning Items to Groups

To create item groups, use the Item Groups (INV_ITEM_GROUPS_GBL) component.

Access the Item Groups page.

The information that is defined on this page is used on the Define Item - General: Common page as an alternate search key for item ID when you are defining transaction accounting rules and as a selection criterion when you are running the Inventory Value report, the Cost Profiles report, the Basic Item Listing report, and the Stock Status report. In manufacturing environments, item group information can also be specified on the Group Rtg Assignment page.

Defining Item Numbering

To enable automatic numbering, use the Item Number Control (INV_ITEM_CONTROL_GBL) component.

Access the Item Number Control page.

If you enable automatic numbering, you can still manually enter item IDs when adding new items. To do so, enter an item ID number and override the value of NEXT. The NEXT value tells PeopleSoft Inventory to create the item ID with the next unique sequential number.

Note. If you do not select the Auto Number Items check box, you must manually enter an ID when defining new inventory items.

Establishing Item Templates

To create item templates, use the Item Templates (ITEM_TEMPLATE_GBL) component.

Access the Item Templates page.

After entering the required information on the Define Item - General pages, you can select the template ID on the Define Item - General: Classifications page to automatically complete many of the other item attribute defaults in the rest of the component. You can override these defaults. Template modifications do not change existing item data.

Grouping Items in Demand Priority Families

Access the Demand Priority Family page.

After you define the demand priority family, you can use it to group like items for independent demand prioritization purposes. You assign the demand priority family to each item using the Define Item - General: Common page. After you assign a demand priority family to a group of items, you can set demand priorities by family priority grouping using the Demand Prioritization page in PeopleSoft Supply Planning.

Defining Stocking Periods

To create stocking periods, use the Stocking Periods (STOCK_PERIOD_GBL) component.

Access the Stocking Periods page.

Note. The information on this page supersedes any stocking level information that you enter when you set up item attributes at the business unit level.

Multiple	Displays the stock-keeping unit of measure for the item.
Start Date and End Date	Enter the dates that determine the period for which the corresponding safety stock and excess stock is established within PeopleSoft Supply Planning.
Safety	Enter the preferred level to which you want to increase stock when you pass the Safe Limit (safety stock level). For example, if stock falls below 45, then you might want to create enough supply to bring the level up to 100.
Safe Limit	Enter the lowest quantity that stock should not surpass. This is the safety stock.
Excess	Enter the preferred level to which you want to decrease stock when you pass the Ex. Limit (excess stock limit). For example, if stock goes above 10,000, you can bring it down to 7,500.
Ex. Limit (excess stock limit)	Enter the highest quantity that stock should not surpass.

Stock limits must always be equal to or less than the preferred stocking levels. In addition, safety stock levels must be less than or equal to excess stocking levels.

Note. If you use PeopleSoft Supply Planning, the quantities that you enter on this page should be in multiples of the quantity that is defined in the Order Multiple fields on the Define Business Unit Item - Planning: Order Modifiers page.

If you use PeopleSoft Demand Planning or Inventory Policy Planning, you can populate this page using a two-step process:

Create a flat file by running the Inventory Policy Export process in PeopleSoft Inventory Policy Planning.
Upload the file using the Forecast/Replenishment process in PeopleSoft Demand Planning.

If you use PeopleSoft Inventory, you can upload forecast data from a third-party forecast planning application.

Integrating With a Third-Party Forecast Planning Application

Defining Utilization Types

To create utilization types, use the Utilization Types (INV_UTILIZ_TYPES_GBL) component.

Access the Utilization Types page.

Create utilization types to define the ABC classifications to be used in the environment. Utilization types can be used to classify inventory items for numerous reasons including cycle counting, planning, material handling, or performance reporting. Utilization types that are assigned to an item ID can be viewed on the Define Business Unit Item - Inventory: Utilization Types page.

Defining Utilization Groups

To create utilization groups, use the Utilization Groups (INV_UTILIZ_GROUPS_GBL) component.

Access the Util Group Inv page.

For Cycle Count

Select to make this the default utilization group for cycle counting. Anytime that you change the default, the system updates the Counting Event Utilization Types table (COUNT_UTIL_INV).

Note. If you use the Due to Count cycle-counting method, you must define a default cycle count group; otherwise, you receive an error message on the Counting Event - Utilization Types page.

For Planning

Select to make this the default utilization group for inventory planning. You can override this default on the Define Business Unit Item - Inventory: Utilization Types page.

Build Group Items

Click to add all items that meet the criteria that is defined in the Utilization Group Details group box to this utilization group. This link adds the appropriate items to the Business Unit Item Utilization Code table (BU_ITEM_UTIL_CD). If you click the link for an existing utilization group, the system replaces all items with items that meet the criteria that is specified here.