Setting

Description/Instructions

Item Number

In the Dancik system item numbers consist of three parts.

• The first three characters are the manufacturer code.

• The second set of characters represents the color of the item. To make searching by color easier, we recommend you enter the actual color instead of the manufacturer’s designation. For example, if a manufacturer calls an item “snow” that is actually white, the color name should be “white.” If color is not important or applicable to an item, you can use this field for another category such as style, texture, type, or finish. For example, tools can be categorized by type, such as trowel or saw.

• The third set of characters in the item number represents the pattern.

The key to creating and then finding item numbers easily is consistency.

Color

Description

Color Description is a required field and should be used to help you search for items, rather than for organizing inventory. For this information to be useful to the customer service personnel, color names should be somewhat general and used consistently. For example, use “white” for the various shades of white, so that customer service can quickly search for inventory with that color name without having to search for every shade of white.

For items with a color name of MISC, ignore the setting to always fill in the O/E UM. Miscellaneous items must have a blank in this field to work in some settings. For example, when you enter a miscellaneous item code in order entry, you might want to order the item in any unit of measure.

Description 1 & 2

The name of the item consisting of up to two lines of 30 characters each. Names should be entered in a consistent manner. We recommend the following format: Enter the product line or series name followed by the color and pattern. For example:

• Tuscany Bone 6x6 where Tuscany is the product line, bone is the color, and 6x6 is the pattern.

• Superhold Regular 20 LB, where Superhold is the product line, regular is the type, and 20 LB is the pattern or size.

We recommend that you only use the second line of the name when absolutely necessary. Leaving the second name line blank allows twice the number of items to display on many screens, documents, and reports.

Usual Supplier

The three-character code of the usual supplier of this item. This supplier is used when special orders are processed and when automatically generating purchase orders from the Item Reorder Reports program. You can override this supplier number on purchase orders. Any item number can be ordered from any applicable supplier number. Using the Cost File, you can define multiple suppliers for a single item.

Suppliers’ Item#

The item number as defined by the supplier, if different from the item number you have established. This item number appears on all purchase orders to your supplier for this item. You can search by the supplier’s item number using the Item Search function.

Price Class

Enter the price class of the item if the item is part of a price class that has already been set up in the Price File.

The system protects you from inadvertently changing the unit of measure for an active item by changing it to another price or cost class with a different unit of measure.

Changing the unit of measure for an item that is active—having any open orders, purchase orders or inventory—causes many problems, as all transactions and statistics are assumed to be in the items’ native unit of measure. In order to further protect the integrity of statistics, we recommend that you create a new item number, rather than changing the unit of measure, unless the item has not been used significantly.

Cost Class

The cost class of the item if the item is part of a cost class that has been set up in the Cost File.

Package Class Code

Enter the packaging class of the item if the item is part of a packaging class that has been set up in the Packaging File.

Product Line

The three-character code of the product line to which this item belongs. Product lines must first be set up in the Product Line File.

Item Class 1, 2 and 3

You have up to three Class fields in which to classify the item.

Item Class 1 is the most general of the three item classes. It is also the most important because it is used in the pricing and salesperson assignment programs. Price lists and promotional pricing can be assigned to a customer for specific item Class 1 entries. A customer can also be assigned multiple salespeople based upon Item Class 1. Following are examples of Item Class 1 codes.

• AC - Accessories

• CC - Commercial carpet

• CR - Residential carpet

Note:   Define and set up your Item Class codes in the Classification Codes File.

Item Class 2 codes can be used to further classify and item. This should be a more specific classification than Item Class 1.

Use Item Class 3 only if other meaningful classification is needed for your entries in the Item Class 1 and 2 fields.

Trim Class

User-defined two-character code. If the item is a trim piece, enter a code to identify the class of trim piece. If you do not categorize trim, enter TR if the item is a trim piece. For ceramic tile, you can use codes such as BN for bullnose and AN for angles. For wood, you can assign trim classes for items such as reducer strips and stair nosings. Trim class can also be used to identify items that are not core items, but support the sales of core items. Many reports allow you to omit trim or analyze it separately. You can consider samples as trim.

Wear Code

This is not a required field. However, you can use the rating code used to help identify items sales ranking or it can be completed later by the system. Commodity level can be helpful in sales analysis.

