Public technical examples and reusable ERP engineering patterns from the DuruNex ecosystem. This repository is not DuruNex ERP itself, and not the production DuruNex ERP source code.
DuruNex ERP is an enterprise resource planning platform built for mining and commodity trading, finance-intensive operations, and multi-company / holding structures — on top of a native PHP + Microsoft SQL Server stack. It covers finance, purchasing, sales, inventory, banking, approvals, authorization, and reporting as one connected system, not a collection of loosely joined screens.
- ERP-native business logic. Documents flow through a real header/line/journal chain (quotation → order → delivery → invoice → journal), not a generic form builder.
- Mining & commodity trading specialization. Element-based pricing (metals such as gold, silver, copper, lead), contract-driven pricing periods, and lot/operation tracking are first-class concepts, not bolt-on customizations.
- Multi-company / holding architecture. Tenant-level data isolation, role-based authorization, and centralized reporting across companies operating on the same platform.
- Finance-first operational control. Payments, collections, banking, checks, purchasing, and accounting are designed as one connected flow, not separate modules that need manual reconciliation.
Finance & accounting, banking & cash, purchasing, sales, inventory & warehouse, approvals & authorization, reporting, mining & commodity contracts, import/export, cost centers, and multi-company operations.
Selected, generalized, and safe examples drawn from real ERP engineering experience in the DuruNex ecosystem: SQL Server report patterns, PHP helpers, workflow documentation, an authorization model overview, and a fictional demo schema — useful for developers, consultants, and technical evaluators who want to see how DuruNex-style ERP logic is structured.
Production DuruNex ERP source code, proprietary business formulas (including mining/commodity pricing calculations), production database schema, customer data, credentials, internal endpoints, and commercial-core implementation details. See docs/open-source-scope.md for the exact boundary.
| DuruNex ERP | DuruNex ERP Toolkit (this repository) | |
|---|---|---|
| What it is | Commercial enterprise ERP platform | Public technical examples & reusable patterns |
| Source availability | Proprietary, not published | MIT-licensed example code only |
| Contains business formulas | Yes (production) | No — generalized examples only |
| Contains customer data | Yes (production) | No — fictional data only |
| Sector / use case | Why DuruNex fits |
|---|---|
| Mining & mineral trading | Element-based pricing, lot tracking, contract-driven pricing periods, cost/profitability per operation. |
| Commodity trading | Provisional and final pricing cycles, average-price methods, coefficient-based contract calculations. |
| Metals / steel trading | Purchase-cost derivation, supplier settlement flows tied to real market pricing. |
| Import / export operations | Document flow that connects purchasing, logistics, and finance across borders. |
| Multi-company / holding organizations | Tenant-isolated data with centralized, cross-company reporting. |
| Finance-intensive trading companies | Bank, check, payment, and collection flows tied directly into accounting. |
| Purchasing-heavy organizations | Approval-gated purchase workflows with authorization control. |
| Inventory / warehouse operations | Stock movement tracking connected to purchasing and sales documents. |
| Area | Status |
|---|---|
| Finance & Accounting | Available |
| Banking, Cash & Checks | Available |
| Payments & Collections | Available |
| Purchasing | Available |
| Sales | Available |
| Inventory & Warehouse | Available |
| Approvals & Authorization | Available · Toolkit example available |
| Reporting | Available · Toolkit example available |
| Mining & Commodity Contracts | Specialized |
| Import / Export | Available |
| Cost Centers | Available |
| Multi-company / Holding | Specialized · Documented |
| Document Management | Available |
"Specialized" marks capability areas where DuruNex goes beyond a generic ERP feature set. "Toolkit example available" marks areas where this repository includes a runnable, generalized example.
ERP-native business logic. DuruNex is not a generic screen collection; it directly models finance, purchasing, inventory, and sector-specific workflows as an ERP system, with documents that carry state through their full lifecycle.
Mining & commodity specialization. Processes that usually require custom development on top of standard ERP packages — element-based pricing, contract-period pricing, lot-level cost tracking — are built into the platform.
Multi-company architecture. Tenant, authorization, and data separation are designed for organizations that run more than one company on the same platform.
Finance-first operational control. Payment, collection, banking, check, purchasing, and finance flows are managed as one connected system rather than disconnected modules.
Extensible architecture. Built on PHP and Microsoft SQL Server, with a controlled, modular approach to integration and extension.
- PHP helper examples
- Microsoft SQL Server reporting queries (SELECT-only)
- Generalized ERP workflow documentation (approvals, purchasing, inventory transfer)
- Authorization and permission model overview
- Multi-company data-isolation pattern
- A small fictional demo schema
- ERP developers and consultants evaluating DuruNex
- PHP developers working with Microsoft SQL Server
- Technical evaluators researching mining / commodity-trading ERP systems
- Organizations researching multi-company / holding ERP architecture
Active development. Current focus: documentation quality, safe SQL report examples, PHP helper functions, and workflow templates.
docs/ Project & architecture documentation
examples/sap-b1-mssql-reports SQL report examples (SELECT-only)
examples/php-helpers Small PHP helper examples
examples/workflows Business workflow examples
examples/finance Generic finance/GL query examples
examples/banking Generic banking/cash reconciliation examples
examples/approvals Approval-state check examples
examples/inventory Inventory/warehouse movement examples
examples/purchasing Purchasing document flow examples
examples/commodity Generic commodity calculation examples
examples/mining Generic lot/operation tracking examples
examples/multi-company Tenant-aware query pattern example
examples/reporting SELECT-only reporting patterns
demo/ Fictional demo schema (DemoCompany, DemoInvoice, ...)
src/Helpers Reusable helper classes
src/Examples Example service classes
The SQL files in this repository are report examples, written as SELECT queries. Test on a copy or test database before use. No DELETE, UPDATE, INSERT, TRUNCATE, posting, or accounting-correction script is included.
The DuruNex ecosystem also includes ongoing enterprise AI and intelligent application research, developed independently from the ERP platform.
- Official site: durunex.com
- Technology & publishing: durubot.com
The code in this repository is licensed under the MIT License — scoped to this public toolkit repository only. The DuruNex ERP commercial product and its proprietary source code are not licensed under this repository's license and are not covered by it. See NOTICE.md for details.