Macrobase System
Product · 33 DMS

From warehouse to dealer shelf, one ledger.

Distribution management for brand owners and distributors — sales, purchasing, inventory, AR and a dealer portal on one system, with ERP integration flowing both ways.

Book a demo View the architecture
Dealer portal iCommission engine ERP integration
33crm.com/dms
Outlets
1,240
across 6 branches
Stock value
RM 2.4m
in trade
AR overdue
RM 86k
30+ days
Dealer orders
312
this week
Dealer orders · 14 days Live
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Channel mix · YTDSales value
Modern trade 38% General trade 24% Wholesale 20% Online 18%
Stock value vs target14 days
312
Orders / wk
RM 486k
Order value
96.4%
Fill rate
2.1 d
To invoice
Sales order to invoiceSO → DO → INV
DocDealerValueStatus
SO-2211PD MartRM 12,400Invoiced
SO-2212Kim's GroceryRM 4,280Credit check
SO-2213City ConvenienceRM 6,950Pending
Sales order to invoice, DO, credit and debit notes, payments and refunds — with credit-limit and overdue approval built in.
18
Open POs
RM 92k
To receive
3
Principals
7.2 d
Avg lead time
Purchase request to principalGRN 4/6
DocPrincipalValueStatus
PO-1182Sunrise FMCGRM 28,400GRN done
PO-1183Pacific DistributorsRM 14,600In transit
PO-1184Maple TradingRM 9,200Approved
Purchase order or request to principal, purchase invoice, goods receive note, returns, supplier payment and refund.
6
Warehouses
RM 2.4m
Stock value
34
Reorder alerts
12.8 d
Avg shelf days
Dealer stock · KL NorthDMS
SKUWarehouseDealerQtyDOH
SH-200KL MainPD Mart8411
SH-200KL MainKim's Grocery264
SH-110PenangCity Convenience13219
SH-110PenangJaya Mini Market476
Multi-UOM, batch, lot and serial number tracking, min/max levels, reorder alerts, auto-reorder schedules and shelf-life policy.
RM 86k
Overdue 30+
214
Debtors
23
Over 60 days
91.2%
Collected
Debtor aging · KL branch2 overdue
DebtorCurrent30+60+90+
PD MartRM 8,200RM 4,100——
City ConvenienceRM 3,600RM 2,800RM 1,400RM 600
Jaya Mini MarketRM 5,900RM 1,100——
Debtor aging, statements and payment allocation across multiple debtor codes — one HQ payment split across many store codes.
RM 42k
Payout / mo
86
Reps
RM 486k
Sales base
9.2%
Avg rate
Commission summaryVerified
RepTierEntitledStatus
Azman H.GoldRM 2,840Paid
Fatin R.SilverRM 1,960Pending
Wei Ming C.BronzeRM 1,320Review
Configurable data sources, formulas and transformations turn sales data into detail and summary payouts — with verification of results.
In action

One order, tracked from dealer to shelf.

Order, pick, dispatch, delivered — every step writes back to the same ledger, so head office always knows where the goods are.

Orders today
87
via dealer portal
Order value
RM 126k
captured
Outlets ordering
61
of 214 debtors
Suggestion take-up
78%
auto-reorder
Incoming dealer orders Portal live
DocDealerValueStatus
SO-2211PD MartRM 12,400Created
SO-2212Kim's GroceryRM 4,280Credit check
SO-2213City ConvenienceRM 6,950Approved
Dealers log in for online purchase requests, order tracking, DO status, returns and statements — with stock suggestion and replenishment.
Pick lines
342
this wave
To pick
28
remaining
Bin accuracy
99.2%
lot / serial
Auto-reorder
34
alerts today
Pick list · KL Main warehouseWave 4 / 6
BinSKULotQtyStatus
A-12SH-200L-882184Picked
B-03SH-110L-8774132Picked
C-09SH-200L-882126Pending
Multi-UOM, batch, lot and serial number tracking with min/max levels, reorder alerts and shelf-life policy at the warehouse.
Vans
12
on route
DOs today
86
generated
On-time
94%
last 30 days
Routes
6
planned
Dispatch manifestKL North
DODealerValueStatus
DO-1182PD MartRM 12,400Dispatched
DO-1183Kim's GroceryRM 4,280Loading
DO-1184City ConvenienceRM 6,950Ready
Sales order to invoice, delivery order, credit and debit notes — with consignment delivery and billing running in one flow.
POD received
82
this week
On-time
94%
delivered
Returns
RM 3.1k
credit noted
Stock synced
Live
to ERP
Proof of delivery Synced
DODealerValueStatus
DO-1182PD MartRM 12,400Signed
DO-1183Kim's GroceryRM 4,280In transit
DO-1184City ConvenienceRM 6,950Pending
Proof of delivery, consignment tracking and returns write stock and AR back to the same ledger — ERP integration flowing both ways.
Architecture

