Item Master

Purpose

This form is used for recording the reference details of each inventory item. Each item must first be registered here, and assigned a code, before any transaction can be processed for that item.

The term item includes all inventory objects handled such as products, materials, and supplies.

Main Form

Layout

Explanation of Fields

Item No.

Required. Capslock.

Item Category

Capslock. Optional.

Item Name

Required.

Description

Optional.

Vendor Part No.

Optional.

Stock Unit

Required. Not capslock.

Item Type

Either “Stock”, “Non-stock”, or “Assortment”. Stock means that transactions for this item is being tracked by the Inventory module. Non-stock can be used for actual products and materials but the transactions are not being tracked by the Inventory system. Assortments are those items which are actually composed of other items. The inventory movement implications of assortments are in terms of the component items.

Active

Default to true.

Main Location

Optional. Capslock.

Cost Centre

Optional. Capslock.

Distribution Tab

Explanation of Fields

Purchase Group

Purchase Unit

Optional, Capslock.

Preferred Vendor A

Capslock. Optional.

Preferred Vendor B

Capslock. Optional.

Reorder Point

Must not be less than zero. You can change the reorder point at any time.

Minimum Order Qty

Must not be less than zero. Minimum Order Qty is the number of item units recommended for purchase each time the reorder recommendation occurs. You can change the reorder quantity at any time.

IQC

Require IQC Inspection? Default to False.

Safety Stock

Must not be less than zero. Safety Stock is the quantity carried to compensate for forecast errors. It is used when calculating the order point.

Sales Group

Base Price

Must not be less than zero.

Sales Unit

Default to Stock Unit. This field is not capslocked. Sales Unit is the item's unit of measure (lb., carton, bundle, etc.) when sold from inventory. If the item's sales unit is different from its stocking unit, you must set up a unit conversion using Unit Conversions

Item Discount

Default to 0. Range 0 to 100.

Qty per Inner Ctn

Used only as comments by the system.

Qty per Outer Ctn

Used only as comments.

Lead Times Group

Production

Must not be less than zero.

Purchase

Must not be less than zero. Purchase Lead Time is the number of days between the item being ordered and the item's expected received date.

Sales

Must not be less than zero. Sales Lead Time is the number of days between the item being ordered and the item's expected delivery date.

Photo Tab

Explanation

This dialogue is used for editing the graphics image of the item. The options available allows you to load graphics files as well as edit and paste operations.

Packing Info Tab

Explanation of Fields

Dimension Group

Unit

Not capslock. Optional.

Length

If unit is blank, set to null or zero and disable. If unit is not blank, must not be less than zero.

Width

If unit is blank, set to null or zero. If unit is not blank, must not be less than zero.

Height

If unit is blank, set to null or zero. If unit is not blank, must not be less than zero.

Weight Group

Weight Unit

Must be a valid entry in the GBUNIT table. No capslock. Optional.

GW per Unit

If weight unit is blank, set to null and disable ( or maybe zero). If weight unit is not blank, must not be less than zero.

NW per Unit

If weight unit is blank, set to null and disable. If weight unit is not blank, must not be less than zero.

Volume Group

Item Volume Unit

Not capslock. Optional.

Item Volume

If volume unit is blank, set to null or zero and disable. If dimension unit is not blank, must be less than zero.

Sales Carton Volume Unit

Not capslock. Optional.

Sales Carton Volume

If volume unit is blank, set to null or zero and disable. If dimension unit is not blank, must be less than zero.

Export Carton Volume Unit

Not capslock. Optional.

Export Carton Volume

If volume unit is blank, set to null or zero and disable. If dimension unit is not blank, must be less than zero.

Colour Group

Qty per 20 ft

Not capslock. Optional.

Qty per 40 ft

Not capslock. Optional.

Packing Group

Packing

Not capslock. Optional.

Container Group

Colour

Not capslock. Optional.

Product Specifications

Include the scrollbars in the memo field.

Stocking Info Tab

Explanation of Fields

Qty On-Hand

For display only.

Qty On-Order (Sales)

For display only.

Qty On-Order (Purchase)

For display only.

Total Cost

For display only.

Unit Cost

For display only.

Last Unit Cost

For display only.

Last Date Received

For display only.

Last Receiving Ref.

For display only.

Other Info Tab

Explanation of Fields

Alternate Name

Optional. In a multi-language environment, the name of the item in the alternate language is entered here.

Alternate Description

Optional.

Shipping Mark

Optional.

Material

Optional.

Country of Origin

Optional.

Sales Price Tab

Purchase Price Tab