XERPIUM GOLD

Summary

Gold Mining & Refining Ecosystem

XERPIUM GOLD is a complete ERP solution for the gold mining & refinery industry — from block exploration, ore production, grade stockpile, assay lab, smelting, bullion tracking, to sales & accounting.

MINE

Site & Block

ORE

Production & Stockpile

ASSAY

Fire Assay & XRF

REFINERY

Smelting & Bullion

⚙

EKUIP

Heavy Equipment

🛡

HSE

Safety & Permit

💰

TRADING

Price Board & Sales

📈

DASHBOARD

KPI Real-time

Master Data

Gold Mining Master Data

Structured master data for all mining entities — site, block, ore type, cost center, shift.

🏛

gold.mine.site — Mine Site

Site Code — Unique per company, GPS coordinates (lat/lon)
Area — Total area (ha), province, district, address
Permit Management — Permit no, type (IUP/IUPK/IPR), issue date, expiry, days remaining (computed)
State — Active, Suspended, Closed (with workflow actions)
Stats — Block count, total reserve tons (computed from blocks)

🏢

gold.mine.block — Block / Pit

Block Code — Unique per site, sequence, area (ha), depth (m)
Mining Type — Open Pit, Underground, Alluvial
Geological Data — Geological zone, ore type, estimated reserve (ton)
Grade Estimation — Grade g/ton, estimated gold kg computed: reserve * grade / 1000
Status — Exploration → Development → In Production → Depleted

📜

gold.ore.type — Ore Type

Ore Classification — Based on mineralogy & processing method
Reference — Used in blocks and production orders
Processing Method — Processing method reference (smelting, CIL, CIP, heap leach)

💰

gold.cost.center + gold.shift

Cost Center — Analytic account per site/block for cost tracking
Shift Management — Day/Night/Evening shift configuration
Linked — Cost center linked to analytic account, shift to production order

📈

Master Data Views — Mine Site, Block, Ore Type, Cost Center

Form with GPS map, permit timeline, reserve & grade calculation

Production

Production & Ore Management

Mine production flow from planning to stockpile — shift-based, equipment tracking, grade analysis.

Draft

→

In Progress

→

Done → Stockpile

🚚

gold.production.order — Mining MO

Auto-sequence — PO/2026/00001, unique per company
Site & Block — Linked to mine site + block (in production status)
Shift & Date — Per shift, production date, responsible employee
Planning — Planned tons vs actual tons, achievement % computed
Grade — Avg grade g/ton, estimated gold content computed: actual_ton * grade * 1000
Fuel — Total fuel liter computed from production lines
Stockpile Link — Stockpile target, auto-add tons when done

📄

gold.production.line — Production Detail

Equipment — gold.equipment linked, domain per site + active
Operator — hr.employee assignment, start/end time
Duration — Auto-computed hours from start-end datetime
Output — Tons extracted (required), fuel used liter
Notes — Per-line notes for operational issues

📦

gold.ore.stockpile — Ore Stockpile

Stockpile Per Site — Capacity ton, current tonnage
Grade Tracking — Weighted average grade (g/ton)
Auto Update — _add_tons method called when production is done
Movement — In/out tracking, reconciliation
Quality — Average grade recomputed after each addition

🔧

gold.equipment — Heavy Equipment

Types — Excavator, Dump Truck, Crusher, Mill, Pump, Loader, Drill Rig, Bulldozer, Conveyor
Registry — Asset code, brand, model, year, plate no, serial/engine no
Status — Active, Under Maintenance, Idle, Retired
Meters — Current hours, purchase value, residual, insurance expiry
Maintenance — Next maintenance date, maintenance history (one2many)
Performance — Total maintenance cost, total fuel, total operating hours (computed)

🚚

Production Order Form — Lines, Equipment, Grade, Fuel Tracking

gold.production.order with inline editing of production lines, grade calculator, fuel summary

Quality

Assay Lab & Quality Control

Integrated assay laboratory — sampling, multiple test methods, purity certification, structured workflow.

Draft

→

Submitted

→

Analyzed

→

Reported

🔬

gold.assay.sample — Sample Assay

Auto-sequence — Sample no, linked to site + block
Sample Types — Chip, Core, Grab, Channel, Composite
Source Types — Ore/Rock, Bullion, Process Stream, Tailings, Soil
Collection — Date collected, collected by (employee), location, depth range
Weight — Sample weight (g) for reference
Results — One2many gold.assay.result, result count, best grade computed

📊

gold.assay.result — Assay Result