Three levels, one data flow.

DMS is built to run across the whole chain — head office, distributors and the field — each level keeping its own speed and its own reporting.

LEVEL 1Head office

Centralized ERP + CRM

Deployed as a centralized repository and data warehouse. Data is transformed into an analytical structure for high-speed analysis and data mining, with its own reports and 3rd-party integration.

LEVEL 2Distributor

Standalone ERP + CRM

Each distributor runs its own system in a transactional structure — high-speed data input and update — with its own customized reports and 3rd-party software integration.

LEVEL 3Field force

Mobile sales force CRM

Mobile SFA for sales people and merchandisers, a dealer purchase request portal and field services CRM — all syncing through web API and I/O script to the levels above.

Capabilities

Every module a distribution business runs.

Sales, purchasing, inventory, receivables, commission and a dealer portal — deep on their own, consistent together.

Sales module

Sales order to invoice, delivery order, credit and debit notes, payments and refunds — with approval workflows on credit limit and overdue.

Purchasing

Purchase order or request to principle, purchase invoice, goods receive note, returns, supplier payment and refund.

Inventory control

Multi-UOM, batch/lot and serial number tracking, min/max levels, reorder alerts, auto-reorder schedules and shelf-life policy.

Dealer & supplier portal

Dealers log in for online purchase requests, order tracking, DO status, returns and statements — plus stock suggestion and replenishment.

AR & debtor management

Debtor aging, statements and payment allocation across multiple debtor codes — one HQ payment split across many store codes.

iCommission engine

Configurable data sources, formulas and transformations that turn sales data into detail and summary payouts — with verification of results.

Deep dive · Trade offers & approvals

Control at every handoff.

Sales documents move with financial control built in — approvals, trade offers and tax codes configured once, applied everywhere.

  • Sales order to invoice with credit-limit and overdue approval, plus email notification
  • Mix-and-match trade offer configuration — FOC, PWP, minimum quantity, flexible pricing ranges
  • Auto GST tax code assignment to products, with multiple branches and location codes
  • Customer creation routed from wholesaler through the sales executive to manager approval
33crm.com/dms/sales/approvals
Pending approvals · KL branch2 overdue
DocDealerValueStatus
SO-2211PD MartRM 12,400Credit check
PR-0932City ConvenienceRM 4,280Approved
SO-2218Jaya Mini MarketRM 6,950Pending
33crm.com/dms/integration/flow
ERP ↔ DMS data flowSynced
To market sales invoice (HQ)ERP → DMS
Purchase request / orderDMS → ERP
Purchase return / short supplyDMS → ERP
In-market sales (daily closing)DMS → ERP
Deep dive · Integration

Built to talk to the systems you own.

DMS ships with multiple integration paths — ready APIs, file-based exchange and connectors to the ERP and accounting software distributors already run.

  • Ready JSON and XML web API, configurable CSV import/export and web hooks
  • Scheduled file transfer over integrated SFTP for secure, hands-free sync
  • Accounting connectors — AS400, AutoCount, SQL Accounting, and Tier 1 ERP via e-Bridge or MuleSoft
  • Customized integration with MS SQL Server, web services or API per specification
Case studies

Running across national distribution networks.

TOP MALAYSIA MILK POWDER FMCG 5–10% revenue

Centralized DMS / SFA

Inventory and billing centralized with consignment delivery tracking across the distribution chain.

  • Centralized inventory control, purchase request and billing
  • Consignment delivery and billing in one flow
TOP MALAYSIA LUBRICANT DISTRIBUTORBack-office data

Harmonized demand data

Clean, harmonized demand data flowing into back-office applications with full traceability and compliance documentation.

  • Status visibility between suppliers and retail stores
  • Improved material and capacity utilization

See DMS flow through your own distribution chain.

We'll walk through sales, inventory, the dealer portal and ERP integration using your products and outlets.

Book a demoSee 33 SFA