Contact:
Rahul Chavan: +91-9820859510 / +91-22-28486903
email: rahul@innovatechno.com
skype: callrahulchavan
Blog : On Item Codification

One of our clients wanted an advise on how to codify items. It was for a precision turned component manufacturing company. The material included customer drawing no based finished goods, various grades and shapes of steel bars as raw material, cutting tools, consumables, jigs & fixtures and such tooling, gauges and instruments.

Generally companies have evolve their own nomenclature. Some by experience and some by advise. And there are still some who are still discovering!

Earlier computer systems were not used by the SME sector. This was the period when Item Code mattered a lot. There used to be some logic built into the code. For example 40-114 denoted 40 series which was supposed to be say steel bars and 114 just denoted the serial no of register in which parts were registered.

Some evolved code in such a way that it was possible to almost identify the item from code. For example  RMEN8D20 represented Raw Material of EN8D grade and diameter 20mm.

Some companies have a big alpha-numeric code like 000234111T. Usually such codes are of equal digits. This helps in sorting the list of items. Zeroes are attached usually in the suffix to make up for the decided length if required.

What we recommend is a easy to understand code which follows the following rules:1. The Codes are of equal digits. 2. Short forms and Abbreviations must be defined and hence used with consistency.3. The logic of code should always go from broader to narrower.4. Do not use any space or underscore within the code. Use "-" instead.5. Do not make it too complex.

As such all good software have excellent search facilities. Even with a few key strokes one can reach the desired item. Items can be searched even by keying in a small part of description. And then there are alternate media like bar codes and RFID tags where even keying in is eliminated. Hence we feel the significance of Item Code is decreasing day by day. Let us not think too much about it.


05 September 2010
Material Requirement Planning

Material requirement calculation based on sales orders and stock
Online CRM

Sales Executives as well as dealers can use online interface for enquiry handling, quotation and Sales Order booking
Costing

Costing can be integrated with quotation and orders
Internal Rejection Analysis

Rejection reason wise analysis in terms of ppm and percent
Excise Module

All formats and reports as per the guidelines of excise department
Material Traceability

Complete material traceability. Lot wise traceability for rawmaterial and production batch wise traceability for manufactured items
Material Test Certificate Generation

Automatic compilation of Material Test Certificate based on Chemical and Physical properties.
Dimensional Inspection

Provision for capturing Dimensional Inspection and generating report
Inventory Control

Scientific Inventory Management System. Various models based on type of industry and products
Spare Part Management

Tried and Tested Spare Part Management system. Improves service levels and reduces inventory
Warehouse Management Software

Multiple warehouse, multiple customer with separate interface for Warehouse, Customer and the management
Part Codification

Simplifies the task of item codification. Works based on Item Categorisation