Displays whether or not there are notes associated with the product. You can append notes to a product by pressing "N" to access the product notes summary screen. When adding a new product you must complete the entry of the new product data before you can append a note.

Product code (up to 15 alpha/numeric characters) used to identify the product. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY. In addition, each product has a unique code generated by the program to identify the product.

When adding a product based on an existing product, this field displays the existing product's type code. When adding a product that is not based on an existing product, this will field defaults to SA. IdealWare currently recognizes the following 7 product type codes.

Insulation, Gyprock, Lumber and Plywood can be used in place of SA type products when special processing is required.

Product display description (up to 30 alpha/numeric characters) is displayed along with the product code each time you access the product. When adding a product based on an existing product, the existing product's description is displayed. You can use the [TAB], [END] and right and left ARROW KEYS to move around this field to modify the description. [INSERT] toggles between insert and typeover modes.

For lumber products the length should be the last 2 digits of the description (ie for an 8 foot 2x4, 2X4 D&BTR CLR S4S WRC 08). If auto setup is used when adding a new lumber product, the length in the description will be modified automatically based on the 2 digit length code entered at the PRODUCT CODE field.

When adding a new lumber product based on an existing product, the length or packsize should have been modified automatically by the auto setup feature of the program based on the fractional entry in the PRODUCT CODE field. If it was not then you did not enter the decimal value correctly. Press [F3] to return to the PRODUCT CODE field to re-enter the decimal value.

These fields are optional additional product description lines. You are prompted to enter a shipping description in the 03 EXTRA field. You can enter "." to insert the display description into this field.

Indicates the product group code (up to 4 levels). Product group codes are setup in the inventory group maintenance program. Press [F5] to display the product group codes list for selection.

Product groups are used in product inquiries by group. Additionally, product groups are used for sorting in most inventory reports.

For G, I, L, and P type products, the default unit of measure as determined by the product type will display automatically for selection, but you can change the default if required. See 31022 - PRODUCT TYPE MAINTENANCE. For SA, SE or SM type products the default value is UNIT or EACH, but you can enter any unit of measure you wish that suits the product. For SA type products the base unit is the unit in which the quantity on hand will be calculated.

For G, I, L, and P type products, the default unit of measure as determined by the product type for pricing level 2 will display automatically, but can be changed if required. For SA, SE or SM type products you can enter any unit of measure you wish.

The number of base units in the ALT-1 unit. For example, if the base unit is EACH and the ALT-1 unit is BOX, the ALT-1 MULT might be 10 (ie 10 units per box).

For G, I, L, and P type products, the default unit of measure as determined by the product type for pricing level 3 will display  automatically, but can be changed if required. For SA, SE and SM type products you can enter any unit of multiple measure you wish.

The number of base units in the ALT-2 unit. For example, if the base unit is EACH and the ALT-2 unit is CASE, the ALT-2 MULT might be 24 (ie 24 units per case).

An alternate product code can be used if the product is not available (eg out of stock). Multiple products can share the same alternate code, refer to 30974 - PRODUCT CODE INQUIRY. You can also use the alternate code to link products, for example in the ALT CODE field of a paint product you could place the product code of an eco fee charged for the empty paint container. Whenever the paint product is sold the linked eco fee will automatically appear as the next line of the sale.

The quick code is another product code that can be used to access the product throughout the IdealWare system. It is user definable and can be anything you wish. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY.

For SA, SE and SM type products, the logical code can be used just as another quick code.

For Insulation, Gyprock, Lumber and Plywood type products, the logical code is used to link together a group of similar products and must be formatted properly to enable the linking function for such things as lumber pieces and lengths logic in sale order entry to work properly. See 31014 - ADDING PRODUCTS, LOGICAL CODE FORMATTING. Subsequent changes to the logical code will automatically force a recalculation of FBM and LINEAL/SQFT factors for these products. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY.

Up to 6 UPC bar codes can be entered per product. You can see a product's UPC bar code when at this field if it is filled in properly. These fields can also be used as alternate quick codes by pressing [F1] to allow for non-UPC code entry. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY.

Indicates the physical location of the product by store and other criteria you set up. A location code is typically formatted as follows:

Up to 4 main suppliers can be specified for each product, along with each supplier's product codes and rebates relating to the product.

Indicates supplier code as set up in the A/P supplier master file. Press [F5] to display list of A/P supplier codes for selection.

Indicats supplier's equivalent product code. This is printed on the purchase orders to the supplier and can also be added during purchase order entry.

Indicates any rebate offered.

Displays whether or not there are notes associated with the product. You can append notes to a product by pressing "N" to access the product notes summary screen. When adding a new product you must complete the entry of the new product data before you can append a note.

