DivoraERP
DIVORA — Diamond ERP is a Laravel web app for diamond and gemstone trading, covering carat inventory, parties, purchases, sales, consignment, payments, and accounting reports.
Project overview
A diamond-focused ERP for inventory, trading, and accounting in one workspace.
DIVORA ERP is an authenticated Laravel application branded as DIVORA — Diamond ERP. It is built for diamond businesses that need stock tracked in carats, items with gemological specs such as color, clarity, cut, lab, and Rapaport rate, and money handled in INR with party-wise receivables and payables. Purchases, sales, consignment, payments, and accounting reports sit in one streamlined workspace.
What it is
An authenticated ERP for diamond trading: inventory by carat, parties, purchases and sales, consignment in/out, payment vouchers, and financial reports from one admin workspace.
Problem solved
It replaces disconnected stock books, party ledgers, and trading paperwork with a single system that understands diamond specs, carat balances, and INR receivables and payables.
Main goal
Give diamond businesses one accurate place to manage stock, trading, consignment, payments, and accounts without switching between separate tools.
Tech stack
Practical tools chosen for reliability and speed.
Frontend
- Laravel Blade
- Vite
- Tailwind CSS
- Authenticated admin UI
Backend
- Laravel 10
- PHP 8.1+
- Eloquent ORM
- Laravel Sanctum
Database
- MySQL
- Typical XAMPP setup
- nnjeim/world locations
- Party and stock masters
Operations
- Purchases & returns
- Sales & returns
- Consignment in/out
- Payment vouchers
Reports
- Party ledger
- Trial balance
- Profit & loss
- Balance sheet
Security
- Session login (/login)
- Logout flow
- Admin-style user session
- Sanctum-ready auth
Build process
A focused delivery path from problem mapping to launch.
Discovery
Mapped diamond trading workflows around carat stock, gemological specs, parties, purchases, sales, consignment, and INR accounting.
Planning
Defined accounting masters, inventory masters, voucher operations, stock views, and financial reports as connected ERP modules.
Masters
Built groups, ledger accounts, parties with location and balances, currencies, voucher types, stock groups, categories, units, and diamond stock items.
Trading Vouchers
Implemented purchases, purchase returns, sales, sales returns, consignment in/out with stock return, and payment received/given with voucher cancellation.
Stock Engine
Added stock in hand, consignment-in and consignment-out views, stock movements, available carat, and average cost tracking.
Accounting Layer
Delivered party ledger, financial overview, inventory and transaction reports, statement of accounts, trial balance, P&L, and balance sheet.
Dashboard
Surfaced receivables, payables, net outstanding, total sales/purchases, party count, and stock in carats for daily trading control.
Challenges and solutions
The important problems solved for the business.
Problem
Carat-based inventory
Solution
Designed stock around diamond carats instead of generic quantity, including available carat, average cost, and movement history.
Impact
Traders can see actual stone stock and cost without converting from a generic inventory model.
Problem
Gemological item data
Solution
Captured diamond_type, color, clarity, shape, cut, polish, symmetry, fluorescence, lab, report number, Rapaport rate, discount, price per carat, measurements, media, and location on each stock item.
Impact
Certified and loose stones stay identifiable with the specs used in real diamond trading.
Problem
Consignment stock control
Solution
Separated consignment-in and consignment-out from owned stock, with return of stock and movement tracking.
Impact
Businesses can move stones without mixing consigned inventory into owned stock balances.
Problem
Party-wise money flow
Solution
Connected parties to receivables, payables, payment vouchers, and statement of accounts in INR.
Impact
Outstanding balances stay visible against customers and suppliers instead of sitting in disconnected ledgers.
Problem
Full accounting close
Solution
Added trial balance, profit and loss, and balance sheet alongside trading reports.
Impact
The ERP supports both trading operations and accounting close in the same product.
Results and outcome
A complete SaaS foundation with measurable operational gains.
ct
stock tracked in carats, not generic units
INR
party-wise receivables and payables
6+
voucher types for purchase, sale, consignment, and payments
10+
diamond specs on each stock item
1
authenticated workspace for trading and accounts
100%
web-based Diamond ERP access
Next case study