⚠ TODAYS DISPATCH REPORT NOT YET RECEIVED — SHOWING LAST AVAILABLE DATA ⚠ TODAYS DISPATCH REPORT NOT YET RECEIVED — SHOWING LAST AVAILABLE DATA
📦
Total Orders
—
— routes · — drivers
— total drops
💰
Total Value (AED)
—
Today's dispatch
✦ FOOD
—
AED —
DCV—
DCF (FoodSvc)—
🟠 NON FOOD
—
AED —
DGC—
AED —
DGS—
AED —
DSN—
AED —
❄ FROZEN
—
AED —
Ambient—
By Temperature column, separate from Food/Non-Food type
💇 SALON (DIP W/H)
—
AED —
Drops—
From the standalone Salon file only — DGC in Main dispatch is mixed with Pharma W/H and is never counted here. Orders/drops only — excluded from vehicle/driver/transport-cost tracking until billing is confirmed.
📍 Drops by City — always sums to Total Drops exactly
📈 Order Type Split
🚚 Fleet Mix — Own vs Hired Drivers (Day by Day)
In-house/hired driver & drop counts, order value, % hired, per day
🤖 AI Deep Analysis — Where's the gap, why, and how to fix it
Date
In-House Drivers
Hired Drivers
% Hired
In-House Drops
Hired Drops
Total Orders
Total Value (AED)
Pick a date range and click Apply.
💰 Top Customers by Value
#
Customer
Orders
Value (AED)
🚚 Top 5 Drivers
🚛 Estimated Transport Cost — based on transport team's FY26 rate card, billed per drop
Estimated Cost Today
—
Total Vehicles Used (rate-matched only)
—
Not the same as driver count above — this excludes any vehicle whose truck-type couldn't be matched to a rate (see note below).
Vehicle Type
Rate (AED/Drop)
Drops Billed
Vehicles Used
Estimated Cost (AED)
By Region
City
Drops
Cost (AED)
By Food / Non-Food
Category
Drops
Cost (AED)
By Frozen/Ambient × Type
Category
Drops
Cost (AED)
🔗 Transport Cost Reconciliation — cross-checks App-captured drops against the transport team's own raw drop file
No transport file uploaded yet. Upload the transport team's raw drop export (needs DROP ID, TASK STATUS, Final Drops Remarks, and a date column — the "Raw Data" sheet in their MTD-style export) to compare it against what this app captured on the same dates.
App Captured (Total)
—
Transport Reported (Total)
—
Total Variance
—
Click any date below to see the specific orders that don't match on either side.
Date
App Captured
Transport Bulk
Transport Multi
Transport Total
Variance
Variance %
Status
Order-Level Detail —
App Orders
—
Transport Orders
—
Matched
—
Dispatched by AKI, missing from Transport file
In Transport file, missing from AKI dispatch
🔁 Re-Delivery Tracking — same order code seen again on a later day (failed first attempt, re-delivered now)
Re-Delivered Orders Today
—
Value at Risk (AED)
—
Estimated Re-Delivery Cost
—
✅ No repeated orders today — everything delivered on first attempt.
Order Code
Customer
Type
Times Delivered
Dates
Value (AED)
Est. Re-Delivery Cost (AED)
💎 Top 5 Drivers by Value — a driver with just a few high-value deliveries won't show up in the count-sorted list above
🧑✈️ In-House vs Hired Drivers — "hired" = no driver name in source file, only a phone number
In-House Drivers
—
—
Hired Drivers (no name on file)
—
—
Hired Drivers Today (by value, highest first)
Phone/ID
Customer
Type
Orders
Drops
Value (AED)
📋 Driver Order Details & Duplicate-Drop Cost — per driver/truck
One drop = one charge — sending the same location on 4 trucks pays the drop cost 4 times. One day at a time — a driver/truck (especially a hired one) is a daily assignment, never combined across days.
Excel includes: Executive Summary, short AI advice on cutting duplicate drop charges, a Duplicate Drops sheet (locations hit by 2+ trucks the same day, extra cost color-coded), and a full order-by-order sheet (customer, order value, final drop, address).
🤖 AI Advice — Reducing Duplicate Drop Cost
🗺️ Route Summary — Locations per Route
Route
Type
Vehicle
Orders
Drivers
Locations
Value (AED)
🚚 Drop Analysis — own fleet drops and repeat-visit addresses
Own Fleet Drops
—
Avoidable Repeat Drops
—
Same order type, same address, 2+ trucks
Locations Visited by 2+ Routes Today — Avoidable vs Required
Required = different order types (e.g. Food + Non-Food) — separate trucks are genuinely needed. Avoidable = same order type sent twice to the same address — worth raising with the transport team.
Location ID
Customer
Address
Routes (Type · Value)
Status
Total Value (AED)
🔒 Admin — Upload Today's Dispatch File
📊
Click to Upload Dispatch Report (.xlsx or .csv)
Admin uploads once — team sees live data automatically
Processing your Excel file...
Rejection Dashboard
YTD JAN – MAY 2026 · ⏳ Loading data from server...
— total orders
BU
ORG──FOOD────COOKWARE/ELEC──
MONTH
—
DAY← click a day to drill down to that date
—
TYPESOURCE
🔍 Top Root Causes
👥 Top Customers by Rejections
📅 Month-Wise Analysis
Month
Delivered
Rejection
Delivered %
Rejection %
Food (of Rej.)
Non-Food (of Rej.)
Food/Non-Food % are each category's share of that month's REJECTIONS specifically (not of total orders) — same basis as the Food/Non-Food filter above. "Frozen" isn't tracked as a separate category yet — let me know if that needs adding.
💡 Click 2+ months above (shift-click for a range) to see an AVERAGE row for that range.
📋 Customer · Location · Root Cause Detail
#
Customer Name
Full Address
Final Root Cause
Count
%
Upload rejection file to view detail
🚨 WRONG FILE? THIS DOESN'T LOOK LIKE A REJECTION REPORT
⛔ UPLOAD BLOCKED
⏳ Upload your rejection Excel file to load live data
📋 AUTO-CLASSIFICATION NOTES — LAST UPLOAD
🕳️ Dispatch vs Rejection YTD — Gap Tracker
Every order dispatched should end up recorded in Rejection YTD one way or another — either as Delivered or as Rejected. An order with neither is a gap: the transport team never logged its outcome. Separately, an order dispatched on 2+ different dates (a re-delivery) with no matching record at all is worth flagging even more directly — something clearly went wrong the first time, and there's no record of why.
Loading…
Orders This Period
—
Matched (Delivered or Rejected)
—
⚠ No Record At All
—
Re-Delivered (2+ dates)
—
⚠ Re-Delivered, No Record
—
By Business Unit — Full Order List Is In The Excel Download
BU
Total Orders
Matched
Gap Count
Gap Value (AED)
Re-Delivered
Re-Delivered Gap
Comment
🧾 Customer Visit Prep — search a customer for their full internal + external breakdown
Type:
📊 Live Data Summary
Dispatch: Not loaded
Rejection YTD: Not loaded
General Info: Not loaded
📋 Executive Summary Generator
Executive Brief
Bullet Points
Action Items
Key Decisions
Operations Report
Processing document...
✦ Executive Summary
🏪 MERCHANDISER DAILY DELIVERY LOOKUP
Type or speak a merchandiser name — see today's assigned deliveries, driver info, and download their summary.
📦 DELIVERY ORDERS
#
Order Code
Customer
City
Route
Driver
Amount (AED)
✉️ Professional Email Writer
Fix & Polish
Customer Complaint
Supplier
Management Update
Apology
Follow Up
Writing your email...
💼 Proforma Invoice Generator
🏢 AKI — Al Khayyat Investments
🏥 Alphamed General Trading
From (Your Company)
Bill To (Client)
Invoice Details
Subtotal (excl. VAT)AED 0.00
VAT (5%)AED 0.00
Net Total (incl. VAT)AED 0.00
Daily Upload
Upload your WH Back Log Order CSV/Excel file
Last: —
Credit Hold Not Released — By Org
No credit-hold file uploaded yet.
📦
No backlog data loaded
Upload your WH Back Log Order file to see the dashboard
⚠️ This data looks unusual — orders exist but total value shows AED 0. This might be a real data issue upstream, or it might just be an unusual (but valid) upload. It has not been auto-deleted — review it below and use Clear Data (superadmin only) if it's genuinely wrong.
ORGBU
CATEGORY
Raw Status Text Breakdown (current file)
Every distinct comments/status value in the currently loaded file, with order count and value. Use this to confirm exactly which wording the Credit Hold match should look for.
Daily Tracking — Pool Trend
Date
Total Orders
Total Value
Advance
Credit Hold
WH Backlog
1. ORG Wise Exposure
ORGOrdersValueShareRisk
2. Backlog by Category
3. RSD Aging View
4. Top Customer Risk (by Value)
CustomerOrdersValueORGRisk
5. Operational Action Table
ORG
Customer
Shipment
RSD
Value
Category
Action
Admin Access Required
Enter password to unlock file upload
👁
Incorrect password. Please try again.
Daily Upload
Upload a day's or month's Returns file — new dates are added, existing dates on file are replaced. Older dates already on file are untouched.
Last: —
🔄
No returns data loaded
Upload your YTD Returns CSV file to see the dashboard
⚠️ This data looks unusual — over 100 orders exist but total value shows AED 0. This has not been auto-deleted — review it below and use Clear Data (superadmin only) if it's genuinely wrong.
WAREHOUSE
MONTH(click multiple, or shift-click for a range)
DATE
LOCATION
CATEGORY
BU
CHANNEL(click multiple to combine · Durable Goods = DGS/DSN warehouse · HoReCa = Food Service accounts · B Class = everything else)
—
Monthly Returns Trend
Returns by Warehouse
GRV Return vs Invoice Cancellation
Same Category split as the donut above, broken out month by month instead of one static total. Reflects the Warehouse / Month / Location / BU / Channel filters above.
Credit Note Category
Returns by Area / City
Business Unit Split
Top Customers by Return Value
📋 Return Reasons Breakdown
Return reason data will appear here once you add the Rejection Reason column to your upload file.
Reason
Order Number
Category
Date
Customer
Value (AED)
Order Summary Upload
Upload your Sales Orders Excel/CSV file
📈
No sales data loaded
Upload your Sales Orders file to see the dashboard
📦 Orders & Value by ORG
🍽 Food vs Non-Food Split
📊 Order Status Breakdown
❄ Temperature Split
🏭 Warehouse Value Summary
Warehouse
BU
Orders
Value (AED)
Share
📐 Excel Support & Data Analysis
📊
Upload .csv or .xlsx file
File → Save As → CSV first
Analysing your data...
✦ Excel Analysis
Automation Tracking Upload
Upload DoxtrE Auto/Manual Excel file
Incorrect password
Automation Tracking YTD
DoxtrE Auto vs Manual Booking · Organisation Breakdown · Jan–Jun 2026
⚡
No Automation Data Loaded
Click the ✦ star button (bottom right) to upload your DoxtrE Excel file
🛒
Total Orders YTD
—
—
✅
Auto Booked
—
—
🧑
Manually Booked
—
—
📊
Automation Rate
—
YTD average
📈
Latest Month
—
—
📊 Auto vs Manual by Month
■ Auto Booked %■ Manual Booked %Total Orders
📅 Monthly Breakdown
Month
Total
Auto
Manual
Auto %
🏢 Organisation Breakdown — Auto-mapped from Order Type
Organisation
Order Type(s)
Total
Auto
Manual
Auto %
Progress
General Info Upload
Upload Team_Directory Excel file
👥
NO TEAM DATA LOADED
Click ✦ star to upload Team_Directory file
UNIT
👥 Team Directory
Name
Designation
Unit
Dept
Contact
Responsibility
Outlet / Area
Branch
Reporting To
BU Type
Acct No.
🏪 Merchandiser Outlet Map
🚚 Dispatch Link
📞 VoIP Direct Call — Powered by Twilio
Browser-to-mobile calling · No app needed on driver side
⚠ NOT CONFIGURED
📱 YOUR MOBILE NUMBER
⚡ Enter once — your phone rings first, then driver
TO (DRIVER / TEAM)
0:00
🔧 Setup Required — Coming Soon
To activate VoIP calling:
1. Get Twilio Account SID + Auth Token from twilio.com
2. Get a Twilio UAE-compatible phone number
3. Add credentials to server environment variables
4. VoIP calls will work instantly — driver's mobile rings directly
TWILIO_ACCOUNT_SID
TWILIO_AUTH_TOKEN
TWILIO_PHONE_NUMBER
TWILIO_TWIML_APP_SID
📦 Daily Oracle Extract
Upload every day after Oracle extraction
Incorrect password
📋 Schedule Master
Upload once · Re-upload only if schedule amended
Incorrect password
📦
No Data Loaded
Click ✦ star → Upload Schedule file first, then Oracle extract daily
Category
ORG
Channel
Month
Total Orders
—
—
Scheduled
—
—
Out of Schedule
—
—
No Schedule
—
Not in master
Compliance Rate
—
Scheduled / Total
📊 PIVOT — Status × Channel × Month
📅 Monthly Compliance
📆 Compliance by Day
❌ NO SCHEDULE — Customers Not in Delivery Master
⚠️ OUT OF SCHEDULE — Top Customers by OOS Count
Customer Master
Upload the Customer Master Excel (sheet "Customar Master"). Existing rows are updated, new rows added — nothing is deleted.
Item Master
Upload the Item Master Excel (Item Code, Description, Brand, Category). Existing rows are updated, new rows added — nothing is deleted.
➕ Add Salesman Login
Full Name
Username (for login)
Temporary Password
Link to Salesperson Name (from Customer Master)
📋 Existing Salesmen
Name
Username
Linked Salesperson
Customers
Orders
Status
Actions
Admin Authentication
WH Backlog Upload
Enter admin password to upload file
👁
Incorrect password. Please try again.
✦ UPLOAD ACCESS
👁
Incorrect password
🎤
CAPTION
OPERATIONS INTELLIGENCE
TAP MIC TO SPEAK
YOU ASKED
✦ CAPTION SAYS
QUICK COMMANDS — TAP TO ASK
✦
CUSTOMER SERVICE & OPERATIONS
CONTROL TOWER
Intelligence Platform
azr-operations.com · V 4.0
Change Password
Please change your password to continue
Admin Control Panel
USER MANAGEMENT · AUDIT LOG
ADD NEW USER
Sub-admin requests to upload dates already on a dashboard. Approving replays their original file exactly as uploaded.