Use industry standard codes when possible, such as 1, 2, or 3. Otherwise, assign codes that indicate whether the product is suited for uses such as residential, commercial, or industrial.

ABC Rating

You can use this field to rank and classify products for integration with reorder and ranking reports. You should use it to classify items from best (A) to worst (D).

Use code S to identify support items, which are items that support the sales of other (hopefully A rated) items. Support items need special reorder parameters, because their sales statistics often do not justify their stocking requirements. Also, consider using N for new items. New items need special considerations until sales patterns are established. ABC codes are created through the ABC Code File.

Commodity Level

A user-defined, one-character code describing an item’s the level of relative value. Establish a code for each commodity level, such as H for high-level or luxury items, M for medium-level items, and L for low-value or commodity items. You should establish all commodity level codes in the Classification Codes File. All strategic management statistics are available by commodity level.

Days before Old

The number of days after receipt of this item. This field is used in the Inventory Search and Stock Selection programs.

Remnant Size

Determines whether a remaining quantity of a shade, lot number, or roll is too small to be counted as saleable. For example, if you entered 12 and the item unit of measure is in square feet, the system considers any quantity equal to or below 12 square feet in a single serial or lot number to be obsolete or a remnant. For rolled goods, this field is always entered in inches. This field is most applicable to serial numbered or rolled good items.

Cost Center

Use this field to categorize the item. It is required if you want a direct interface with the General Ledger system. It should represent the major divisions of products and services in your company, such as ceramic tile vs. vinyl or wood. Cost centers are then further subdivided by your item class entries.

Note:  Cost centers are defined using the Cost Center File.

Freight Class

Use this field to classify items for bills of lading. It is used to scan bar coded labels as shipments are loaded. Data collected at the point of shipment is used to produce bills of lading, when applicable. This field is also used if you download shipping data into an automated truck loading, shipping, or freight system. Freight class codes must first be set up in the Classification Codes File.

Taxable

The tax codes that are available are:

• Y - Taxable (for information only - does not override order tax codes). This field defaults to Y indicating that the product is taxable.

• N - Non Taxable (for information only - does not override order tax codes). When setting up item numbers for charges, such as delivery charges, enter N in this field if they are not taxable.

• A - Always Tax (Overrides order tax codes if order has no tax code). You can enter A if you want the system to always tax this item, even for normally tax-exempt customers. You can use this code for items such as samples, that can be automatically taxed, even if the customer is usually non-taxable. If these items have A in this field, the system automatically taxes just those items on otherwise non-taxable orders and invoices. This item-level taxation is supported throughout the entire system, from Order Entry screens, to COD Picking and Packing Lists, and Invoices. These taxes are reflected on the Sales Tax Reports, and are included in the interfaces to General Ledger.

• E - Tax Exempt (causes specific line items to be tax exempt, even if the order has tax codes). This option is for products and services that are not taxable. This tax code overrides an order’s tax codes.

This option affects all the programs that calculate tax including:

—  Order Entry and Order Change

—  All cash register screens

—  Order Acknowledgements

—  Pick Lists (if they show a total due)

—  Order Inquiry

—  Invoices

—  Totals that appear on the Retail File History screen

Tax Exempt items appear with an (*) asterisk in front of them on order acknowledgements. The tax code for customer or order still determines whether or not each invoice is taxed.

Smallest Pick UM

Enter the smallest unit of measure in which the item can be picked. The default smallest unit of measure is PC (piece). For ceramic mosaics, enter SH if sheet is the smallest unit of measure in which the item can be picked. For rolled goods, you can leave this field blank. The system automatically converts rolled goods to lineal feet. Picking lists (except for rolled goods) break the quantity ordered into cartons and pieces unless something other than PC is entered here.

Note that for all goods that are sold or packaged in cartons, this field should represent the unit of measure contained within the carton, even if you never break cartons.

Smallest Sales UM

