Setting Up Inventory Values

Purpose: The Inventory section of the System Control table defines parameters that control:

• SKU generation and presentation

• Inventory Transactions

For more information: For instructions and screen samples on how to create, change, delete, and copy a system control value, see System Control Table Components.

Quick Reference of Inventory System Control Values

This table describes briefly each system control value for the Inventory application area and lists the control value, a short definition, other control values to which you should refer in this section, if necessary, and a column where you can indicate the value that you assigned for your company.

If you are working with multiple companies, make a copy of this table for each company on your system.

Company: ______________________________

System Control Value

Description

Your Value

Inventory Transaction History Retention Days (A24)

Defines the number of days that inventory transaction history will remain on the system before being purged.

Number:

Costing Method (A25)

Defines how the cost of an item is calculated.

Code:

Suggest Warehouse Placement (C44)

Suggest Location Placement (A27)

Indicates if the system should suggest locations to store product during Suggest Warehouse/Location Placement.

Selected/

Unselected:

Type of Location to Search First during Suggest Location Placement (C40)

Defines the type of location to search first during suggest location placement.

Code:

Type of Location to Search Second during Suggest Location Placement (C41)

Defines the type of location to search second during suggest location placement.

Code:

Type of Location to Search Third during Suggest Location Placement (C42)

Defines the type of location to search third (last) during suggest location placement.

Code:

Suggest Multiple Items in a Location during Suggest Location Placement (C43)

Controls whether the system will suggest placing an item in a location already occupied by another item or will suggest only empty locations.

Selected/Unselected:

Location Types (A28)

Defines the type of warehouse locations used in a warehouse.

Code:

Random Stock Location Usage (A29)

Defines which location types are used with the Suggest Location Placement feature. See Location Types (A28) and Suggest Location Placement (A27).

Code:

Random Stock Location Assignment Sequence (A30)

Define the warehouse type that will be evaluated first when the Suggest Location Placement feature is used. See Location Types (A28) and Suggest Location Placement (A27).

Code:

Location Capacity Method (A31)

Defines how the system determines the size/capacity of a location. See Location Types (A28) and Suggest Location Placement (A27).

Code:

Local Currency Code (A55)

Defines the base currency code used for conversions.

Code:

Inventory Sharing (A69)

Indicates if a company will fulfill orders from another company's inventory.

Selected/

Unselected:

Split SKU Values (B32):

Defines presentation of SKU fields.

Split SKU Element Column Headings (A52, A53, A54)

Defines column heading for SKU element 1.

Code:

Split SKU Element Column Headings (A52, A53, A54)

Defines column heading for SKU element 2.

Code:

Split SKU Element Column Headings (A52, A53, A54)

Defines column heading for SKU element 3.

Code:

OE/OM Mapping (A42, A43, A44)

Defines the order in which each SKU element will appear in Order Entry and Order Maintenance.

Number:

Current OE/OM SKU Mapping Sequence (A14, A15, A16)

Displays the sequence in which a SKU must be entered for an item in Order Entry and Order Maintenance.

Code:

SKU Element Description 1 (G37)

Defines the long description to appear for SKU element 1.

Code:

SKU Element Description 2 (G38)

Defines the long description to appear for SKU element 2.

Code:

SKU Element Description 3 (G39)

Defines the long description to appear for SKU element 3.

Code:

SKU Element Defining Color (H21)

Defines which SKU element defines color when interfacing from Order Management System to other systems.

Number:

SKU Element Defining Size (H22)

Defines which SKU element defines size when interfacing from Order Management System to other systems.

Number:

SKU Element Defining Size 2 (H23)

Defines which SKU element defines size 2 when interfacing from Order Management System to other systems.

Number:

Default Item Unit of Measure (B33)

Defines the unit of measure that will default when creating an item.

Code:

Default Primary Location (C05)

Indicates if the primary location for an item should default during Inventory Transactions.

Selected/

Unselected:

Default Primary Location - Suspense Placement and PO Receipts (C08)

Indicates if the primary location for an item should default during PO Receipts or Suspense Placement.

Selected/

Unselected:

Default Disposition Code (C18)

Defines the disposition code that will default when you create a return authorization.

Code:

Default SKU Generator Vendor Item (C61)

Indicates if the system should default the SKU into the Vendor/Item number field when generating SKUs and Vendor/ Item records.

Selected/

Unselected:

Allow Multiple Primary Item Locations (D12)

Defines the overhead percentage for fulfillment costs to be used in the calculation for profitability used on the Sales Profit Analysis Report.

Percentage:

Allow Multiple Primary Item Locations (D12)

Indicates whether multiple primary locations are allowed for inventory items.

Code:

Display Item Description (D45)

Defines whether item descriptions display on inventory transaction screens.

Selected/

Unselected:

Auto Assign Item # (D46)

Indicates if the system will assign the item number during Item entry.

Selected/

Unselected:

Default Soldout Control Code (D72)

Defines a soldout control code to default when you create items and SKUs.

Code:

Default Soldout Control Code for Item to Item Transactions (D94)

Defines a soldout control code to default when you sell out an item because of an item to item transfer.

Code:

Create Item Transaction History for Non-Inventory Items (E39)

