Dashboard
Operational view of SFDA, receiving, inventory, dispatch, exceptions, and customer mapping.
Total SFDA Batches
โBatches
Missing Supplier Batches
โBatches
Pending STO RSD Transfers
โBatches
Historical Data Coverage
โ
Customers with GLN
โCustomers
Dummy GLN Used
โCustomers
Reconciliation Overview
Latest completed run preview ยท 10 rows per page
| SFDA | WMS Receive | WMS Inventory | WMS Dispatch | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BN | Expiry Date | GTIN | Drug Name | Active | Qty Sent Pending | Qty Receive Pending | Received | To Be Accept | Inventory | Variance | To Be Dispatch | Status |
No reconciliation data loadedRun a reconciliation to populate this operational table. | ||||||||||||
Top Exceptions
Highest-priority reconciliation issues
| BN | Expiry Date | Issue Type | Description | Variance | Action |
|---|---|---|---|---|---|
No exception details availableDetailed records will be loaded from the database phase. | |||||
Dispatch by Customer
Historical customer movement from Product Intelligence
| Customer | GLN | Dispatched Packs | Last Dispatch | Mapping |
|---|---|---|---|---|
No customer intelligence loadedRefresh the dashboard to load Product Intelligence. | ||||
Batch Matching & Reconciliation Breakdown
Long-form operational chart across the current warehouse dataset
Upload & Run Reconciliation
Run Accept first using ASN + SFDA, upload the result to SFDA, then run Dispatch using Full Dispatch + the refreshed SFDA report.
Two-Step Reconciliation Workflow
Complete Accept first, upload it to SFDA, download the refreshed Drug Count, then run Dispatch.
Processing Summary
Latest response from the Azure reconciliation engine.
Input Files
0
Input Rows
0
Master Rows
0
Accept Items
0
Dispatch Items
0
Variance Items
0
Reconciliation Results
Review and download all files generated for the current reconciliation run.
Accept Items
โ
Dispatch Items
โ
Variance Items
โ
Generated Files
โ
Accept Upload Files
SFDA-ready CSV files split into 20 rows and maximum total quantity of 100,000.
Dispatch Upload Files
Customer-grouped files using GLN mapping, with unmatched customers classified as DUMMY.
Variance Report
Unallocated quantities and reconciliation exceptions requiring investigation.
All Excel Reports
Accept Details, Dispatch Details, and Variance reports in a single archive.
No Accept files loadedRun a reconciliation first.
No Dispatch files loadedRun a reconciliation first.
No Excel reports loadedRun a reconciliation first.
No alerts generatedAll batches match expected records.
Reconciliation
Build the historical foundation once, then run the one-time reconciliation against current Inventory and SFDA data.
Initial Setup & Alignment
Step 1 โ Historical Data Builder
Build Batch Master, Supplier History, and Customer History from historical warehouse activity.
โ Database Operation
Choose the operation before selecting historical files.
โก Historical ASN Receipt Files
Select one or multiple historical receipt reports.
โข Historical Full Dispatch Files
Select one or multiple historical dispatch reports.
โฃ Latest SFDA Drug Count
Used to retain only SFDA-relevant generics and batches.
Step 2 โ Reconciliation
Run Accept first, upload it to SFDA, then use the updated SFDA report for Dispatch.
A โ Full Accept Reconciliation
Upload the latest SFDA report, generate Accept files, then upload the CSV files to SFDA.
Latest SFDA Drug Count
SFDA status before Full Accept.
B โ Full Dispatch Reconciliation
After completing Accept in SFDA, upload current Inventory and the updated SFDA report.
Current Inventory Report
Latest physical WMS inventory snapshot.
Updated SFDA Drug Count
Download this report after the Accept files are processed in SFDA.
Reconciliation History
Persistent reconciliation runs stored in the configured database.
| Run ID | Process | Date & Time (Saudi) | User | Status | Files | Input Rows | Accept | Dispatch | Variance | Version | Actions |
|---|
Reports & Analytics
Management reporting across reconciliation runs, current exceptions, and product intelligence.
Total Runs
0
Success Rate
0%
Failed Runs
0
Open Variances
0
Run Mix
Completed and failed activity by process
Current Variance Position
Latest live exception counts
Recent Failed Runs
Latest runs requiring technical review
| Run ID | Process | Date | Error |
|---|
Product / Batch Position
Latest Product Intelligence snapshot
Last 7 Days Activity
Reconciliation run volume by Saudi date
Product Intelligence
Real-time insights from the latest SFDA and Inventory snapshots.
Last Updated: โ
Loading Product Intelligence...Reading Batch Master and latest snapshots.
Batch Intelligence
0 batches
| Drug Name / GTIN | BN | Expiry Date | Pack Size | Inventory Pack | Active | Sent Pending | Receive Pending | Status |
|---|
Data Quality & Reconciliation Overview
Real-time summary of reconciliation status
โค
0Batches
โ
0Accept Required
โฃ
0Dispatch Required
โ
0Package Size Missing
โฅ
0GLN Missing
Batches by Status
Supplier Intelligence
Historical supply performance by supplier
| Supplier Name | Supplier Code | Received Pack | Last Receipt |
|---|
Customer Intelligence
Historical dispatch quantity by customer
| Customer | GLN | Dispatched Pack | Last Dispatch |
|---|
All data is based on the latest successful snapshots from SFDA & Inventory reconciliation.
Variance Management
Investigate WMS vs SFDA discrepancies and prepare an official discrepancy report for SFDA.
Receiving VarianceโSupplier receiving discrepancies
RMissing RegistrationโReceived batch absent from SFDA
MQuantity MismatchโSFDA quantity less / more than WMS
QUnmapped CustomersโMissing or dummy GLN mapping
C| Severity | Variance Type | Batch / GTIN | Description | Difference | Status | Supplier / Customer | |
|---|---|---|---|---|---|---|---|
Loading variance dataPlease wait. | |||||||
Page 1 of 1
0 items
Variance Details
Selected exception and recommended action.
Select a varianceClick any row to view WMS and SFDA details.
Generate Discrepancy Report
Create the official supplier discrepancy report for SFDA.
Report Preview
Current selected discrepancies.
Total selected0
Critical0
Warning0
Prepare Outlook Draft
Create a Microsoft Outlook draft with the selected discrepancy report attached. Review it and press Send yourself.
Microsoft Outlook integration is checked when the page loads.
Administration
Manage users, reference data, email configuration, and platform status.
Warehouse GLN Mapping
Loading the GLN configuration for the signed-in warehouse...
Checkingโ
Required columns: To Address, GLN
Pack Size Mapping
Converts warehouse units into SFDA packages using controlled internal Package Size references.
Internal File Activeโ
Business Rules
Controls Accept, Dispatch, Variance allocation, maximum rows, quantity limits, and file generation.
Python Rules Activeโ
Reset Warehouse Data
Delete only uploaded and operational data for this warehouse and return it to a clean state. Users, warehouse setup, GLN mapping, Pack Size and business rules are preserved.
This action deletes Batch Master, historical events, snapshots, reconciliation runs and warehouse run files.
User Management
New company users remain Pending until approved.
| Warehouse | Role | Status | Created | Last Login | Actions | |
|---|---|---|---|---|---|---|
User list not loadedAdministrator access is required. | ||||||
Access & Email Configuration
Security and approval workflow
AuthenticationRequired
Allowed Email Domainโ
Approval Admin Emailโ
Email Serviceโ
System Information
Current Azure Function environment
API Endpoint/api/process-accept ยท /api/process-dispatch
Health StatusChecking...
Application Versionโ
Signed In Userโ