Enter the smallest unit of measure in which the item should be sold. Your entry here will cause the Order Entry program to suggest order quantities that equal an unbroken multiple of this unit of measure. For example, entering CT (carton) in this field causes the system to check that the quantity ordered for this item does not break a carton. If it does break a carton, the system suggests a lower quantity and a higher quantity, each representing the nearest full carton. You may also enter the policy code NB (no breaks) in one of the three policy fields, which are described above. Policy NB enforces the smallest sales unit of measure. If CT is entered and a quantity ordered breaks a carton, the system will change the quantity to the next full carton quantity. It will also alert the operator that the quantity was changed and that there is a “no broken units” policy. This field can be used for many units of measure. For example, enter PC if a quantity ordered should not include a fraction of a piece. Enter SH or ST if sheets or strips are not to be broken. We recommend that an entry is made in this field for all items, except rolled goods, unless fractions of any unit of measure are acceptable.

Smallest Supplier UM

Used for EDI transmissions to a supplier and for receiving and reorder reports. This is the U/M to which the EDI transmission will convert and use. If this field is left blank, the system uses the unit of measure found on the transaction to be transmitted. The Reorder Reports also have an option to print quantities in the supplier’s unit of measure. If you enter a unit of measure in this field that is different from the item’s native unit of measure, you must ensure the Packaging or Item Files includes a valid conversion factor. On the receiving screens, various quantity fields are shown in the supplier’s unit of measure as well as in the native unit of measure.

Order Entry UM

Must contain zeros or an item’s native unit of measure, and should not be left blank. Complete this field if you want the Order Entry program to always convert quantities and price in this unit of measure. For example, if you enter SF in this field and then enter 2 CT in Order Entry, the system converts the quantity to SF and displays price per SF. If you leave this field blank, the Order Entry program continues to accept any unit of measure and prices the sale in that unit of measure.

Miscellaneous items (items with a color number of MISC) ignore this setting. Miscellaneous items must have a blank in this field to work in some settings. For example, when you enter a miscellaneous item code in order entry, you may want to order the item in any unit of measure.

This field can be controlled by a setting within the System Wide Setting - Options for Order Entry U/M in Item File. We recommend all items, except MISC items, contain an Order Entry UM.

Qty Break Group

Represents a group of items that are accumulated for quantity breaks on pricing. You can use quantity break group pricing to group products in order to achieve a quantity break based on a combined total quantity instead of each line item quantity. The option to activate this feature is in the Quantity Break Group Option field under the Order /Invoice Printing tab in the Company Settings File. The options in the Company Settings File include:

• O - Quantity breaks are only accumulated for items on the same order num­ber.

• S - Quantity breaks are accumulated for items with the same ship date, same customer, or same invoice run.

• C - Quantity breaks are accumulated for items for the same customer and same invoice run.

Any other entry does not activate quantity break group pricing. Once activated, quantity break group pricing is automatically performed during Batch Invoice Processing. It does not occur during the Order Entry process.

Note: Quantity break group codes are set up in the Classification Codes File.

Qty Break Multiplier

A numeric field that is only entered if a quantity break group code has been entered for this item. This field tells the system how many units to contribute to the total quantity break for every native unit sold. A native unit is the unit of measure used for sales analysis and pricing. For example:

• Item 1 is sold by QT (quarts) and has a multiplier of 1.

• Item 2 is sold by GL (gallons) and has a multiplier of 4.

These two items are included in the same quantity break group, but their native units of measure are different. Therefore, the Multiplier field is used to achieve a common unit conversion for both items. In this example, the quantity break is in total quarts. Item 2 requires a multiplier of 4, so that every gallon counts as 2 units toward the total price break. If both items have the same unit of measure, you would probably enter a multiplier of 1 for both. However, you do not have to base the multiplier on an actual unit of measure conversion. You could say that buying in gallon containers is more cost-effective, and therefore use a multiplier of 5. This does not mean that one gallon equals five quarts. It means that one gallon counts as five quarts toward the quantity break. Multiplier is meant to achieve a marketing objective, and not to be an accurate conversion factor.

Operator Initials

Your initials, entered when you finish updating or adding the record.

Sub-Serial

Indicates if and how the item uses the sub-serial number feature. Sub-serial numbers are used for items for which each piece or unit needs to be tracked separately. This field is for appliances and power tools having unique serial numbers on each unit, and adds another level to the inventory hierarchy. Sub-serial numbers are tracked within regular serial numbers or locations. They are not displayed or selected within the order entry process. They are optionally scanned or entered into the system during receiving, or as the products are shipped.

• Blank - (default) the item does not use the sub-serial number feature.

