Product Master - Main 

Fields

Description

Header Section

Product Code

Set of alphanumeric values to uniquely identify each Product. This is usually the bar code of the product. If an item does not have a bar code, a unique code can be entered.

Description

Detailed description for the Product Code.

Category

Category code this item belongs too. These are setup in the Product Category menu.

Sub Category

Relevant sub category code this item belongs too. These are setup in the Product Category Menu

Supplier

Displays a list of suppliers to be associated with each product. Source or supplier from which the item is usually purchased from. These are setup in the Supplier menu.

UOM

Select the UOM used for stocking and selling the item.

Currency

The exchange rate used on the product.

Weight

Numeric field to capture the weight of an item.

H/W/L

Numeric field to capture the height, width and length of an item.

UPC

UPC is the universal code that identifies the product internationally.

SKU Code

Enter supplier Part Number.

Price Class

If price class exists for the item, double click and select appropriate price class.

Cycle Code

Controls the stock take period for the product. These are create in the Cycle Code menu.

ABC Code

These are classification codes. For example, categorise items as A,B,C where Category A can be classed as fast selling items.

Inv Cost Method

Enter the Inventory Cost Method - select the method you want to use to calculate the value of the item.

·         Average. The Estimated total cost of goods divided by the number of items in stock.

·         FIFO. First in/First out

·         LIFO. Last in/First out

·         Standard - The target cost of production, including material, direct labor and overhead charges.

·         Last Cost – the last cost which was used to purchase an item.

Status

You can give items a status with the following item types:

·         Purchase - Items that your company purchases from a vendor.

·         Non-Quantity Bearing - Traditionally, items that are services, (such as rush-order charges) you want to include on the order. These items cannot be transferred or adjusted; however, they can be purchased, sold, or consumed in production.

·         Kit - Finished products that are made up of one or more finished goods or subassemblies.

·         Obsolete – Items that are no longer purchased or sold by the business.

When the KIT Status is selected then the KIT button is functional to allow records to be entered into the KIT items form.

Min Profit %

Percentage field indicates that the discount issued for the product should not let the profit fall below the amount specified.

Use Location Price

Location tag allows maintaining and creating details for the product in a specific area. When the Location Price check box is selected then the Product Price button is disabled and the Price button at the end of each Location line record to be selected in order to allocate prices according to the location hence this price is applied during the sale of the item.

Lot Bin

Allows the selection of the Lot Bin button, if the tag is on then the Lot Bin button is functional otherwise it is disabled. The Lot Bin criteria are appropriate when items require to be kept according to the bins of a warehouse or store shelves. The items are mainly classified to their expiry dates, serial number etc.

Bulk Item

Selection is applied to products that are sold from the bulk e.g. refill oil selling method and selling large bags of flour, rice, chicken, manure etc. These items are not located on the supermarket shelves in large quantity but are stacked in the bulk area and are given out when the customers show payment slips for the item(s).

If an item is flagged as a bulk flagged item, a picking slip will be printed for these items. For example, in supermarkets, where items are stored in a bulk, picking slips may need to be printed to transfer the items from the bulk to the stores or in a Restaurant any items which needs to be cooked in the kitchen and should appear on the chefs screen should be tagged as bulk items.

This field name is configurable in the Configuration Menu.

Allow Discount

Tag this field if you want to allow discount.

Custom Kit

Products can also be setup as Custom Kit Items. Custom kit items automatically increment by 0.5 and 1 and are configurable in the Configuration menu

Product Price

Click the product price button and enter the sell price for the item. An item can be sold using one of the following pricing structure:

• Priority 1 – Price level (different price level can be setup for different customers. This is then assigned to the customer in the Customer Maintenance screen in POS)
• Priority 2 – Cost + Markup %
• Priority 3 – Promotional Price

·         Priority 4 – Price Break

Kit Items

The Kit Item button is enabled when the 'Kit' option is selected from the drop down list in the Status field.

Detail Section

Location

Enter Locations for each product. You may store the same inventory item in several locations. There is no limit to the number of locations to which you can assign an item. For each location, you can:

• Track quantities and costs
• Specify lead times
• Set minimum order amounts

·         Set minimum and maximum stock quantities

Note: The system will insert all the locations (setup in Location Menu) when a new item is created if the Auto Insert location flag is set to 'Y' in the Inventory Configuration.

Tax Code

Tax code used when selling the item.

Bin No

The area in a location where the item is kept.

Min Order

The minimum quantity you can order at any time. This is usually used for Inventory Replenishment.

Min Stk

Lowest quantity of an item you should have in stock at any given time.

Max Stk

Largest quantity of an item you should have in stock at any given time.

Avg Cost

This is the average cost of the item calculated by the system.

New Average Cost = (In stock * Old Average Cost) + (Number of items bought/adjusted In * Unit Cost)

                    (In Stock + Number of items bought/adjusted In)

Last Cost

Last Cost of the item bought. This is calculated by the system however the user can override this value.

Std Cost

The Cost of the item. This is entered by the user.

Available

In stock quantity. This figure is updated by the system using Inventory Adjustment, Stock Take, Receive Purchase and when an item is sold.

Acct Code

Posting Account used for GL Integration.

Allow Negative

Check box is to schedule the product to be sold even though it does not exist on the shelf.