Item Codes

To create item codes, click INVENTORY -> ADD ITEM. Some software systems call it "Stock Code", while some call it "Product Code", in Wavelet, anything details that is billed may or may not be products, or stocks, they could be services, or packages, or any item that is included in an invoice or cash bill, hence, we call it "Item Code".

 

For companies that are first time using Wavelet EMP, they can import their old item codes into Wavelet by clicking INVENTORY -> IMPORT ITEM CODES.

 

Please note that as there's only one set of item master (maintenance) in Wavelet, if there are more than one PC Center, or branches within the same system (database), the item master records are shared. This also means, a group of companies selling similar or same products will share the same list price, item code, item name, and descriptions. For a group of companies having different businesses, it is recommended that they use more than one database (more than one servers).

 

See table below for more descriptions on each field of the item code:

 

Field Name

Description

Remarks

Item Code

An alpha numeric field up to 50 characters. Punctuations are to be avoided except for underscore "_" or dash "-".

For best practices, all alphabet should be capitalized.

Item code has to be unique within Wavelet.

Some companies design their internal item codes carefully for easy searching and better presentation on the reports (most of the reports are sorted according to item codes).

Some companies do not design their internal item codes, and they use the EAN codes from the suppliers for each product as the item code.

 

 

Item Name

The product name, or name of the services, packages for this item. Normally, the item name would be printed along side with the item code.

 

Since the product names may not be sorted according to the specifications of the product, using product name as a sort criteria for reporting may confuse the readers.

 

Item Description

Additional description for the product, normally, the description is for internal reference, and they are not printed at the invoices or cash bills.

 

 

Categories (Level 1 - 5)

Before you configure this category, please ensure you have set up the maintenance of the category Level 1 to Level 5.

 

With proper configurations, users will be able to view various reports with various grouping meaningfully.

 

List/Retail Price

This is the default list price or retail price of the product. If there's discount, normally, the total discount is calculated based list price.

 

The list price is normally applicable to

Wholesale Price

Normally this price is used to indicate the pricing to the dealers or distributors at a wholesale level.

 

Since system administrator could configure the default pricing of the branch, if the branch is set to this pricing, it is possible that this become the default price of all products in the system.

 

Discount 1

This is additional pricing levels for more flexibility.

 

Sometimes, this could be used for volume pricing, or pricing specific to certain geographical locations for chain store and franchises that spread across different type of demography.

 

Discount 2

Same as discount 1

 

Discount 3

Same as discount 1

 

Minimum Selling Price

This is the minimum allowable price that user could record into the point of sales system (POS), or invoice.

 

Normally it makes sense to sell above cost, but sometimes, due to market conditions, or special promotions, the minimum selling price may be lower than the cost. At other times, the minimum selling price could be way above cost.

By setting the minimum price of a product / item, the system could prevent the salesman from selling too aggressively, because there are other cost factors need to be considered (overhead, logistics etc), hence, the salesman should not assume that if a product is sold above the cost, there will be profit to be made.

 

Replacement Cost

This field is just a record of how much it cost to replace an item. It has no effect on other functions in the system, and not displayed in any reports currently.

 

 

Keywords

The keywords in this field could be used by users to search for this product. Some times, the search phrase is not part of the item name and description, but the search phrase is related to the product in some ways.

 

The keyword field is normally used in e-commerce web sites, not so much for the back end users.

Serialization

If a product is serialized, users are required to key in the serial number of the products when they do stock in and stock out.

 

 

Product Type

The product type defines if a product is INVENTORY, NON-INVENTORY, SERVICES etc.

 

Currently, the logic to differentiate different item type are not in place, but in future, checking of negative quantity and other things will not be enforced for SERVICE ITEM at the POS or Invoice function.

 

EAN / UPC Code

This is the unique barcode assigned to each of the product, and used to scan while recording the product at the POS to minimize user mistakes, and improve the speed of data entry.

 

 

Production Required

Certain products require packaging, assembly, or some customization.

 

 

Delivery Required

For some businesses, some of the products sold are too big or too heavy, and consumers will not be able to carry these products, hence, requires delivery services to be provided.

The configurations define the default delivery option, users could still change this value at the Point of Sales, when creating the sales order etc.

Only products require delivery will be seen by the logistic department, when they are processing the delivery items inside the "Distribution Module".

 

 

Unit Of Measure

This is the stock keeping unit of the product.

 

 

Weight

The weight of the product may come in handy when it comes to calculations of the freight charges.

 

 

Width / Length / Height

This is to record the physical dimensions of the product, normally including the packaging (box).

Sometimes, freight charges are calculated based on the dimensions as well.