Test Methods — Fire Assay, XRF, Wet Chemistry, AAS, ICP-OES
Elements — Gold PPM, Silver PPM, Copper %, Iron %, Sulfur %
Grade — Result grade g/ton, auto-computed from element values
Analyst — Employee assigned as analyst, analysis date
State — Draft → Done → Verified

📄

gold.purity.certificate — Purity Certificate

Auto-sequence — Certificate no unique
Purity — Purity percent, fineness label computed (999/995/960/916/750/585/375)
Weight — Weight in grams, troy oz (auto-computed: g / 31.1035)
Issuance — Issue date, valid until, issued by, issuing lab
State — Draft → Issued → Revoked
Linked — To refinery job output bullion

🔥

Sample Test Methods

Method	Application	Accuracy
Fire Assay	Gold & precious metals	High (0.01 g/ton)
XRF	Multi-element screening	Medium
Wet Chemistry	Base metals, copper	High
AAS	Trace elements	Very High
ICP-OES	Multi-element (30+ elements)	High

🔬

Assay Lab Dashboard — Sample List, Results, Purity Certificates

Kanban view sample status, result table with grade, certificate generation

Refinery

Refinery & Bullion Management

Gold refining process from ore to bullion bars — with recovery rate, loss tracking, purity certificate.

Draft

→

Processing

→

Quality Review

→

Completed

🔥

gold.refinery.job — Refinery Job

Auto-sequence — REF/2026/00001, unique per company
Process Types — Smelting, CIL, CIP, Heap Leaching, Amalgamation, Electrolysis/Wohlwill
Input Tracking — Input ore ton, input grade g/ton, theoretical gold input computed: ore * grade * 1000
Output Tracking — Gross bullion output (g), output purity (999/995/960/916/750/585/375)
Fine Gold — Fine gold computed: bullion * purity_factor
Loss & Recovery — Slag (g), other loss (g), total loss, recovery rate %, loss rate %
Certificate — Linked gold.purity.certificate

💰

gold.bullion.stock — Bullion Stock

Bar Identity — Bar no, purity, weight (g), fine gold (g), troy oz
Linked Job — Many2one to refinery job
Status — Available, Reserved, Sold
Location — Warehouse/stock location, vault storage
Certificate — Linked purity certificate for each bar

Refinery KPI — Recovery Rate Calculation

        # Theoretical Gold Input

        input_total_gold_g = input_ore_ton × input_grade_g_ton × 1000

        # Fine Gold Output

        purity_map = {'999': 0.999, '995': 0.995, '960': 0.960, '916': 0.916, '750': 0.750, '585': 0.585, '375': 0.375}

        output_fine_gold_g = output_bullion_g × purity_map[output_purity]

        # Loss & Recovery

        total_loss_g = input_total_gold_g - output_fine_gold_g - slag_g - other_loss_g

        recovery_rate = min(output_fine_gold_g / input_total_gold_g × 100, 100.0)

        loss_rate = max(0.0, 100.0 - recovery_rate)

Purity Grades & Karat

Karat	Purity %	Fineness
24K	99.9%	999
24K (min)	99.5%	995
23K	96.0%	960
22K	91.6%	916
18K	75.0%	750
14K	58.5%	585
9K	37.5%	375

Refinery Process Types

Smelting — Traditional furnace smelting, >95% recovery
CIL — Carbon-in-Leach, 90-97% recovery for oxide ores
CIP — Carbon-in-Pulp, 90-95% recovery
Heap Leach — Low-grade ore, 50-80% recovery
Amalgamation — Mercury-based, 60-90% recovery
Electrolysis — Wohlwill process, 99.99% purity

🔥

Refinery Job Form — Input/Output, Recovery Rate, Bullion Production

gold.refinery.job with purity selector, auto-compute fine gold, loss analysis, certificate link

Trading

Gold Trading & Price Board

Daily price board, spot price tracking, gold sales with real-time price integration.

💰

gold.price.board — Price Board

Date & Purity — Price per date per purity (999, 995, 960, 916, 750, 585, 375)
Prices — Buy price/gram, sell price/gram, spread (computed)
Spot Reference — Spot USD/troy oz, USD/IDR rate, Spot IDR/gram (computed)
Source — Manual Entry, API/Feed, Calculated
Unique — Per date + purity + company unique constraint
API Method — get_latest_price(purity, company_id) to fetch the latest price

📄

gold.sale.order — Gold Sales

Customer — Buyer info, linked to res.partner
Product — Bullion bar or fine gold
Pricing — Price from price board, purity-based
Weight — Gold weight, fine gold, troy oz conversion
Invoice Integration — Account.move for transactions

Alur Gold Trading

1 Set price board: gold.price.board → buy/sell per purity

2 Create quotation: gold.sale.order → select bullion + purity

3 Invoice & payment: account.move → register payment

