DEV Community

Ajay Oloruntoba
Ajay Oloruntoba

Posted on

# Item Master Data

As well as knowing how many of something you have,

You need trusted information about your items.

This information is often managed using an item master.

What is contained within Item Masters?

Typically item records will include:

| Field | Description |

|---|---|

| Item Code | Identification of the product |

| Description | Description of the item |

| UOM | Quantity is measured in |

| Category | Grouping together similar items |

| Barcode or Identifier | Assists identification of item |

| Storage | Gives relevant location information |

This will vary depending on your organisation and inventory processes.

What can go wrong?

If we have item records such as:


ITEM001 — Industrial Cleaning Product

ITEM001A — Industrial Cleaner

ITEM001B — Cleaner, Industrial

Enter fullscreen mode Exit fullscreen mode

And these are all the same product, we are likely to have duplicate records.

This can cause issues when staff are searching for products, receiving goods, recording transactions and generating stock reports.

Another common issue is incorrect UOM (unit of measure).

If you receive a carton of goods but record them as individual items and do not have a clear conversion between the two, you will have differing quantities.

Real Life Rules

Define an item creation process.

Ensure new records are created in an agreed format.

Use consistent identifiers.

Try not to have duplicate item codes.

Use consistent descriptions.

Have clear naming conventions.

Define UOM.

Ensure you know how you are purchasing, storing and issuing items.

Audit your data.

Ensure there are no duplicates, missing or out of date records.

Why it is important

Whilst using barcode and RFID technology can help identify items, you still need accurate product information.

Having good item records is key to having reliable inventory processes.

Inventory Master covers inventory management systems and tracking technology.

Find out more here: https://theinventorymaster.com/inventory-management-software-systems/

Having a useful inventory system will require accurate quantities and reliable item information.

Top comments (1)

Collapse
 
ajay_oloruntoba_b8a722b0f profile image
Ajay Oloruntoba •

contribution is welcome