USON Track Report
1.1 About USON Track Report​
The USON Track Report helps users monitor delivery commitments and track the delivery status of sales orders.
USON (Unique Sales Order Number) is a unique reference number generated from the combination of:
Our Reference Number - Sales Order Line Item Number - Order Acceptance Reference Number
The USON Code acts as a unique identifier for each sales order line item and can be used to search and track specific sales order records.
Users can search using the USON Code to view delivery schedules, delivered quantities, pending quantities, and the current delivery status of a sales order.
1.2 Purpose of the Report​
The report helps users:
- Track customer orders using the USON Code.
- View committed delivery schedules.
- Monitor delivered and pending quantities.
- Identify overdue deliveries.
- Track delivery performance for each sales order line item.
1.3 How the Report Works​
A sales order may be split into multiple delivery schedules based on business requirements.
The report displays:
- Total PO Quantity
- Delivery Committed Date
- Split Quantity
- Delivered Quantity
- Pending Quantity
- Days Left
- Delivery Status
This helps users understand whether deliveries are on schedule or delayed.
1.4 Status Description​
1.4.1 Pending​
Displayed when:
- The delivery commitment date has not yet passed.
- Quantity is still pending for delivery.
1.4.2 Overdue​
Displayed when:
- The delivery commitment date has passed.
- The quantity has not yet been fully delivered.
1.4.3 Completed​
Displayed when:
- The entire committed quantity has been delivered.
1.5 Example Scenario​
Customer Order​
| PO Qty | Delivery Committed Date | Split Qty |
|---|---|---|
| 10 | 27-May-2026 | 2 |
| 10 | 31-May-2026 | 8 |
Current Delivery Status​
| Delivery Committed Date | Split Qty | Delivered Qty | Pending Qty | Days Left | Status |
|---|---|---|---|---|---|
| 27-May-2026 | 2 | 0 | 2 | -2 | Overdue |
| 31-May-2026 | 8 | 0 | 8 | 2 | Pending |
Explanation​
- A total PO quantity of 10 units was received.
- The order was split into two delivery schedules.
- 2 units were committed for delivery on 27-May-2026.
- Since the committed date has passed and the quantity has not been delivered, the status is Overdue.
- The remaining 8 units are committed for delivery on 31-May-2026.
- Since the delivery date has not yet passed, the status is Pending.
This helps users quickly identify delayed deliveries and take appropriate action.
1.6 Search USON Track Report​
From the main left-side menu, click:
Sales → Reports → USON Track Report
This opens the USON Track Report screen.
1.7 Search Fields​
- PO Date From → Select the starting PO date.
- PO Date To → Select the ending PO date.
- Customer → Select one or more customers.
- Plant → Select one or more plants.
- Search → Retrieves matching report records.
- Clear → Clears the selected filters.
1.8 Report Columns​
| Column Name | Description |
|---|---|
| S.No | Serial number of the row. |
| USON Code | Unique Sales Order Number generated from the combination of Our Reference Number, Sales Order Line Item Number, and Order Acceptance Reference Number. |
| FY Year | Financial year. |
| PO Date | Purchase Order date. |
| Part Code | Part code. |
| Part Number & Rev | Part number with revision. |
| Customer | Customer name. |
| Plant | Plant name. |
| PO Number | Purchase Order number. |
| PO Revision | Purchase Order revision number. |
| Part Number | Part number. |
| Part Name | Part name or description. |
| Delivery Date | Delivery date mentioned for the order line. |
| PO Qty | Purchase Order quantity. |
| Delivery Committed Date | Committed delivery date. |
| Split Qty | Quantity committed for the delivery schedule. |
| Delivered Qty | Quantity already delivered. |
| Pending Qty | Quantity pending for delivery. |
| Days Left | Remaining days based on delivery status. |
| MOT | Mode of Transport. |
| Status | Current delivery status. |
| Created Date | Date and time when the record was created. |
| Created By | User who created the record. |
| Modified Date | Date and time when the record was last modified. |
| Modified By | User who last modified the record. |
1.9 Report Actions​
- Search Box → Filters the displayed report records.
- Excel → Exports the report data.
- Print → Prints the report.
That's it! You've learned how to ADD, SEARCH, EDIT a plant using the DMeX app. If you need help, contact the support team.