4 Update stock: bullion status → sold

💰

Gold Price Board & Sales Form

Price board with spot reference, auto-calculated spread, bullion inventory status

HSE

Health, Safety & Environment

Integrated HSE system — incident reporting, safety inspection, permit to work for gold mining.

🛡

gold.hse.incident — Incident Report

Types — Personal Injury, Near Miss, Property Damage, Environmental, Fire, Vehicle, Chemical Spill, Structural
Severity — Low, Medium, High, Critical
Investigation — Root cause analysis, corrective action, preventive action
Impact — Lost time days, first aid, medical treatment, hospitalization
Witnesses — Employee witnesses, photos/evidence attachments
State — Draft → Reported → Investigating → Closed

📝

gold.safety.inspection + Permit

Safety Inspections — Daily/weekly/monthly checklist, score %
Permit to Work — Hot work, confined space, working at height, excavation
PTW Validity — Permit start/end, area, responsible person
Environmental — Waste management monitoring, reclamation tracking

Analytics

Gold Mining Dashboard & KPIs

Real-time analytics dashboard to monitor production, refinery, assay, and bullion trading.

PROD

Orders Today

GRADE

Avg g/ton

RECOV

Recovery Rate

BULL

Bullion Stock g

Gold Mining KPI Widgets

Widget	Metric	Source
Production Orders	Count by state, by site	gold.production.order
Achievement %	Actual ton / planned ton gauge	gold.production.order
Ore Grade Trend	Avg grade g/ton per month (line)	gold.production.order
Refinery Recovery	Recovery rate % per job (bullet)	gold.refinery.job
Bullion Inventory	Total g by purity (stacked bar)	gold.bullion.stock
Pending Assays	Sample count by state (funnel)	gold.assay.sample
Equipment Status	Active/maintenance/idle count (pie)	gold.equipment
HSE Incidents	Count by type, severity (bar)	gold.hse.incident

AI Assistant — Gold Mining Tools

get_gold_price — Gold price per purity (999, 995, etc.)
get_production_summary — Ore production summary per site
get_refinery_output — Refinery output per period
get_bullion_inventory — Inventory bullion per purity & status
get_pending_assays — Assay samples pending analysis
get_top_gold_buyers — Top gold buyers
create_gold_sale_quotation — Create a gold sales quotation

Chart Types Available

tile line bar bar_h area pie doughnut scatter radar funnel gauge bullet map list stacked_bar waterfall

📈

Dashboard Studio — Gold Mining KPI

Production Achievement, Ore Grade Trend, Refinery Recovery Rate, Bullion Inventory by Purity

Accounting

Gold Mining & Refinery Accounting

Gold mining-specific Chart of Accounts with automatic journal flow from production and refinery to bullion sales.

Key Accounts — Gold Mining

Account	Tipe	Function
Ore Inventory — Run of Mine	Asset	Value of ore in stockpile
Work in Progress — Refinery	Asset	Gold in refining process
Bullion Inventory	Asset	Value of pure gold bullion
Mining Revenue	Revenue	Gold sales revenue
Mining Operating Cost	Expense	Mine operating costs
Refinery Cost	Expense	Refining costs
Depletion Expense	Expense	Natural resource depletion
Royalty Payable	Liability	Royalty obligation to the government

Mining Accounting Features

Cost Center per Site — Analytic account per site/block
Auto-Journal Production — Automatic journal when ore is moved to stockpile
Refinery Costing — Refinery costs capitalized to bullion inventory
Revenue Recognition — When bullion is sold, revenue + cost matching
Royalty Calculation — Royalty % of revenue to the government
Multi-Company — Multi-site operations with separate companies

💰

Chart of Accounts — Gold Mining & Refinery

COA with groups: Mining Assets, Bullion Inventory, Mining Revenue, Royalty & Tax

Ecosystem

Cross-Module Integration

Gold Mining & Refinery fully integrated with the entire XERPIUM ecosystem.

💰

Gold ↔ Accounting

Gold mining COA, automatic production-to-stockpile GL
Bullion sales revenue, cost matching
Analytic per site/block for cost tracking

📦

Gold ↔ Inventory

Stockpile ore inventory, bullion stock tracking
Spare part equipment inventory
Material request for consumables

🔗

Gold ↔ Purchase

PO for chemicals (cyanide, mercury, acids)
PO spare part equipment
Purchase requisition from production order

👥

Gold ↔ HR

Operator assignment, lab analyst, technician
Shift scheduling, attendance tracking
HSE training & certification tracking

📈

Gold ↔ Dashboard

vit_dashboard_gold_mining — KPI end-to-end
Dashboard Studio: 19 chart types
AI auto-generate dashboard & insight

