DASHBOARD

Total Revenue
R 14.2M
+12.3% vs last period
Active Customers
847
+23 new this month
Open Orders
156
18 overdue
Stock Turnover
4.2X
+0.3 vs last quarter
Revenue Trend
Monthly revenue — last 12 months (ZAR)
Revenue by Region
Geographic distribution
Top 10 Customers
Year-to-date revenue
Order Pipeline
Current order status breakdown

Recent Alerts

AlertSeveritySourceTime
Customer CUS-0412 exceeded credit limit (R 250,000)HighCredit Management2 hours ago
Stock level below reorder point: SKU-8821 (Umbrella Frame XL)MediumInventory5 hours ago
Sales order SO-29184 — delivery overdue by 3 daysMediumLogistics6 hours ago
New customer onboarded: Umbrella Distributors Cape TownInfoCRM1 day ago
Total Customers
847
+2.8% growth
Active (last 90d)
623
73.6% of total
Avg Order Value
R 16,840
+5.1%
At Risk
34
No orders in 60+ days

Customer Master Data

Source: x3MasterData.customer
CodeCompanyCountryCurrencyTypeRevenue YTDStatus
CUS-0001Umbrella Corp JohannesburgSouth AfricaZARCustomerR 2,340,000Active
CUS-0015Cape Shade SolutionsSouth AfricaZARCustomerR 1,890,000Active
CUS-0023Durban Outdoor LivingSouth AfricaZARCustomerR 1,420,000Active
CUS-0044Namibia Sun Protection LtdNamibiaNADCustomerR 980,000Active
CUS-0067Botswana Leisure ImportsBotswanaBWPCust / SupplierR 756,000Active
CUS-0089Pretoria Patio WorldSouth AfricaZARCustomerR 650,000Watch
CUS-0102Mozambique Resort SuppliesMozambiqueMZNCustomerR 540,000Active
CUS-0118Bloemfontein Garden CentreSouth AfricaZARCustomerR 420,000At Risk
Orders This Month
89
+14% vs last month
Total Value
R 3.8M
+8.2%
Avg Fulfillment
3.2 DAYS
-0.5 days improved
Return Rate
1.8%
-0.3% improved

Recent Sales Orders

Order #CustomerDateItemsValueStatus
SO-29201Umbrella Corp JHB2026-03-2812R 184,500Processing
SO-29198Cape Shade Solutions2026-03-278R 96,200Shipped
SO-29195Durban Outdoor Living2026-03-2724R 312,000Shipped
SO-29190Namibia Sun Protection2026-03-266R 78,900Pending
SO-29184Pretoria Patio World2026-03-2415R 201,000Overdue
SO-29180Botswana Leisure2026-03-2310R 145,600Delivered
Total SKUs
1,243
Across 8 warehouses
Stock Value
R 28.4M
Healthy levels
Below Reorder
23
Action required
Overstock
47
R 3.1M tied up

Stock Alerts

SKUProductWarehouseOn HandReorder PtStatus
SKU-8821Umbrella Frame XL — AluminiumJHB Main1250Critical
SKU-8835Canopy Fabric — Navy 3mJHB Main2840Low
SKU-9102Base — Granite 40kgCPT Depot34060Overstock
SKU-7745LED Light Kit — SolarDBN Warehouse825Critical
SKU-8890Umbrella Frame M — SteelJHB Main185100OK
Show me revenue by customer for this quarter
Which customers haven't ordered in 60 days?
What stock items need reordering urgently?
Compare this month's sales to last month
Summarize overdue orders and recommend actions
Predict next month's top selling products
AI

Sage X3 AI Reports

I can query your Sage X3 data in real-time and generate reports, charts, and insights. Ask me anything about customers, sales, inventory, or financials.

Powered by Claude on Cloudflare Workers AI

GraphQL Query

Result

Run a query to see results...