Defines whether the system writes an issue (I) type transaction history record when non-inventory and drop ship items go through billing.

Selected/

Unselected:

Work Order Values (E41):

Use Work Order Processing (E37)

Defines whether you use work order processing for finished good items.

Selected/

Unselected:

First Location Type (E42)

Defines the type of location the system searches first to fill the component quantity needed on the finished good work order.

Code:

Second Location Type (E43)

Defines the type of location the system searches second to fill the component quantity needed on the finished good work order.

Code:

Third Location Type (E44)

Defines the type of location the system searches third to fill the component quantity needed on the finished good work order.

Code:

Sold Out Retention Method (E63)

Defines whether the system holds open the oldest (FIFO) or newest (LIFO) open order lines when you process auto soldouts if you elect to retain a quantity of the item from selling out.

Code:

Require Long SKU Division with Long SKU Department (E85)

Defines whether the Long SKU Division is a required field when creating or changing a Long SKU Department.

Selected/

Unselected:

Require Item Class in Work with Items (F06)

Defines whether the Item class field is a required field on the Create Item and Change Item screens in Work with Item/SKUs.

Selected/

Unselected:

Gift Wrap Default (F07)

Defines the default setting for the Gift wrap field when you create an item/offer or SKU/offer.

Selected/

Unselected:

SKU Purge Days (F11)

Defines the number of days to retain SKUs that are not on any existing order.

Number:

Require Sort Sequence Number in the SKU File (F23)

Defines whether the Sort sequence number field on the Create SKU and Change SKU screens in Work with Item/SKUs is a required field.

Selected/

Unselected:

Auto Assign Sort Sequence Number During SKU Generation (F24)

Defines whether the system automatically assigns a SKU sort sequence number to each SKU created in the SKU Generator.

Selected/

Unselected:

SKU Element for Auto Linking Coordinates (F39)

Defines the SKU element to use for automatic linking when creating item coordinates.

Number:

Warehouse Replenishment Label Program (F57)

Not currently implemented.

System Name:

Auto-Generate Item Keywords from Description (F79)

Defines whether the system automatically generates item keywords from the item's description when you create an item.

Selected/

Unselected:

Allow Location Class Edit in Inventory Transaction (F86)

Defines whether the system validates the item's location class against the location's location class during inventory transaction processing.

Selected/

Unselected:

Use Store File (G15)

Defines whether the system advances you to the Store screens when you are working with a warehouse that represents a retail store in Work with Warehouses.

Selected/

Unselected:

Default Primary Location from an Item Warehouse (G06)

Defines whether a primary location will default for an item in the warehouse specified for an inventory/receipt transaction.

Selected/

Unselected:

Warehouse Replenishment Pick Worksheet Print Program (G25)

Not currently implemented.

System Name:

Item Number Cross Reference Program (G40)

Defines the program name the system uses to translate Order Management System item and SKU codes to another system's item and SKU codes.

System Name:

Require Entity in Item File (G44)

Defines whether the Entity field on the Create Item and Change Item screens in Work with Items is a required field.

Selected/

Unselected:

Display "No Primary Location" Message in Returns (G46)

Defines whether the system displays a warning message pop-up window when you perform a return against an item which has no primary location.

Selected/

Unselected:

Pending Putaway Due Date Days (G92)

Defines the number of days to add to the transaction date when calculating a pending putaway due date for inventory that is not associated with a purchase order.

Number:

Use Retail Integration (H26)

Defines whether you can use Retail Integration (external system to Order Management System).

Selected/

Unselected:

Inventory Transaction Code for ’Sync’ Processing (I85)

Defines the inventory transaction code that signals a sync transaction when received through the generic inventory transaction upload.

Code:

Default SKU Generator L/S Style (J04)

Defines whether the SKU generator automatically creates a Long SKU style for each SKU created.

Selected/Unselected:

Default Active Offers (J07)

Defines whether the system defaults the most recent active offers for the specified item to the selection screen in Update SKU Offers (MUSO) and Update SKU Offer Prices (MUSK).

Selected/Unselected:

Item Creation Values (J08)

Defines which screens automatically display when you are Performing Initial Item Entry (MITM).

Auto Advance to SKU Create (B34)

Defines whether the system automatically advances to the Create SKU with Overrides screen when you create an item.

Selected/

Unselected:

Auto Advance to Vendor Item Create (E78)

Defines whether the system automatically advances to the Vendor Item Create screen when you create an item or SKU.

Selected/

Unselected:

Create Keywords at Item Entry (F78)

Defines whether the system automatically advances to the Work with Keywords for Item screen when you create an item.

Selected/

Unselected:

Auto Advance to SKU Generator (J06)

Defines whether the system automatically advances to the SKU Generator screen when you create a SKU’ed item.

Selected/

Unselected:

Auto Advance to Item Offer (J05)

Defines whether the system automatically advances to the Item Offer screen when you create an item.

Selected/

Unselected:

Automatically Create SKU Offers (J71)

Defines whether the SKU generator automatically creates SKU Offers and single-unit SKU Price records.

Selected/

Unselected

Item Status for Suppressing Item During Item Selection (L21)

Defines the item status code that prevents the Item Selection screen from listing the item.

Code:

IN03_03 OROMS 17.0 2018 OTN