🤖

Gold ↔ AI Assistant

7 AI tools specific to gold mining
Check gold price, production, refinery, inventory
Create a quotation via natural language

⚙

Gold ↔ Quality

Assay sample & result integration
Purity certificate linked to refinery job
Quality review stage before refinery completed

🔗

Gold ↔ Dynamic Stage

Configurable workflow for production & refinery
Python hooks, server actions, RBAC
Auto-sync stage ↔ native state

Comparison

Why XERPIUM Gold Mining?

Aspect	Manual / Spreadsheet	XERPIUM Gold Mining
Site & Block Data	✗ Separate files	✓ Structured, GPS, permit tracking, reserve calculation
Production Tracking	✗ Daily report manual	✓ Shift-based, planned vs actual, equipment, grade
Ore Stockpile	✗ Manual grade calculation	✓ Weighted avg grade, auto-update from production
Assay Lab	✗ Separate lab results	✓ Sample workflow, 5 test methods, grade auto-compute
Refinery	✗ Manual recovery calculation	✓ 6 process types, auto recovery rate, loss tracking
Bullion Inventory	✗ Manual stocktake	✓ Per bar, purity, troy oz, status available/reserved/sold
Price Board	✗ Manual pricing by phone	✓ Buy/sell per purity, spot reference, spread auto
Dashboard & KPI	✗ None	✓ Real-time 8+ KPI, AI-powered dashboard
AI Assistant	✗ Not available	✓ 7 gold-specific AI tools
HSE	✗ Manual books	✓ Incident, inspection, permit to work digital
License	Paid per module	SaaS / On Premise — all included

Portfolio

XERPIUM Industry Portfolio

Industry	Module	Dashboard	Report
Inventory & WMS	275+	✓	✓
Manufacturing	230+	✓	✓
Purchase	105	✓	✓
HR & Payroll	29	✓	✓
Aerospace	10	✓	✓
Accounting	9	✓	✓
University	9	✓	✓
Distribution	8	✓	✓
Koperasi	8	✓	✓
Retail & POS	7+	✓	✓
Gold Mining & Refinery	7	✓	✓
Aviation	6	✓	✓
Coal Mining	6	✓	✓
Hospital & Pharmacy	6	✓	✓
Hajj & Umrah Travel	6	✓	✓
Logistics	5	✓	✓
Hotel & Property	5	✓	✓
Beauty Clinic	5	✓	✓
Rental	4	✓	✓
Livestock	4	✓	✓
Fishery	4	✓	✓
Software House	4	✓	✓
Event Organizer	4	✓	✓
Satellite City	2	✓	✓
Education Foundation	2	✓	✓
Food & Beverage	1	✓	✓
Civil Construction	1	✓	✓
Garment	1	✓	✓
Agriculture	1	✓	✓
Theme Park	1	✓	✓
Data Center / IT	1	✓	✓
Palm Oil	1	✓	✓
Feedmill	1	✓	✓
Building Management	1	✓	✓
Auditor	1	✓	✓

XERPIUMGOLD

Gold Mining & Refining Ecosystem

Gold Mining Master Data

gold.mine.site — Mine Site

gold.mine.block — Block / Pit

gold.ore.type — Ore Type

gold.cost.center + gold.shift

Production & Ore Management

gold.production.order — Mining MO

gold.production.line — Production Detail

gold.ore.stockpile — Ore Stockpile

gold.equipment — Heavy Equipment

Assay Lab & Quality Control

gold.assay.sample — Sample Assay

gold.assay.result — Assay Result

gold.purity.certificate — Purity Certificate

Sample Test Methods

Refinery & Bullion Management

gold.refinery.job — Refinery Job

gold.bullion.stock — Bullion Stock

Refinery KPI — Recovery Rate Calculation

Purity Grades & Karat

Refinery Process Types

Gold Trading & Price Board

gold.price.board — Price Board

gold.sale.order — Gold Sales

Alur Gold Trading

Health, Safety & Environment

gold.hse.incident — Incident Report

gold.safety.inspection + Permit

Gold Mining Dashboard & KPIs

Gold Mining KPI Widgets

AI Assistant — Gold Mining Tools

Chart Types Available

Gold Mining & Refinery Accounting

Key Accounts — Gold Mining

Mining Accounting Features

Cross-Module Integration

Gold ↔ Accounting

Gold ↔ Inventory

Gold ↔ Purchase

Gold ↔ HR

Gold ↔ Dashboard

Gold ↔ AI Assistant

Gold ↔ Quality

Gold ↔ Dynamic Stage

Why XERPIUM Gold Mining?

XERPIUM Industry Portfolio