Building Materials Distributor Management System for Malaysian Business

The DMS tracks stock at each tier with full lineage. Primary sales (importer to wholesaler), secondary sales (wholesaler to hardware shop), and tertiary sales (hardware shop to applicator or homeowner) each report separately. Brand teams see which channel layer is moving stock and which is sitting on inventory. Channel-stuffing patterns surface before the next allocation cycle hides them. Each tier carries its own pricing, credit terms, and scheme eligibility.

Pricing trees configure per channel class: hardware shop pricing, branded showroom pricing, DIY retail chain pricing, direct project supply pricing, and wholesaler pricing. Trade discount structures (off-invoice, on-invoice, post-invoice claim) attach to each class. Project-specific overrides for high-rise condo, commercial fit-out, and government housing projects, special seasonal bonuses, and credit terms also vary by class. The order screen applies the right combination automatically.

Project orders pull from project-allocation pools with slab-based bulk pricing tied to volume. Hardware shop reorders pull from standard inventory with reorder pricing. The DMS keeps the two pools separate so a busy project does not drain hardware shop allocation. Quantity-discount slabs apply automatically. Order screens show pricing transparently to the rep so quotes are accurate at the site or counter.

Project orders capture delivery slot, site address, contact person, unloading instructions, and access constraints (gated community, restricted truck size, weekend-only delivery, high-rise crane requirement). The DMS schedules dispatches against these constraints and notifies the site contact ahead of arrival. Driver app captures proof of delivery with photo. Discrepancies, partial deliveries, or rejection cases route to a claim workflow tied to the project record.

Breakage and damage returns initiate from dealers or sites with photo evidence at the point of failure, original invoice reference, batch number, and failure cause classification (in-transit damage, handling, manufacturing defect, dropped during installation). The claim routes through validation. Approved claims generate credit notes and replacement dispatches in a single transaction. Tile, ceramic, sanitaryware, and glass categories carry higher breakage rates and the workflow accounts for that with appropriate caps and audit trails.

Cement bags, paint cans, adhesive packs, and other shelf-life sensitive SKUs carry batch and manufacturing date data from GRN onwards. FIFO allocation dispatches older batches first. Near-expiry alerts trigger weeks in advance so brand teams can run targeted discount campaigns or warehouse transfers before writeoff. Lot traceability also supports quality recall scenarios for affected batches.

Quantity-discount schemes layer on top of base pricing with slab-based bonuses. Project orders trigger automatic slab application based on order quantity. Special project schemes (high-rise condo bonuses, commercial fit-out free-goods, government housing volume rebates) layer on top with eligibility validation at the order stage. ROI per scheme tracks in real time so brand teams can adjust before the cycle closes.

Direct project supply accounts often work on extended payment terms tied to project milestones (handover, occupancy certificate, retention release) while hardware shops and showrooms may run on shorter cycles. Credit terms set per account in the agreement master apply automatically. Ageing dashboards highlight accounts approaching the limit. Reminder workflows trigger before due dates. JBP-time exception reports show drift from agreed payment behaviour.

Yes. REST APIs support bidirectional sync with SAP, Oracle, Microsoft Dynamics, Tally, and existing distributor or hardware shop ERP systems. Sales orders, invoices, dispatch notes, GRN, returns, batch records, and payment records flow between the DMS and the ERP without manual rekeying. SFTP file feeds support bulk daily syncs of master data, batch inventory, and ledger postings.

KAMs see dealer-wise order book, secondary and tertiary sell-out, range compliance, scheme ROI, and JBP-relevant metrics. Channel ops sees order throughput, site delivery on time, breakage rates, and exception trends. Finance sees credit ageing per account, trade investment running total, breakage cost exposure, and reconciliation between dispatches and dealer remittance. Drill-downs go from country to dealer to project to batch-level transaction.