New from Debox — 100 Ops. SOPs that actually get followed.See how it works →

Technology · Multi-entity ERP · Gemstones · US, India, Sri Lanka and Bangkok

Four entities, three countries, one system.

PRIMA Gems asked for an ERP for its India operations. Nine months in, the group restructured into a parent with captive units — so we rebuilt it end to end and went live across three countries in under three months.
Client PRIMA GemsEngaged From November 2025Status Live across India, Sri Lanka and BangkokScope Process standardisation, ERP build, multi-entity redesign, hardware, training, audit support
Entities on one ERP4A US parent with captive units in India, Sri Lanka and Bangkok.
Scope change to full go-liveUnder 3 monthsMulti-entity scope agreed in August 2026; live in October.
Users20+Across sales, inventory, production, dispatch and accounts, in two countries.
01

The short version

PRIMA Gems is a gemstone group run from the US, with factories in Jaipur and Sri Lanka and a unit in Bangkok. Its material is sorted, shaped, sized and finished across those factories and shipped to global jewellery brands.

Those brands audit their suppliers, and PRIMA Gems’ previous audit had flagged gaps in traceability, reporting and inventory management. Everything ran on paper and spreadsheets, so closing those gaps meant a proper system.

We started in November 2025 on the India operations — scoping, standardising the processes, and building an ERP on Zoho Creator for sales orders, inventory, work orders and dispatch. In August 2026 the scope changed: the units in India, Sri Lanka and Bangkok became captive units of the US parent. A single-country system would no longer do. We redesigned and rebuilt the application end to end as a multi-entity ERP, added accounts, costing, reimbursements and P&L, and took it fully live across all three countries in October 2026 with more than twenty users.

02

Audits, traceability and a group of four

For a gemstone supplier the brand relationship depends on proof. PRIMA Gems needed a system for four reasons, and the last one changed the project.

01
Audit findings to close. Brands check their suppliers for traceability, stock control and reporting, and the last audit had marked all three. Leaving them open put orders at risk.
02
A trail for every stone. Each stone needed a readable past: what it was bought as, the invoice it came on, how it was worked, which treatments it carries and where it went. On paper that trail snapped at every hand-off.
03
One view across countries. With production in two countries, leadership needed stock, output and cost in one place.
04
A new legal structure. Once the units became captive units of the US parent, goods, costs and reimbursements started crossing legal entities. That called for one system that understood the whole group, not separate books in separate places.

Four entities. One system. One version of the truth.

03

From one country to four entities

01
Discovery and scope. Traced the work end to end, from buying to dispatch to accounts, writing the requirements starting from what the last audit had marked.
02
One way of working. With the Jaipur and Sri Lanka teams, agreed a single way to receive, bag, issue, move and ship stones, so both factories run to the same playbook.
03
Bag-first inventory. Stock lives in bags, each with its own running ledger, so the books always mirror the shelf.
04
The India build. Sales orders, inventory, work orders and dispatch on Zoho Creator.
05
The multi-entity rebuild. When captive units arrived, we redesigned for four entities and rebuilt from the ground up, adding accounts, costing, reimbursements, P&L and the movement of goods and cost between entities.
06
Barcodes on the floor. Labels, printers and scanners installed in both factories.
07
Testing, entity by entity. Every flow run on real transactions in each entity, issues graded by severity and priority, each closed with a sign-off.
08
Training across two countries. More than twenty users in sales, inventory, production, dispatch and accounts, with us close through the first weeks of live use.
09
Audit readiness. We are leading the next brand and system audits, with every earlier finding mapped to where the system now answers it.

Because steps one to three came first, the August rebuild reshaped the system without unsettling the floor. The factories already knew how they worked; only the structure around them changed.

04

One system for the stone and the group

A gemstone group buys by weight, sells by the piece or the carat, loses material at every wheel and re-sorts its lots constantly. PRIMA Gems also moves stock, cost and money across four legal entities. Most standard ERPs work in one fixed unit of measure, which a gemstone business cannot live with.

What PRIMA Gems neededHow we built it
Pieces and carats in the same flow, which most standard ERPs do not allowPieces or carats, whichever the moment needs: on the order, in the bag and at every stage.
Receipts checked before they reach stockEvery receipt is weighed and counted against the supplier invoice first.
Stock tracked the way it is physically heldEvery parcel is a bag with its own ledger. Bags split and merge under set rules, so history and weight carry across intact.
Cost that stays true when lots are re-sortedCost travels with the stone. When a bag is split, merged or re-assorted, its cost is reallocated, so every new bag carries its true value.
Sight of the weight lost at each stageReceived weight is reconciled against issued weight at every stage. A mismatch is flagged and the stock is blocked until it is resolved.
Breakage and re-work out in the openBreakage, rejections and re-cuts are logged with their weight and cost, so losses are seen rather than absorbed.
Write-offs and excess handled as they happenInventory write-offs and excess stock are recorded, with the cost moved and accounted for.
Consistent valuation and reliable countsEach bag is valued the same way every time, and stock-takes run on the scanners against live records.
A line from finished goods back to purchaseEach finished stone links to the source SKU it was cut from, with yield at every stage, and each bag links to the purchase invoice it arrived on.
Origin that stays with the stoneCountry of origin and supplier declarations are kept on record, for brands that ask about responsible sourcing.
No stone promised twiceStock is reserved against each customer order, and production is planned against what is open.
Memo stock kept on the booksMemo sales and returns are tracked until each stone is sold or comes home.
Four entities on one systemGoods move between the US parent and the units in India, Sri Lanka and Bangkok with both sides recorded. Reimbursements are reconciled, P&L runs per entity and for the group, and each entity works in its own currency.
Fair pricing between entitiesTransfer pricing rules govern every move between entities, and group reports bring all four together.
Cost per piece by factoryCost builds through every stage and entity, so cost per piece can be compared factory against factory.
Treatments and certificates on recordBoth stay attached to the stone, ready for the brand and the auditor.
Brand codes and prices handled for youEach brand’s own SKUs and prices map to internal SKUs, and packing lists and invoices come straight from the order.
Performance judged on factsOutput and yield are recorded per worker, with a stage-wise stock dashboard, management analytics and stock ageing on top.

