Monthly sales
Bars show actual sales by month.
Monthly sales by brand
Top brands split by month.
Customer purchase history
Click a customer to view invoices and items purchased.
Million connection options
1. Direct API
Best route if your Million vendor can provide API endpoint, company ID, username/token and allowed modules.
2. Server database or ODBC
Good for desktop/server installations if read-only access to invoices, items, debtors and salespersons is allowed.
3. Hourly local reader
Use a small local service to read Million's exported report or database every hour, then refresh this dashboard automatically.
Target and account settings
Monthly targets
Yearly total: RM0
Create staff account
Create staff login here. If they forget password, edit the account below or use Reset Password.
Manage staff accounts
Expected sync columns: date, invoice, customer, salesperson, item, category, quantity, amount, stock_on_hand, cost.
Customer setup
Edit sector, area and assigned sales rep.
New customers from Million sync are added here automatically.
Product brand setup
Edit product brand for brand reports and filters.
New products from Million sync are added here automatically.
Sales Target Tracker