⚠ 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 —
✦ 3PL
—
AED 0
HCP—
Physical delivery only — no invoice value
❄ 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.
📊 Orders by City
📍 Drops by City — always sums to Total Drops exactly
📈 Order Type Split
💰 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
—
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)
🗺️ Route Summary — Locations per Route
Route
Type
Vehicle
Orders
Drivers
Locations
Value (AED)
🚚 Drop Analysis — own fleet vs 3PL, and repeat-visit addresses
Own Fleet Drops
—
3PL Drops
—
Third-party fleet, not ours
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)
📊 Orders by City × Type
City
Food
Non-Food
3PL
Van
Total
✦ Ask AI About Today's Dispatch
✦ Dispatch Intelligence
🔒 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
📋 Customer · Location · Root Cause Detail
#
Customer Name
Full Address
Final Root Cause
Count
%
Upload rejection file to view detail
⏳ Upload your rejection Excel file to load live data
📊 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
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 your YTD Returns CSV file
Last: —
🔄
No returns data loaded
Upload your YTD Returns CSV file to see the dashboard
WAREHOUSE
MONTH
LOCATION
CATEGORY
BU
Monthly Returns Trend
Returns by Warehouse
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.
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
—
—
📅 Monthly Breakdown
Month
Total
Auto
Manual
Auto %
📊 Auto vs Manual by Month
■ Auto Booked■ Manual
🏢 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.