• A - used to track sub-serial numbers through the entire Dancik Distribution System. Sub-serial numbers are captured upon receipt of an item, recorded as the item is moved in the warehouse, and recorded when the item ships.

• I - the sub-serial number is recorded only when the item ships.

• L - sub serial concept is used only when labels are generated.

Comments

Enter any important comments you have for this item. These comments appear along with the item description on the Order Entry and Invoicing screens when the item is ordered or sold. If you enter an asterisk (*) in front of the first character in the comment, the comment flashes on the Order Entry, Inventory Inquiry, and Quick Quoter screens.

Last Changed

You cannot edit this field. The date on which the last changes were made to this record. This date is maintained automatically by the system. It is updated with today’s date whenever the Item File record is updated in the File Maintenance or the Mass Update programs.

Inventory Code

A required field that denotes whether the inventory is stocked, not stocked, or special ordered. Enter:

• Y - for stocked items.

• N - items that are not stocked.

• S - if the item is not stocked and is a mandatory special order item. A mandatory special order item automatically generates a purchase order to the supplier, when entered via the Order Entry System.

You should use the special order code in specific cases, and not for inventory you do not stock in your warehouse.

You can generate a special order to a supplier even if you enter Y or N. Enter S only when you want a special order to be mandatory every time the item is entered on a customer order. Make sure that you are familiar with how the special order system functions before setting this field to S for any items.

Inventory Cross Reference #

Used to cross-reference one or more item numbers to another item’s inventory. Used primarily for private labeling programs in which multiple item numbers have the same physical inventory.

Component

The component code denotes whether the inventory is a type such as serial, or rolled goods. If you plan to use ISO tables for different types of products, enter the ISO rule table number. The system uses the ISO rule table number system when this item is entered on an order.

• B - If the item is a component, for example part of a kit, and also has compo­nents within it. (B - both)

• D - If you want the color number to automatically duplicate in Order Entry. Use this code for items usually sold in many designs or patterns with the same color number. When entering orders, the Mfgr code remains on the screen after entering an item. If you use this code, the color also remains on the screen and is valid only for non-serialized items. Policy CD also acti­vates this function for serial and non-serialized items.

• F - Fund only item; used solely for billing and crediting fund accounts. These are not actual products.

• K - The item is a kit. This code activates the kit function.

• N - (or leave blank) if the item has no components and is not a rolled good or serial numbered item.

• R - The item is stocked in rolls, such as carpet or vinyl. Do not use this code for pad or cushion that is generally not cut, but use S or N these items. This code performs all of the functions of the S code with additional functions for roll goods. When you enter R, the system prompts you to enter the width of the product in inches, so that the system can automatically convert to the appropriate unit of measure, such as square yards or feet.

• S - The item is stocked by serial number, such as for special lots, shades, and large tools. The serial number function does not necessarily mean that an actual serial number is required. You can use the serial number feature to categorize inventory and track it by information such as shade, dye lot, and bin location.

• Y - The item is a component of another item or part of a kit that cannot be sold on its own.

• L - Labor & Expense items enable you to set up catalogs of non-inventory items, such as service, installation, and labor items. These items automati­cally bypass inventory in all functions and modules. The system treats an “L” coded item similar to an “F” (Fund) item, which is mainly that all inven­tory files are bypassed.

A typical “L” item is “Labor To Install Carpet” at $1.99 SF or “UPS Sample Charge”. These items are used like any other item - in Order Entry, ISO, and Bills Of Material, except that all inventory files & updates are bypassed. Companies that use these “L” items may also set up a special Cost Center (or multiple special cost centers), so that the GL Interfaces can differentiate between inventory items and Labor/Expense items.

ISO Table

The one-character entry relating this item to an ISO (Inventory Selection Optimizer) table, which includes instructions about how inventory should be processed for this item.

For more information refer to ISO.

Pattern Name

Enter the pattern name of the item. You should standardize pattern names to make searching easier. Following are suggested pattern names:

• 4X4 - 4 1/4” (for tile)

• 6X6 - 6" x 6" (for tile)

• 6X6OCT - 6" x 6" Octagon

• A3401 - tile trim

• SM4449  - tile trim

• Berber - (for carpet)

We strongly recommend that you use a consistent system for color and pattern name fields. You can use the item search function to search by color or pattern or both. So, for example, you can find products by entering Blue 4 x 4, White Berber, or Thinset 20LB.