Product code (up to 15 alpha/numeric characters) used to identify the product. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY. In addition, each product has a unique code generated by the program to identify the product.

Indicates the status of the product. This field value defaults to RE, or if you have based the new product on an existing product to the status of the existing product.

On color monitors each product status is represented by a different color and wherever the product's description is displayed throughout IdealWare it is displayed in the color of its current status. IdealWare currently recognizes the following product status codes and associated colors:

Indicates whether or not the product is a package type product that is to be defined with components via the package/set master maintenance program. All regular products, including package component products, must have this field set to "N".

Indicates the security tag code for the product. Security tag codes are used for reference when receiving inventory. IdealWare currently recognizes 4 security tag codes:

Indicates whether or not the product is provincial sales tax exempt. The default value is "N".

Indicates whether or not the product is goods & services tax exempt. The default value is "N".

Displays the foot board measure factor that applies only to lumber type products. The program calculates this value automatically based on information contained in the product's logical code. For nonlumber type products this field is bypassed.

Lineal measure factor applies to lumber and gyprock type products and square footage factor applies to plywood and insulation type products. The program calculates this value automatically based on information contained in the product's logical code. For SA, SE and SM type products this field is bypassed.

Displays the physical location of the product (eg aisle, row and section). This value is used only when the product is initially being added and should be modified subsequently via the product location maintenance program.

This field sets the base unit average cost to be applied to the product. This value is used only when the product is initially being added and is used to establish an initial value during the first stock count that includes the product. After initial setup, costs are determined either by the supplier cost file maintenance program or the products automatically calculated average cost when received.

This field enables a product to have a weight associated with it. You can enter the product weight or press [Enter] to bypass the field. The weight can be entered as LB or KG. The picking list document can be modified to print the total weight associated with each line of a sale and to also print the total weight associated with the delivery. The weight is always per "standard unit" which is defined as follows:

You can enter a minimum gross profit percentage, if desired, or press [Enter] to bypass the field. Products with a percentage value in this field, will display the following warning during sale order entry if the minimum gross profit on the sale would fall below the percentage value set here.

Displays the number of pieces in various package sizes that apply to lumber, plywood and gyprock type products only. You can enter the number of pieces per pack or press [Enter] to accept the displayed value, based on the product logical code.

If your system is configured to track products by serial numbers or purchase orders, this field is used to indicate which, otherwise this field defaults to "N".

If sales of this product should update OTHER SALES STATS rather than normal SALES set this option to "Y", otherwise this field should be left to the default "N".

OTHER SALES STATISTICS are those which do not affect the gross profit on a sale. For example, a $1,000 before taxes invoice that has a $200 component of "other" sales and a $500 cost would have a gross profit% of 30%. This is useful for service products such as "delivery" which you might not want to be included in the gross profit calculation. The customer balances/statistics screens and the salesman balances/statistics screens show OTHER SALES$ separately.

If sales of this product should allow or require the entry of a cost, set this option to "Y". The sales order entry program will then prompt for a cost when the product is sold. Otherwise this field should be left to the default "N". Any product type, even SE type products can have this field set to "Y" if desired.

During sale order entry, when an EXTRA COST product is entered, the sales order entry program automatically prompts for a cost. Extra costs are accumulated on the order and reduce the gross profit for the order. EXTRA COST lines, however, are not printed on the invoice or picking list documents.

Extra cost products can also be flagged as being ACCRUAL extra cost products, in which case the sales order entry program also prompts for a supplier code. When the order is updated, the accrual extra cost product entries are updated to the specified supplier files.

Indicates the store code or region code as configured in the store master maintenance program. In a single store environment this value defaults to the normal store or region code.

Product code (up to 15 alpha/numeric characters) used to identify the product. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY. In addition, each product has a unique code generated by the program to identify the product.

Indicates the level of inventory at which reordering the product is necessary. The unit of measure used is the base unit for SA type products, the FBM for lumber products, BAGS for insulation type products, and PIECES for plywood or gyprock type products.

Indicates the normal reorder quantity, using the same units as the RE-ORDER POINT field.

Indicates the order of preference for the product's suppliers. You can only enter supplier codes here that have been specified on maintenance master screen 1. Supplier #1 is the primary supplier and is used by IdealWare as the default for supplier cost lookup in various reports and entry data fields. If you have multiple stores or regions, your supplier ordering preferences can be different for each store or region. Press [F1] to shuffle the order of the suppliers.

These fields apply to SM type products only. Indicate the markup percentage that is used to calculate the cost of the product. By default the markup% is defined as a "markup% from cost" and is used to calculate cost of goods as follows:

