Jewellery ERP: What It Is and What a Jewellery Business Needs

What ERP actually means

ERP stands for enterprise resource planning, a phrase from manufacturing that has been stretched to cover almost any business software with more than one module. Stripped of the marketing, an ERP is a single system of record. The same stock, the same customers, the same balances, read and written by every part of the business, so that nobody has to reconcile two systems that both claim to be right.

That definition matters more than it sounds, because it is also the test. If your billing screen and your stock register hold their own copies of a piece’s weight, you do not have an ERP. You have two programs and a habit.

What makes a jewellery ERP different from a general one

A general ERP built for wholesale or manufacturing can be bent towards jewellery, and plenty have been. What it usually cannot do is treat weight and purity as the shape of the record rather than as extra fields. Four things follow from that shape, and a jewellery ERP has to get all four right.

• Weight is the unit of account. Gross, stone, net and fine weight on every piece, with purity behind the fine weight. Stock reports that add pieces are decoration; stock reports that add fine grams are the books.
• Price is calculated, not stored. Metal value comes from today’s rate, and making, wastage and stone value sit on top of it as separate lines. A stored price is stale the next morning.
• Metal leaves without being sold. Issued to a karigar, moved to another branch, taken in as a repair. Each of those is a stock movement, and a system with no place for them will always be short.
• Old metal comes back in. Old gold taken in exchange arrives at whatever purity the customer’s piece happens to be, and has to be valued at that purity rather than at the purity you sell.

The modules a jewellery business genuinely needs

Vendor module lists are long because length is easy to sell. For a shop holding gold and silver stock, this is the short list that earns its keep from the first week.

• Inventory — items by weight and purity, categories, branches and locations, transfers, and physical stock audits.
• Sales and billing — VAT invoices with metal, making, wastage, stone value, discount and tax shown separately, plus credit and debit notes that reference the original bill instead of rewriting it.
• Purchases — invoices line by line with weight, purity, making and wastage, and stock that moves when goods are actually received.
• Customers and suppliers — balances, dues and payments recorded against the specific invoices they settle.
• Workshop — karigars, jobs, and the weight issued against the weight returned. Repairs and replacements where the business uses them.
• Reports and export — stock valuation, sales and purchase registers, VAT registers by fiscal year, ledgers and dues, all exportable to CSV, Excel and PDF.
• Roles and an audit log — because a stock ledger records where valuable things are, and it is worth knowing who changed what.

What can wait

Almost everything else. A shop with one counter and one workshop does not need production planning, a customer loyalty engine or multi-currency on day one, and buying them makes the first three months harder without making the books better. Two things are worth turning on only when there is a reason: a second branch (which makes transfers and per-branch reporting matter overnight) and electronic billing to the tax authority, which a business enables with its own credentials once it has enrolled. Tax settings themselves are configurable, and the rates to use are a question for your accountant rather than for a software vendor.

How to tell an ERP from a till with a stock list attached

Follow one weight through four documents. If the number is the same in all four without anybody retyping it, the system is joined up. If it is retyped, it will drift, and the drift is not theoretical.

Five questions to ask before you buy one

• Does an item hold gross, stone, net and fine weight, and is purity a field on the piece rather than part of its category name?
• When old gold is taken in exchange at 18K against a 22K sale, does the stock position move by the fine weight or by the gross weight?
• Where does metal issued to a karigar appear in the stock valuation while it is out of the building?
• Can a bill be corrected by credit note without the original invoice changing, and are invoice numbers ever reused?
• Can you export your own data, in full, whenever you want to?

A vendor who answers those five plainly is worth more of your time than a vendor with forty modules.

Is an ERP overkill for a single shop?

Sometimes. If your stock is small enough to count in an afternoon, never leaves the premises, and one person knows all of it, a careful ledger book is still a working system. The threshold is not turnover, it is the number of places metal can be. Add a second branch, or a karigar who takes metal away, or a second person billing, and the number of places exceeds what one memory holds. That is the day an ERP starts paying for itself, and it usually arrives before anyone notices.

How DataJewellers does this

DataJewellers is built as one record rather than as modules bolted together, so the weight entered on a purchase is the weight on the tag, in the audit and on the bill. See jewellery ERP software for how the parts fit together, jewellery inventory management for the stock side, and jewellery business management for branches, roles, permissions, custom roles and the audit log. Sales carry on when the connection drops and sync without duplicating an invoice, and there is a desktop application as well as the browser.