Discontinue Date

The date on which the item is discontinued or the date your supplier stops carrying the item. Items with a date entered here appear on the Discontinued Items List.

If you enter a past date, including today, the item appears in reverse image. If the item is out of stock, on order, or allocated, the Order Entry system does not allow further orders.

When the item has been discontinued for more than one year and is out of stock on-hand, on order, or allocated, the item drops off the inventory screens entirely, unless the Item Master or Stock Card Screen is specifically requested.

If you enter a future date, the item appears in reverse image on Inventory Search until that date is reached. The item can be ordered or sold as usual.

If you are discontinuing an item, but still have some in stock, enter DI in one of the Policy fields. DI indicates the item has been discontinued, but can you can still take orders for it. When you deplete your stock, you can enter the date on which the item was discontinued in this field. You can also enter a future discontinue date at any time, which indicates that no purchase orders or back orders for this item are allowed after that date.

Replenishment Path

The replenishment path indicates the method in which the item is reordered.

• V - Vendor managed. The vendor makes all replenishment decisions. This field does not affect any system processes, except for EDI or file transfer processes specifically arranged between you and your suppliers.

• M - Mixed managed. Your company and the vendor jointly manage replen­ishment.

• Blank - Normal replenishment, completely managed by your company.

Policies

Three two-character fields, which can be both system and user-defined. A policy code is used to trigger special processing or to identify special items. A policy code can be entered in any of the three policy fields, in any order. If you want to create user-defined policy codes, we recommend that you use only numeric codes from 01 - 99. This method prevents possible conflicts with system-defined policy codes, which are alphabetic and contain at least one alpha character. Many item and inventory reports allow the use of policy codes as selection criteria.

Note: Item policy codes are created and maintained via the System Table - ITEMPOLICY accessible via menu option SET 29.

Following is an explanation of the system-defined policy codes:

• A# - Area Rug Item unique dimensions and price - The A# item code repre­sents area rugs. It is one of the keys that activates the serial number unique dimension functionality.

• CD - Do not skip lines on invoices and order acknowledgements. Items with this policy and the same manufacturer and color number print on documents without skipping lines between them. This lets you group items and save paper. You can use this code for items that are usually sold with multiple matching trim pieces or for items that are sold together in design sets. Use this code if you want the Order Entry program to leave the color number portion of the item number on the screen after an item with the CD policy is entered.

• DI - To be discontinued. The item appears on the Discontinued Items List.

• DV - For quantity break groups, divide by the multiplier instead of multiply­ing. For example, if the item has a native unit of measure of QT, and is counted toward quantity breaks figured in gallons, use this policy and multi­plier 4. This means each QT will be converted as 1/4 gallons toward the quantity break. You should construct quantity breaks using the lowest com­mon denominator approach, so you never need to divide. However, you might need this code when adding new types of items to an existing quantity break group.

• LC - This policy code directs the system to use the SKU base cost on purchase orders, direct ship orders, and special orders. This policy:

• Provides an auto-updating method to keep up with fluctuating prices.

• Provides an alternative method to having to manually update the Item File costs when a new price list is received.

• MI - Manufactured internally. Use this code to identify your own products if your company is a manufacturer that sells goods from both company plants and outside vendors.

• MS - Mandatory lot number. The item must be received and sold by lot number. The Order Entry and Receiving programs prompt users to specify the lot number. Do not use this code for serialized items or rolled goods. This code activates the use of the lot number field, which is different from the serial number field.

• NB - No broken units. A unit of measure is entered in the Smallest Sales U/M field for this item. The system only accepts orders that do not break that unit of measure. For example, if the Smallest Sales U/M field contains CT, the NB policy will not allow an order that causes a carton to be broken.

The NB policy code is controlled by the system wide setting Item Policy NB Options (Control the NB Quantities Policy).

• NF - No fund contributions. Exempts items from getting overbills or points regardless of the type of promotion or customer. Enter this policy code in any of the three policy fields to activate the policy. Consider using this pol­icy on item records used for samples or services such as freight charges.

