Search Promotions by Start Date in Order Entry (M27) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Inventory Transaction History Retention Days (A24) |
Purpose: The Inventory section of the System Control table defines parameters that control:
• Physical Inventory processing
• 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 |
Defines the number of days that inventory transaction history will remain on the system before being purged. |
Number: |
|
Defines how the cost of an item is calculated. |
Code: |
|
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: |
Defines the type of warehouse locations used in a warehouse. |
Code: |
|
Defines which location types are used with the Suggest Location Placement feature. See Location Types (A28) and Suggest Location Placement (A27). |
Code: |
|
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: |
|
Defines how the system determines the size/capacity of a location. See Location Types (A28) and Suggest Location Placement (A27). |
Code: |
|
Defines the base currency code used for conversions. |
Code: |
|
Indicates if a company will fulfill orders from another company's inventory. |
Selected/ Unselected: |
|
Defines presentation of SKU fields. |
||
Defines column heading for SKU element 1. |
Code: |
|
Defines column heading for SKU element 2. |
Code: |
|
Defines column heading for SKU element 3. |
Code: |
|
Defines the order in which each SKU element will appear in Order Entry and Order Maintenance. |
Number: |
|
Displays the sequence in which a SKU must be entered for an item in Order Entry and Order Maintenance. |
Code: |
|
Defines the long description to appear for SKU element 1. |
Code: |
|
Defines the long description to appear for SKU element 2. |
Code: |
|
Defines the long description to appear for SKU element 3. |
Code: |
|
Defines which SKU element defines color when interfacing from CWSerenade to other systems. |
Number: |
|
Defines which SKU element defines size when interfacing from CWSerenade to other systems. |
Number: |
|
Defines which SKU element defines size 2 when interfacing from CWSerenade to other systems. |
Number: |
|
Defines the unit of measure that will default when creating an item. |
Code: |
|
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: |
Defines whether you will be using a ticket or worksheet entry format. |
Code: |
|
Defines the form you use to record physical inventory counts. If using system generated worksheets or tickets, refer to Assign Batch Numbers (A07) and Batch Size (A08). |
Code: |
|
Defines whether you will update inventory counts through data entry or using a store and forward device. |
Selected/ Unselected: |
|
Defines the number of physical inventories that can be pending at one time. See Cycle Counting (A06). |
Number: |
|
Defines the number of times you must enter counts before processing an update. |
Number: |
|
Indicates if you will use cycle counting for physical inventory. See Number of Outstanding Physicals (A05). |
Selected/ Unselected: |
|
Indicates if any other activity against an item location is allowed during physical inventory. |
Selected/ Unselected: |
|
Indicates if the system assigns batch numbers based on the setting of the Batch Size (A08) and Batch Grouping (L64) system control values. |
Selected/ Unselected: |
|
Defines the number of item locations or locations (based on the setting of the Batch Grouping (L64) system control value) to include in each physical inventory batch. |
Number: |
|
Defines whether Physical Inventory Generation uses location or item/location, along with batch size, to determine the number of batches in a physical inventory. |
Code: |
|
Indicates if on-hand quantity for each item will print on physical inventory sheets or tickets. |
Selected/ Unselected: |
|
Defines whether the system defaults the item and SKU for a location when you scan the location barcode for an RF physical. |
Selected/ Unselected: |
|
Defines the greatest number of units an item location count can vary from your on-hand quantity before being noted on the Physical Inventory Evaluation Report. |
Quantity: |
|
Defines the greatest cost variance an item location count can show from your on-hand quantity before being noted on the Physical Inventory Evaluation Report. |
Dollar Amount: |
|
Defines the greatest percentage an item location count can vary from your on-hand quantity before it is noted on the Physical Inventory Evaluation Report. |
Percentage: |
|
Defines the greatest cost percentage an item location count can vary from your on-hand quantity before it is noted on the Physical Inventory Evaluation Report. |
Percentage: |
|
Defines the division to be used when posting inventory transactions to the General Ledger interface. |
Code: |
|
Defines the disposition code that will default when you create a return authorization. |
Code: |
|
Indicates if the system should default the SKU into the Vendor/Item number field when generating SKUs and Vendor/ Item records. |
Selected/ Unselected: |
|
Defines the overhead percentage for fulfillment costs to be used in the calculation for profitability used on the Sales Profit Analysis Report. |
Percentage: |
|
Indicates whether multiple primary locations are allowed for inventory items. |
Code: |
|
Defines how the Net projected remaining column of the Inventory Status and Projection Report is calculated. |
Code: |
|
Not currently implemented. |
Code: |
|
Defines whether item descriptions display on inventory transaction screens. |
Selected/ Unselected: |
|
Indicates if the system will assign the item number during Item entry. |
Selected/ Unselected: |
|
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: |
Defines the percentage of the item/SKU cost to use when processing a warehouse replenishment through the outlet transfer process, if the outlet does not specify a cost. |
Percentage: |
|
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: |
Defines whether you use work order processing for finished good items. |
Selected/ Unselected: |
|
Defines the type of location the system searches first to fill the component quantity needed on the finished good work order. |
Code: |
|
Defines the type of location the system searches second to fill the component quantity needed on the finished good work order. |
Code: |
|
Defines the type of location the system searches third to fill the component quantity needed on the finished good work order. |
Code: |
|
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: |
|
Defines whether the Long SKU Division is a required field when creating or changing a Long SKU Department. |
Selected/ Unselected: |
|
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: |
|
Defines the default setting for the Gift wrap field when you create an item/offer or SKU/offer. |
Selected/ Unselected: |
|
Create Location/Item Location/Item Warehouse from PI Upload (F09) |
Defines whether you create new Location, Item Location, and Item Warehouse as a result of running the physical inventory count upload if these records do not already exist in your company. |
Selected/ Unselected: |
Defines the number of days to retain SKUs that are not on any existing order. |
Number: |
|
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: |
Defines the SKU element to use for automatic linking when creating item coordinates. |
Number: |
|
Defines whether the company code defaults at the RF return pull and put screens. |
Selected/ Unselected: |
|
Defines the shared folder where the system copies CamData Retail Point of Sale download files. |
System Name: |
|
Defines the program name the system uses to print warehouse replenishment labels. |
System Name: |
|
Display Frozen Primary Location Warning Message in Returns (F58) |
Defines whether the system displays a warning message pop-up window when you perform a return against an item whose "primary primary" location is frozen due to a physical inventory. |
Selected/ Unselected: |
Defines whether the system automatically generates item keywords from the item's description when you create an item. |
Selected/ Unselected: |
|
Defines whether the system validates the item's location class against the location's location class during inventory transaction processing. |
Selected/ Unselected: |
|
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: |
|
Defines the lead days the system uses to determine the store promotion pricing start date. |
Number: |
|
Defines the end days the system uses to determine the store promotion pricing end date. |
Number: |
|
Defines the lead days the system uses to determine the store promotion minimum/maximum override start date. |
Number: |
|
Defines the end days the system uses to determine the store promotion minimum/maximum override end date. |
Number: |
|
This value is not currently implemented. |
Selected/ Unselected: |
|
Defines the cancel reason code the system defaults to an order detail line that is automatically canceled on a restock order. |
Number: |
|
Defines the location class the system uses to determine which items are eligible for the loose pick store restock process. |
Code: |
|
Defines the order type the system defaults to store restock orders. |
Code: |
|
Default Item Status for Exclusion on Store Restock Orders (G24) |
Defines the item status the system uses to determine which items are excluded from being included on a store restock order. |
Code: |
Maximum Number of Lines to Include on Store Restock Order (I51) |
Defines the number of order detail lines the system includes on a store restock order before creating a new order. |
Number: |
Defines whether the system fulfills store restock orders from bulk locations only. |
Selected/ Unselected: |
|
Defines whether a primary location will default for an item in the warehouse specified for an inventory/receipt transaction. |
Selected/ Unselected: |
|
Defines the program to print the Replenishment Pick Worksheet for warehouse replenishment. |
System Name: |
|
Defines whether the item's primary warehouse defaults on RF screens. |
Selected/ Unselected: |
|
Defines the program name the system uses to translate CWSerenade item and SKU codes to another system's item and SKU codes. |
System Name: |
|
Defines whether the Entity field on the Create Item and Change Item screens in Work with Items is a required field. |
Selected/ Unselected: |
|
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: |
|
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: |
|
Defines whether you can use Retail Integration (external system to CWSerenade). |
Selected/ Unselected: |
|
Defines the inventory transaction code that signals a sync transaction when received through the generic inventory transaction upload. |
Code: |
|
Defines whether the SKU generator automatically creates a Long SKU style for each SKU created. |
Selected/Unselected: |
|
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: |
|
Defines which screens automatically display when you are Performing Initial Item Entry (MITM). |
||
Defines whether the system automatically advances to the Create SKU with Overrides screen when you create an item. |
Selected/ Unselected: |
|
Defines whether the system automatically advances to the Vendor Item Create screen when you create an item or SKU. |
Selected/ Unselected: |
|
Defines whether the system automatically advances to the Work with Keywords for Item screen when you create an item. |
Selected/ Unselected: |
|
Defines whether the system automatically advances to the SKU Generator screen when you create a SKU’ed item. |
Selected/ Unselected: |
|
Defines whether the system automatically advances to the Item Offer screen when you create an item. |
Selected/ Unselected: |
|
Defines whether the SKU generator automatically creates SKU Offers and single-unit SKU Price records. |
Selected/ Unselected |
|
Defines the print programs and printers used to print labels during radio frequency processing. |
||
Defines the program for printing bar-coded license plate number labels if you use radio frequency devices in your warehouse. |
System Name: |
|
Defines the printer used to print LPN labels. |
System Name: |
|
Defines the program for printing bar-coded location labels if you use radio frequency devices in your warehouse. |
System Name: |
|
Defines the printer used to print bin labels. |
System Name: |
|
Defines the program for printing bar-coded item/SKU labels if you use radio frequency devices in your warehouse. |
System Name: |
|
Defines the printer used to print item labels. |
System Name: |
|
Defines the program for printing bar-coded item labels for customer returns if you use radio frequency devices in your warehouse. |
System Name: |
|
Defines the printer used to print return labels. |
System Name: |
|
Defines the program for printing carton labels if you dock purchase orders prior to processing them with the Purchase Order Receiving function. |
System Name: |
|
Defines the printer used to print carton labels. |
System Name: |
|
Defines the type of item/SKU format to use on LPN labels if you use radio frequency devices in your warehouse. |
Code: |
|
Defines the type of barcode that is available to scan on certain RF screens. |
Code: |
|
Defines the quantity to default to RF PO Receipt Detail screen. |
Code: |
|
Defines whether the system defaults the pending putaway location to the RF PO Receipt Detail screen. |
Selected/ Unselected: |
|
Defines whether the system defaults the item’s primary primary location to the Item Put Stock Screen in RF Item Transfer. |
Selected/ Unselected: |
|
Defines whether to save a copy of the physical inventory information in the Physical Inventory Audit table when you process the update. |
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: |
Defines the quantity to default to RF Mass Transfer screen. |
Code: |
|
Defines whether the system suppresses the printing of a new RF LPN label when you process an RF LPN Transfer Pull transaction and partially pull the LPN quantity. |
Selected/ Unselected: |
|
Defines the ID of the Zebra printer you use to print additional pick control labels. |
System name: |
|
Defines whether you use item category or item class to set up slotting groups. |
Code: |
|
Defines the UPC type the system uses when creating a UPC code during item slotting. |
Code: |
|
Defines the vendor code the system uses when creating a UPC code during item slotting. |
Number: |
|
Defines the type of item barcode to scan in Work with Return By Item (WRBI). |
Code: |
|
Defines the return reason code to default in Work with Return By Item (WRBI). |
Number: |
|
Defines the type of order barcode to scan in Work with Return By Item (WRBI). |
Code: |