What an ERP for a marble and stone factory needs to track
Generic ERP systems assume a product is a SKU with a quantity. In a marble or stone factory in Lahore, Karachi or Peshawar the product is a slab with dimensions that change as it is cut, sized and polished. This article explains what that means for the software and gives a checklist you can use to evaluate any system, including ours.
The core problem: a product is a dimension, not a count
In most industries inventory is simple: 400 units of item A. In stone, the unit is a block, slab or tile described by length, width, thickness and finish. The same block becomes several slabs, each slab becomes tiles of different sizes, and a single customer order mixes sizes from different blocks. Pricing is per square foot or per piece depending on the product, and wastage during processing is normal and must be tracked, not hidden.
Systems designed for countable products either force factories to create thousands of fake SKUs or push the real work back into spreadsheets. Both outcomes defeat the purpose of an ERP.
What the data model must support
1. Dimensions on every line
Quotations, orders, deliveries and invoices should carry dimensions and finish on each line and compute area and price automatically. When a salesperson quotes 120 pieces of 24 by 24 inch polished tiles, the order, the production plan and the invoice should all speak that language.
2. Processing stages as inventory states
Stock is not one number. Material sits in distinct states: raw blocks received, slabs cut, pieces sized, pieces polished, finished goods ready to dispatch. A useful system tracks movements between states, including yield and wastage at each step, so managers can see where material and margin are lost.
3. Deliveries that update ledgers
A delivery is a financial event as well as a logistics one. Dispatching an order should produce the delivery note and receipt, reduce finished stock and post to the customer's ledger. Payments received later reconcile against that ledger. If these steps live in different tools, reconciliation becomes a monthly argument.
4. Customer and supplier ledgers with product history
Owners want two questions answered instantly: what does this customer owe us, and what do they usually buy. Account profiles should show complete ledgers alongside delivery histories with quantities and prices, which also tells sales which products a client prefers.
5. Finance views that match how owners think
Earnings and expenses in real time, profit and loss for a period, and a balance sheet are the minimum. The numbers must come from the operational data, not from a separate manual entry, or they will drift apart within a quarter.
6. People and payroll
Factories employ shift workers, piece-rate workers and salaried staff. Attendance, departments and payroll belong in the same system because labour is a direct production cost and because owners want HR metrics next to output.
7. Access control per role
Owners see everything. Accountants see finance. Production supervisors see stock and processing. Salespeople see their customers and orders. Granular permissions are a security requirement and a usability one; nobody wants screens they do not need.
A checklist for evaluating any system
- Can an order line carry length, width, thickness, finish and compute area and price?
- Can inventory be viewed by processing stage, with wastage recorded per stage?
- Does a delivery automatically generate documents and post to the customer ledger?
- Are profit and loss and balance sheet generated from operational transactions?
- Can attendance and payroll be managed for mixed pay types?
- Are permissions configurable per module and action?
- Can it run on tablets on the factory floor and on the owner's phone?
- Who owns the data, and how do you export it if you leave?
How StoneCloud approaches this
We built StoneCloud ERP for a marble factory that was running on paper ledgers and spreadsheets. The modules map directly to the list above: accounts with ledgers and product history, orders and quotations with dimensions, inventory with processing submodules for sizing, polishing and sectioning, deliveries with instant PDFs, finance reporting, HR and payroll, and access management. It is used daily in Pakistan and is available hosted or installed on your own server.
If your factory is evaluating software, we are glad to walk through your current process and show how it would look in StoneCloud, or to advise on a custom system if your needs are different.
Working on something similar?
Tell us where you are. We are happy to compare notes before there is any project to talk about.