• NR - No rebates or cost allowances. Causes the system to bypass all Promotional File rebates or cost allowances for the item, while still allowing pro­motional prices to be used. Use this policy for items that have dropped or devalued in inventory. This policy prevents you from erroneously claiming rebates on dropped items that might belong to a price class or product line whose other (non-dropped) items are entitled to a rebate. For example, a price class contains ten item numbers, and a promotion includes a rebate entered for the price class. Then, one item number is discontinued and the manufacturer gives you a credit memo against your stock in the item, and will no longer honor rebates when it is sold.

• OV - Outside vendor item. Use this code if your company is a manufacturer, and you want to label items that are not produced internally.

• G# - This policy code identifies an item as being plastic laminate, or another form of solid surface sheet goods that requires a “grid” screen on Order Entry. This policy can only be entered in the first Policy Code field.

The System Wide setting Laminate Automatic cut settings and additional options has additional information concerning laminate items.

• P# - Slab item. This policy activates system functions that manage the unique properties of marble and natural stone slabs. This code ensures that the slabs are entered with width and length in inches, and sold by the slab.

• PU - This powerful policy code identifies that an item’s picking unit of measure is the preferred default unit of measure instead of the native unit of measure. This policy alters the default unit of measure on many input screens, from native to pick unit of measure, and causes many inquiry screens to convert quantities to the pick unit of measure. This policy makes management easier for certain types of products that are priced and analyzed in an area or volume unit of measure, such as SF or GL, yet always sold and handled by the piece or each (PC or EA). Products that you might want to consider for policy PU are:

—   counter top or solid surface materials

—   setting materials and chemicals that are priced by a volume unit that is inconsistent with how they are sold and handled. For example, a five gallon drum that is only sold as a full unit, yet priced by the gallon.

• RD - Request Description; triggers a message screen to automatically dis­play during order entry. This allows additional comments to be entered for specific items as needed. You can apply policy RD to any item where item specific instructions are needed at the time of order entry. Typically, this feature is designed for special order items.

• RI - Restricted item; the item is sold on an exclusive basis. This policy does not cause the system to take any action, but it can be used to fine-tune promotions that apply only to restricted items. For example, if you need to lock out all but the authorized customers of a restricted item, follow these steps:

—   Enter policy code RI in the Item File of the restricted items. You can use the Item File Maintenance Program or Item File Mass Update program to do this.

—   Create a marketing program or display type that represents the group of customers who are authorized to purchase the restricted item. Use the Classification Codes File to create the marketing program. Assign the new marketing program or display type code to the authorized customers.

—   Create a lock out promotion in the Promotion File to keep unauthorized customers from purchasing the items that have policy code RI. The promotion must be coded as type F (a fixed promotion), with a price of $99999.99 (which means lock out), and assigned to OMIT the designated marketing program or display type. This means the lock out applies to everyone except the customers assigned to that marketing program or display type.

The promotion can be entered against a broad category, such as item class or manufacturer, as well as against narrow categories, such as price class or product line. The important thing is to limit the promotion to policy code RI in the Limit to Policy field, of the Promotion File. This technique is the most efficient way of locking out all unauthorized customers from a defined list of items. If you are simply locking customers out of a single manufac­turer or product line, you can point the promotion to that manufacturer or product line, without the use of policy codes.

• RO - Remaining balances only. This policy affects serial numbered items on Order Entry. All items using the RO policy force the order entry operator to take the remaining balances of any serial numbers or rolls. For example, if a serial number has 50 square feet available, you must be certain items from many product lines and manufacturers order all 50 square feet, or none at all.

• S1 - Cut/Binding Items. Area rug cut and binding script. Allows user to order custom area rugs, specifying size, binding, special charges, etc. Accesses the Cut/Binding Script Window.

• SP - Special. The item appears on the Special and Discontinued Items’ Stock Status list on many input screens, from native to pick unit of measure, and will cause many inquiry screens to convert quantities to the pick unit of measure.

Sequence# for Catalogs

Alphanumeric field for optional special sorting. Within a product line, manufacturer, or color number, this number can be used to put items in a specific order regardless of other codes, such as item number and pattern. You can usually achieve optimum sorting, even if you leave this field blank.

Freight Key

Determines how freight rates should be calculated in applications that involve looking up freight rates in a table. This field can be left blank to assume the default value of W for weight, or set to one of the following values:

• W - Access by weight. Freight rates based on weight are used.

• C - Access by cubes. Freight rates based on cubes (cubic dimensions) are used.