Also built in: stage-wise entry by the person doing the work in Jaipur and Sri Lanka, commercial and precision flows side by side, job work tracked out and back, photos on bags and stones, masters coded to international gemmological conventions, role-based access by entity, and barcode scanning on every bag.

Every stone traced. Every cost counted. Every entity in view.

05

When the business changed shape mid-build

The first system was designed for PRIMA Gems’ India operations. In August 2026 the group became a US parent with captive units in India, Sri Lanka and Bangkok. Goods, costs and reimbursements would now cross legal entities, and a single-country design could not carry that.

Patching it would have left a fragile system, so we chose to redesign and rebuild the application end to end around the new structure — and took it fully live across all three countries in October 2026, under three months later.

Keeping cost true while stones keep moving. In a gemstone factory, lots are constantly re-sorted, split and merged, and some stock is written off or turns out to be excess. Handled by hand, the cost stays stuck on the old record and the books drift from reality. We built cost movement into every one of those events, so value follows the stone through each split, merge, re-assortment, write-off and excess entry, in every entity.

Two countries, one way of working. Stage-wise entry had to work for production teams in Jaipur and in Sri Lanka, most of whom had always worked on paper. We kept every screen to what that person needed, backed it with barcode scanning, and trained each team on its own part of the process.

We built for the business PRIMA Gems was becoming, not the one it had been when the project started.

06

Live across four entities, audit gaps closed

MeasureResultBasis
Entities on one ERP4US parent, with captive units in India, Sri Lanka and Bangkok.
Scope change to full go-liveunder 3 monthsAugust to October 2026, live across India, Sri Lanka and Bangkok.
Users20+Sales, inventory, production, dispatch and accounts.
Earlier audit findingsansweredTraceability, reporting and inventory management, each mapped to where the system addresses it.
Stone trailinvoice → pieceYield captured at every stage.
Cost movementfollows the stoneThrough splits, merges, re-assortment, write-offs and excess stock.
Modules live5Sales, inventory, work orders, dispatch and accounts, with costing, reimbursements and P&L per entity.
Production stages tracked4Assortment, preshaping, calibration and polishing, in both factories.

How to read this

The rebuild is a strength, not a delay. The system went live on the structure PRIMA Gems actually runs today. A faster launch on the old design would have needed rebuilding within months.

The audit findings are answered, not yet re-audited. Every point from the previous audit is mapped to where the system now addresses it. The next brand audit is still ahead of us, and we are leading it. Until it has been run, this is readiness rather than a result.

Coverage, not performance. We can tell you what was built, for how many entities and users, and in what time. Cost per piece, yields by factory and planning accuracy become measurable once the system has run long enough to compare.

Who did what. We scoped, built and rebuilt the system, set up the hardware, ran the testing, trained the teams and are leading the audits. PRIMA Gems’ people in Jaipur and Sri Lanka agreed the new way of working with us and now run the business on it.

07

From implementation to partnership

The ERP is live across India, Sri Lanka and Bangkok, with more than twenty users and the group’s four entities on one system. We are leading the upcoming audits, making sure every point from the previous one is covered.

The work is now moving into a broader consulting role, using the data the system produces: comparing and improving cost per piece across the Jaipur and Sri Lanka factories, helping teams decide on what the system shows rather than on memory, improving production planning and demand forecasting across the group, and managing P&L, reimbursements and the movement of goods between the parent and its captive units.

What we will build next. A sourcing module and a CRM, and AI to remove manual entry points — creating sales orders and packing lists from a simple prompt, and checking every combination of attributes when a new SKU is created, so an incorrect SKU never enters the system.

The ERP was the foundation. Growth is the building.

08

What we now build in from day one

Let the last audit write the first requirements. Every finding from PRIMA Gems’ previous audit became a requirement before a single screen was designed, and each one was tested against before go-live.

Settle the process before the build. Because the factories’ way of working was standardised first, the August rebuild changed the structure without disrupting the floor. That is the whole reason a rebuild was affordable at all.

If your legal structure is about to change

Tell whoever is building your systems before it happens, not after. A single-entity design patched to handle four entities is fragile in exactly the places that matter — intercompany movement, transfer pricing, consolidated reporting — and the patch is usually discovered by an auditor rather than by you.

Rebuilding cost us weeks here and it was the cheaper option. The expensive version is going live on a design that has to be replaced within a year.

Measurement note. Scope, entity count, user numbers, modules and timelines are from our own project records. Previous audit findings are as recorded in the client’s earlier brand audit; the next audit has not yet been conducted, so findings are reported as addressed in the system rather than as re-audited and closed. This page reports what was built and delivered rather than operating performance.