Your system can be configured to define the markup% as a "margin% from sales" and would calculate cost of goods as follows:

Indicates whether or not there is a payment discount applied to product. This value defaults to "Y".

Indicates the price discount code for the product as set up in the price discount maintenance program. If the PRICE DISCOUNT field on the yard/store master is set to "N", then no discount code can be entered here and the value will default to "N". If your system is configured to allow for price discounts during sales order entry, then the code "N" flags this product as not price discounted. The price discount code is also used as the default value in the price maintenance program to indicate the discounts from retail of different pricing levels.

Set the value here for the base pricing level of the product.

Set the value here for pricing level 2 of the product.

Set the value here for pricing level 3 of the product.

Indicates the store code or region code as configured in the store master maintenance program. In a single store environment this value defaults to the normal store or region code.

Product code (up to 15 alpha/numeric characters) used to identify the product. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY. In addition, each product has a unique code generated by the program to identify the product.

Indicates the primary location of the product by aisle, shelf and section. This field can also be modified via the product location maintenance program.

Indicates an alternate location for the product by aisle, shelf and section. This field can also be modified via the product location maintenance program.

These fields display the last receipt, adjustment, invoice, batch number, date and reference (where applicable) for the product.

Displays the last cost at which the product was received. The Inventory Receiving program automatically creates a supplier/product cost record and updates the "last cost" field if the supplier is one of the four defined suppliers for the product. The product maintenance program displays the supplier's "last cost" if there is no maintained supplier/product cost. If the supplier's last cost is displayed, it will be displayed with an "(LC)" to the right of the cost value.

If the operator does not have sufficient security to see costs, the program does not display the LAST or AVERAGE costs.

Displays the calculated average cost for the product based on receiving costs. Your system can be configured so that when a product quantity and value goes to zero (ie due to sales or inventory adjustments), the average cost is also reset to zero.

Displays the total value on hand of the product in stock.

Displays the actual quantity of the product on hand.

Displays the quantity of the product currently on order, if any.

Displays the quantity of the product committed to current sales, if any.

The quantity available for sale, calculated by adding the on-hand and on-order quantities and subtracting the committed quantity. Your system can be configured not to include the on order quantity in this calculation.

Indicates the pricing level. The default value is "R". IdealWare recognizes 4 pricing levels:

Displays the pricing and costing information for each of the product's suppliers.

Displays the supplier code.

Displays the supplier's product code.

Displays the supplier's cost for the product.

Displays the retail price of the product.

Displays the margin based on each supplier's cost and the displayed retail price.

Press [F12] to display the product inquiry options. See PROCEDURE - PRODUCT INQUIRY OPTIONS.

Indicates the store code or region code as configured in the store master maintenance program. In a single store environment this value defaults to the normal store or region code.

Product code (up to 15 alpha/numeric characters) used to identify the product. Multiple products can share the same code: refer to 30974 - PRODUCT CODE INQUIRY. In addition, each product has a unique code generated by the program to identify the product.

Indicates the base unit of measure/pricing used for display purposes.

Indicates that the information below is quantity information.

Indicates that the information below is dollar value information.

Month to date figures.

Year to date figures.

Last year figures.

Indicates quantity or value at the beginning of the period. The values are as of the last month or year end purge.

Indicates adjusted quantities or values. The values are updated via the inventory adjustments program.

Indicates received quantities and values. The values are updated via the inventory receipts program.

Indicates transferred in quantities and values. The values are updated via the inventory transfers program and/or the inventory adjustments/transfers program.

Indicates transferred out quantities and values. The values are updated via the inventory transfers program and/or sales order entry/transfers program.

Indicates sold quantities and values. The vlaues are updated via the order register and update program and from orders created in sales order entry.

Indicates sold quantities and values for the product sold as components in a package only. The values are updated via the order register and update program and from orders created in sales order entry.

Indicates that the information below is dollar value margin information.

Indicates that the information below is dollar value margin information pertaining to the product when sold as a component in a package only.

Total sales dollars of the product in the period indicated. The values are updated via the order register and update program.

Total profit dollars generated by sales.

Percentage of margin between sales and profits.

Indicates the store code or region code as configured in the store master maintenance program. In a single store environment this value defaults to the normal store or region code.

Indicates the base unit of measure/pricing used for display purposes.

Displays the product code and display description.

Indicates the figures below are displayed on a monthly basis.

Displays sales dollars.

Displays cost of goods sold dollars.

Displays gross profits dollar amounts.

Displays gross profits percentages.

Displays quantities of product sold.

Current Year-To-Date information.

Last Year-To-Date information.