• U - Access by units. Freight rates based on units (the item’s native unit of measure) are used.

• N - No freight. No freight rates are accessed for this item.

Deliver/Mfgr Lead Days

The number of days from the time a purchase order is placed until the item is received. This field overrides the Lead Time entry in the Product Line File. If left blank, it is assumed that the related Product Line File entry applies to this item. Since all items in a product line usually have the same lead time, this field is usually left blank.

Item Width

For rolled goods; the roll width in inches. This entry must be correct for conversions between square yards and feet or inches to be accurate. For other items, this field is for information only and can be used for thickness or for width. It can represent any unit of measure.

Del

D in this field indicates that this record will be deleted. Do edit this field. Let the system’s purging program control the deletion of any item records.

Setting

Description/Instructions

List Price

Price from which all other prices can be derived, by adding or subtracting an amount or a percentage. You can assign whatever meaning you want to List Price, for example, retail price or your contractor price. Customers can be assigned LP in the Billto File as a price list number, and charged the list price for all items.

Standard Last Cost

Unit cost of the last receipt of this item at of the end of the month. The last cost is the landed cost, which includes the cost of freight.

Standard Base Cost

Current replacement or market cost for this item from your supplier excluding all freight and handling costs. The system also figures the actual base cost, based on receipts. This field is user-controlled and should be updated when your suppliers change your prices for this item. The system never automatically updates this field. This is the default cost used on all purchase orders to suppliers for this item, unless the Cost File is used. You can use the Cost File to enter multiple costs based on supplier, quantity, and type of purchase. It can be overridden on the purchase order.

Price Class

The price class assigned on the Item File Profile screen. It is followed by the two-character price list number being displayed. The default price list is LP (list price).

Cost Class

The Cost Class assigned on the Item Profile screen.

G.P.%

The Gross Profit % is calculated by: List Price - Cost / List Price. The GP% of 97.3 shown in the figure above calculated as:

37 - 1.1 = 35.9

35.9/37 = 97.3

Price

List#

This code relates to the Billto File in which each customer is assigned a price list number. Each price list number represents a price list that has been established. All customers are assigned a basic price list number, and, in some cases, alternate price list numbers for certain products. The examples use price list numbers such as A1, B1, and C1, as shown. You can assign your own meaning for each code. Every item should have a price for every price list number on which the item could appear. That way, the system has a price for every item to any customer. Price list numbers are defined using the Classification Codes File.

Quantity

Use this field only if you have different unit prices based on quantity. Enter the quantity through which the price applies. If you specify quantity breaks, the last quantity listed should be 99999 as shown in the above figure.

If the Item File minimum quantity is set to all nines (99999), it is interpreted to mean to minimum quantity, and therefore, all customers are subject to the charge, regardless of the entry in the Billto File Minimum Charge field. Any other quantity (less than 99999) in the minimum quantity field applies only to customers whose Billto File is set to Min Chg = Y. You can use this option to enter minimum charges on certain products that override normally exempt customers. For example, you might want to apply a fixed handling charge when a certain item is sold, regardless of quantity. This option can apply to items that always require special paperwork or packing when sold.

For rolled goods any minimum charge for rolled goods identified by codes H (handling charge) or P (packing charge) apply to any open (unsealed) roll, regardless of whether it is a cut or balance. Minimum charges for rolled goods with codes other than H or P still apply only to cuts.

Field

If you want to calculate the price as a percentage of something else, enter one of the following field codes:

• AC - Average Cost (average unit cost of current onhand)

• BC - Base Cost (standard unit cost excluding freight and handling)

• SC - Standard Cost (standard unit cost, including freight and handling cost)

• LC - Last Cost (unit cost of last receipt including freight and handling)

• LP - List Price

For example, enter LC x 1.25 to charge Last Cost + 25%.

Variable%

If you want the system to calculate the price as a percentage of something else, and you have entered a field code (LP, LC, SC, AC, or BC), enter the amount by which to multiply the field. Observe the decimal point as displayed. This field is shown only if price classes are used.

Price

Price as calculated by the Field x Variable%.

Minimum Quantity

Minimum quantity you will sell, below which an extra charge is billed to the customer.

Note:   See Minimum Order Charges for more information and examples of minimum order charges.

Minimum Charge Code

