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

 


Comments