Minimum charge code that represents the description of the charge. Codes are:

• B - Broken unit charge

• C    - Minimum cut charge

• H    - Handling charge

• M    - Below minimum quantity charge

• P    - Packing charge

The code you enter causes its corresponding description to appear on the order and invoice.

Below Minimum Charge

Dollar amount to be charged each time a customer orders less than the minimum quantity. The Order Entry program automatically creates a miscellaneous charge line whenever a line item quantity is below the minimum quantity.

GL

Enter the general ledger account number to which the minimum charge should be booked. This GL number is entered on the order and invoice, and is shown on applicable reports.

Setting

Description/Instructions

Amount

The factor used for the conversion.

UM

The unit of measure code corresponding to the Amount.

per UM

The unit of measure you are converting to.

Note: The system protects you from inadvertently changing the unit of measure for an active item by changing it to another price or cost class with a different unit of measure. Changing the unit of measure for an item that is active (has open orders, purchase orders, or inventory) causes many problems, as all transactions and statistics are assumed to be in the items’ native unit of measure. These enhancements ensure that no open orders or inventory are affected by a unit of measure change. In order to further protect the integrity of statistics, we recommend that you create a new item number, rather than changing the unit of measure, unless the item has not been used significantly.

List Price

A breakdown of the list price per unit of measure.

Print 1st 2 Entries On Invoice

This setting provides the option to print the first two lines of the packaging breakdown on the customer service invoice.

The first two entries print on the invoice beneath the item description. This option is separate for each packaging record. This entry can be helpful information for the customers purchasing certain products.

Setting

Description/Instructions

UPC Code

This is the main UPC Code associated with this item.

UPC/Ctn

This is an alternate UPC Code - associated with the carton, for use with scanners in the warehouse. The field labeled “UPC Code” is the main UPC Code.

This field can be an actual alternate UPC code, a European code such as a EAN code, or even another code that is on the carton, that you want to scan, but is not really a UPC code.

Item Scan Override

This field can be set to override IWMS control panel settings for specific items. You can use this field to force item verification on individual items. This can be useful for expensive items, or items with a history of being picked incorrectly.

Checkstring

Item checkstrings are 5 character numbers that provide another layer of tracking, validation and mistake prevention. Checkstrings are usually embedded in a bar code and act like an extended location.

Note: Checkstrings are maintained via menu option WM2 15.

Storage Code

Storage codes designate the lowest level of a warehouse location. Use storage areas to further organize your inventory. For example, you can establish storage codes for different colors or sizes of the same items.

Storage codes work with directed putaway to ensure effective capacity usage. Each storage code is assigned a priority by area, sub-area, and alternate area. This priority directs the search sequence when directed putaway is looking for available space. When directed putaway is run, it looks at storage code of the item, and then goes through the areas, subareas, and alternate areas assigned to that storage code to check for available capacity and compares it to the quantity being put away.

Note: Storage codes are created via menu option WM1 10.

Field Name

Description/Instructions

Main Type

Use this field to categorize each line of text. Main type options are:

D - Disclaimer

I - Installation instructions

M - Miscellaneous/other

S - Shipping/delivery instructions

T - Translated name or description

A - Alternate/substitute item

P - Purchasing instructions

Sub Type

Sub type codes are used to identify the language in which the instructions are written, or can have user defined meanings. If used to identify by language, it should relate to the language codes that you create in the Classification Codes File.

Product Knowledge screens support sub-type “U” for URL, for the purpose of storing the URL for web-pages related to an item. When the product knowledge screen is displayed in Order Entry, Order Change, Inventory Inquiry, or via the Décor 24 application (on a web-connected PC), the URL may be clicked to open the web page. For more information on this refer to Linking Products to Web Pages via URLS.

Text

Type information here.

Print?

To specify where this information prints; on the picklist, acknowledgement, invoice, purchase orders. Enter Y to print or N not to print.

PL

Pick list.

ACK

Acknowledgement or quotations.

INV

Invoice to customer.

P/O

Purchase order to supplier.

Col

Color. You can specify the color for displaying this line on the Order Entry Product Knowledge screen. The color codes control each line on the Order Entry Product Knowledge screen. We recommend that you develop a company-wide system for color-coding information. For example, substitute items could appear in pink, important product disclaimers in red, or installation instructions in white.