Reports
Locate Report tab
- Navigate to Reports > Report tab
- This tab is where you can generate and export reports
General steps to generate and export report
- Step 1: Select the report: Click on the field Report Type. Select the appropriate report from the drop down list
- Step 2: Select the date range: Click on the field below the text Date Range. Select the appropriate date range from the drop down calendars, then click on Apply to confirm selecting the date range. Alternatively, you could input the date range directly into the field in the following format: yyyy-mm-dd:yyyy-mm-dd
If the selected date range spans more than 31 days, then instead of being directly downloadable from the Web app, the report will be sent to the email address associated with the account which export that report
- Step 3: Select whether there will be header in the report or not: By default, you will see a toggle button that reads Exclude Report Header. That means in the downloaded Excel spreadsheet, there will not be a header mentioning the report name and the date range
- If you want to add the report name and the date range to the report, click on that switch button. When the button changes to , the text will change to Include Report Header, which means in the report there will be a header of the report name and the date range, like below
- Step 4: Download the report: Click on the button Download . The system will immediately start gathering data based on your filters, and will generate a downloadable Excel spreadsheet shortly
ST15 - Products and Tasks by PDP Orders
Information field | Description | Data type | Unit | Possible Values | Example |
---|---|---|---|---|---|
No. | Numerical order | Number | _ | _ | 1 |
Order Code | Code of the order | Text & Number | _ | _ | SO-190829-0001 |
Order Date | The date when the order was delivered | Date Format: Year-Month-Date (yyyy-mm-dd) | _ | _ | 2019-05-08 |
Driver Name | Name of the driver who delivered the order | Text | _ | _ | John Doe |
Truck Plate No. | Plate numbers of the truck used to deliver the order | Text & Number | _ | _ | 31K3-5152 |
Truck Type | Type of the truck used to deliver the order | Text & Number | _ | _ | Twelve wheels truck |
Origin Customer Name | Name of the origin customer, from where the products were picked up | Text | _ | _ | John Doe company |
Origin Customer Address | Address of the origin customer, from where the products were picked up | Text & Number | _ | _ | 1st road, valley A, city B, country C |
Destination Customer Name | Name of the destination customer, to where the products were delivered | Text | _ | _ | John Doe company |
Destination Customer Address | Address of the destination customer, to where the products were delivered | Text & Number | _ | _ | 1st road, valley A, city B, country C |
SKU | The product loaded in the order | Text & Number Format: (Product Code) Product Name | _ | _ | (Product_A_Code) Product A Name |
Quantity | Quantity of the product loaded in the order | Number | _ | _ | 100 |
Quantity Type | Unit type of the product loaded in the order | Text | _ | Pallet; Case; Item etc. | Pallet |
Check By | Name of the personnel who checked the order | Text | _ | _ | John Doe |
Fulfillment Status | Delivery result of the order at the time the report was generated | Text | _ | Fulfilled; Partially fulfilled; Not Yet Fulfillment; Unfulfilled | Fulfilled |
Distance Difference (m) | The distance that the driver actually traveled from the Origin Customer to the Destination Customer | Number (Decimal) | m (Meter) | _ | 90000.4 |
Trip Hours | The time duration during which the order was performed | Time Format: Hour:Minute:Second (hh:mm:ss) | _ | 40:36:30 | |
Arrival check-in Date/Time | The specific Date and Time when the driver arrived at the Destination Customer location | Date/Time Format: Year-Month-Date Hour:Minute:Second (yyyy-mm-dd hh:mm:ss) | _ | _ | 2019-05-08 09:06:06 |
Unloading start check-in Date/Time | The specific Date and Time the Unloading task started at the Destination Customer location | Date/Time (yyyy-mm-dd hh:mm:ss) | _ | _ | 2019-05-08 09:06:06 |
Signature Status | The status of the customer signing digitally upon receiving the products | Text | _ | Signed; Not Yet | Signed |
Signature Sign-on date | The date on which the customer digitally signed upon receiving the products | Date Format: Year-Month-Date (yyyy-mm-dd) | _ | _ | 2019-05-08 |
Email Sending Status | The status of sending email enclosed with the Proof of Delivery | Text | _ | Not yet; Sent | Sent |
ST16 - Transport Service Cost by PDP Orders
- This report will keep track of the Transport Service cost of PDP Orders paid by particular Depots, delivered by particular Transporters during a certain date range
Report ST16 - Export instruction
- Click on Report Type field, select this report from the drop down menu
- Next, click on Created Date field. From the drop down calendars, select the date range during which the Orders were created
- Then, click on Delivery Date field. From the drop down calendars, select the date range during which the Orders were actually delivered to the destination locations
- Click on the field Select Service Payer. On the drop down list, click on the search bar, input the Organization Name of the appropriate Depot and select the returned value. Repeat these steps to select more Depots
- Continue to click on the field Select transporter. On the drop down list, click on the search bar, input the Organization Name of the appropriate Transporter and select the returned value. Repeat these steps to select more Transporters
- Finally, click on Download button. The system will immediately gather data and generate a downloadable Excel spreadsheet to view offline
- (Optional) If you want to include a header in the Excel spreadsheet, you can click on the toggle button Exclude Report Header . When that button changes to Include Report Header , in the Excel spreadsheet there will be a header
Report ST16 - Information fields
Information field | Description | Data Type | Unit | Possible Values | Example |
---|---|---|---|---|---|
No. | Numerical order of the Sales order | Number | - | - | 1 |
Order Code | Management code of the Sales order | Text & Number | - | - | S.O.#1 |
Branch Name | Name of the Branch that managed the Sales order | Text & Number | - | - | Branch A1 |
Product Name | Name of the product loaded in the Sales order | Text & Number | - | - | Product A1 |
Origin Pickup | Name of the Origin Depot, where the Transporter vehicle will pick up products | Text & Number | - | - | Depot A1 |
Destination Delivery | Name of the Destination Depot, where the Transporter vehicle will drop off products | Text & Number | - | - | Depot A1 |
Transporter | Name of the Transporter which have been selected to deliver the order | Text & Number | - | - | Transporter A1 |
Vehicle Type | The vehicle type that have been selected to deliver the order | Text & Number | - | - | Vehicle Type A1 |
Transporter Service Price | The original transport service price of the order This field will have a value larger than zero if the Order is the first Order on the Delivery Route of the assigned vehicle | Number | Currency unit For example: VND | - | 4500000 |
After Discount Rate | The rate (After subtracting the fixed discount rate of 15%) to be multiplied with the original transport service price rate in order to calculate the discounted transport service price of the order This field will have a value if the Order is not the first Order on the Delivery Route of the assigned vehicle | Number | Percentage (%) | 85% | 85% |
Surcharge | The transport service surcharge of the order (If applicable) This field will have a value if the Order is not the first Order on the Delivery Route of the assigned vehicle The value in this field will be the same value under the column "Surcharge" of the Order on the form "Optimization Result" during the Route Plan optimization process | Number | Currency unit For example: VND | 500000 1000000 | 500000 |
Total Service Price | Total Transport service price of the Order The value in this field is the same value under the column "Amount" of that exact Order on the form "Optimization Result" during the Route Plan optimization process | Number | Currency unit For example: VND | - | 234000 |
License Plate | License plate numbers of the vehicle that delivered the order | Text & Number | - | - | 30K3-5155 |
Driver Name | Name of the driver who operated the delivery vehicle | Text & Number | - | - | John Doe |
Driver Phone Number | Phone number of the driver | Number | - | - | 012345678 |
Order Creation Date | The date on which the order was created | Date Format: Date/Month/Year (dd/mm/yyyy) | - | - | 30/01/2020 |
Due date | The planned date on which the order is supposed to be completed The value in this field is the same as the value input into the field "Date" of the Order | Date Format: Date/Month/Year (dd/mm/yyyy) | - | - | 30/01/2020 |
Actual Delivery Time | The date on which the Order is actually delivered to the Destination Depot | Date Format: Date/Month/Year (dd/mm/yyyy) | - | - | 30/01/2020 |
Planning Status | Planning status of the Order at the time the report was exported | Text | - | Approved Not Submitted Routed Submitted | Approved |
Origin Shipping Status | Status of the Origin Depot's warehouseman handing products to the Transporter's driver at the time the report was exported | Text | - | NOT FULFILLED SHIP FULFILLED SHIP PARTIALLY (LESS) SHIP PARTIALLY (MORE) SHIP UNFULFILLED | SHIP FULFILLED |
Origin Pickup Status | Status of the Transporter's driver picking up products at the Origin Depot at the time the report was exported | Text | - | NOT FULFILLED PICKUP FULFILLED PICKUP PARTIALLY (LESS) PICKUP PARTIALLY (MORE) PICKUP UNFULFILLED | PICKUP FULFILLED |
Destination Receiving Status | Status of the Destination Depot's warehouseman receiving products from the Transporter's driver at the time the report was exported | Text | - | NOT FULFILLED RECEIVE FULFILLED RECEIVE PARTIALLY (LESS) RECEIVE PARTIALLY (MORE) RECEIVE UNFULFILLED | RECEIVE FULFILLED |
Destination Delivery Status | Status of the Transporter's driver delivering products to the Destination Depot at the time the report was exported | Text | - | NOT FULFILLED DELIVERY FULFILLED DELIVERY PARTIALLY (LESS) DELIVERY PARTIALLY (MORE) DELIVERY UNFULFILLED | DELIVERY FULFILLED |
Service Payer Organization Name | Organization Name of the Depot that has to pay the Transport Service price of the Order | Text & Number | - | - | Depot B52 |
Service Payer Organization Description | Description about the Depot that has to pay the Transport Service price of the Order The value in this field is the same value as the attribute "Description" of the Depot | Text & Number | - | - | This depot only works for twelve hours |
ST18 - PDP Transporter Review
Report ST18 - Export instruction
- Click on Report Type field, select this report from the drop down menu
- Then, click on Date Range field. From the drop down calendars, select the date range during which the orders were created and executed
- Finally, click on Download button. The system will immediately gather data and export the report into a downloadable Excel template after a short moment
- (Optional) If you want to include a header in the Excel template, you can click on the toggle button Exclude Report Header . When that button changes to Include Report Header , in the Excel template there will be a header
Report ST18 - Information fields
Information field | Description | Data Type | Unit | Possible Values | Example |
---|---|---|---|---|---|
Transporter Code | The management code of the Transporter | Text & Number | _ | _ | Transporter_ABC |
Transporter Name | Name of the Transporter | Text & Number | _ | _ | John Doe transport service |
Number Of Orders | The quantity of orders performed by the Transporter during the selected date range | Number | _ | _ | 122 |
Total Order Weight | The total weight of all orders performed by the Transporter | Number | Kilogram (kg) | _ | 23000 |
Total Order Volume | The total volume of all orders performed by the Transporter | Number | Cubic metre (m3) | _ | 23000 |
Total Service Cost | The total transport service cost of all orders performed by the Transporter | Number | Currency Unit For example: VND | _ | 40000000 |
Fulfilled Orders | The quantity of orders that have the Destination Delivery Status to be: DELIVERY FULFILLED | Number | _ | _ | 100 |
Partially Fulfilled (Less) Orders | The quantity of orders that have the Destination Delivery Status to be: DELIVERY PARTIALLY (LESS) | Number | _ | _ | 100 |
Partially Fulfilled (More) Orders | The quantity of orders that have the Destination Delivery Status to be: DELIVERY PARTIALLY (MORE) | Number | _ | _ | 100 |
Unfulfilled Orders | The quantity of orders that have the Destination Delivery Status to be: UNFULFILLED | Number | _ | _ | 100 |
Not Yet Fulfilled Orders | The quantity of orders that have the Destination Delivery Status to be: NOT FULFILLED | Number | _ | _ | 100 |
Late Delivered Orders | The quantity of orders that have the Delivery task submitted on Mobile app at later time points than were planned on Web app | Number | _ | _ | 100 |
Declined Orders | The quantity of orders that were declined by the Transporter (The Transporter is in blacklist) | Number | _ | _ | 100 |
ST21 - Orders By Drivers
Report ST21 - Export instruction
- Click on Report Type field, select this report from the drop down menu
- Then, click on Date Range field. From the drop down calendars, select the date range during which the orders were created and executed
- Finally, click on Download button. The system will immediately gather data and export the report into a downloadable Excel template after a short moment
- (Optional) If you want to include a header in the Excel template, you can click on the toggle button Exclude Report Header . When that button changes to Include Report Header , in the Excel template there will be a header
Report ST21 - Information fields
Information field | Description | Data Type | Unit | Possible Values | Example |
---|---|---|---|---|---|
No. | Numerical order of the driver | ||||
Driver Code | Management code of the driver | ||||
Driver Name | Name of the driver | ||||
Vehicle Type | The vehicle type operated by the driver | ||||
Number Of Orders | Number of sales orders delivered by the driver | ||||
Total Order Weight | |||||
Total Order Volume | |||||
Planned Revenue | |||||
Planned Cost | |||||
Planned Distance | |||||
Planned Time | |||||
Actual Revenue | |||||
Actual Cost | |||||
Actual Distance | |||||
Actual Start Time | |||||
Actual End Time | |||||
Actual Time | |||||
VFR By Weight | |||||
Fulfilled Orders | |||||
Partially Fulfilled Orders | |||||
Unfulfilled Orders | |||||
Not Yet Fulfilled Orders | |||||
Number Of Off-200m Check-in |
ST22 - PDP KPI Scoreboard
Report ST22 - Export instruction
- Click on Report Type field, select this report from the drop down menu
Report ST22 - Information fields
- Below is the list of all information fields in the report
Information field | Description | Data type | Unit | Possible Values | Example |
---|---|---|---|---|---|
No. | Numerical Order | Number | - | - | 1 |
Delivery Date | The date when the order was performed | Date Format: Year-Month-Date (yyyy-mm-dd) | - | - | 2019-10-03 |
Truck Utilization (%) | The ratio of the number of trucks used during the selected date range over the total number of all available trucks | Number | percentage (%) | - | 9.09 |
Service Level (%) | The ratio of the number of delivered orders over the number of planned orders of all drivers | Number | percentage (%) | - | 33.33 |
Driver Adoption (%) | The ratio of the number of drivers who have used Abivin App over the total number of drivers | Number | percentage (%) | - | 9.09 |
Compliance Driver (%) | The ratio of Executed Tasks over Planned tasks of all drivers | Number | percentage (%) | - | 42.86 |
Delivery GPS Compliance | The ratio of the number of correctly submitted Check-in tasks (In the distance of 200 meters from the customer location) over the total Number of Check-in tasks submitted by all drivers | Number | percentage (%) | - | 52.7 |
Planned Distance (km) | The total planned distance of all vehicles | Number | kilometer (km) | - | 122.89 |
Actual Distance (km) | The total actual distance traveled by all vehicles | Number | kilometer (km) | - | 101.1 |
Kilometer Actual (Ratio) | The ratio of Actual Distance over Planned Distance of all vehicles | Number | percentage (%) | - | 34.3 |
ST23 - PDP Orders by a single driver
Report ST23 - Export instruction
- Click on Report Type field, select this report from the drop down menu
- Click on Date Range field, select the suitable date range from the drop down calendars
- Next, click on Select drivers field, select the driver for whom you want to export report from the drop down menu. You can select multiple drivers at once
- If you want to export report for all drivers, click on Choose All Drivers check box
- Finally, click on Download button. The system will immediately gather data and export the report into a downloadable Excel template after a short moment
- (Optional) If you want to include a header in the Excel template, you can click on the toggle button Exclude Report Header . When that button changes to Include Report Header , in the Excel template there will be a header
Report ST23 - Information fields
- Below is the list of all information fields in the report
Information field | Description | Data type | Unit | Possible values | Examples |
---|---|---|---|---|---|
No. | Numerical order | Number | _ | _ | 1 |
Order Date | The date when the order was performed | Date Format: Year-Month-Date (yyyy-mm-dd) | _ | _ | 2019-09-22 |
Driver Code | Code of the driver who delivered the order | Text & Number | _ | _ | Driver_01 |
Driver Name | Name of the driver who delivered the order | Text | _ | _ | John Doe |
Customer Code | Code of the customer who placed the order | Text & Number | _ | _ | Customer_01 |
Customer Name | Name of the customer who placed the order | Text & Number | _ | _ | John Doe |
Customer Address | Address of the customer who placed the order | Text & Number | _ | _ | 100 Doc Ngu, Hanoi, Vietnam |
Order code | Code of the order | Text & Number | _ | _ | SO_001 |
Order status | Execution status of the order at the time the report was generated | Text | _ | Open; Shipped | Open |
Planned Total revenue | Total revenue of the order as planned | Number | Currency unit (VND; MMK; Rp etc.) | _ | 10000000 |
Actual Total Revenue | Total Revenue of the order as actually performed | Number | Currency unit (VND; MMK; Rp etc.) | _ | 8000000 |
Fulfillment Status | Delivery result of the order at the time the report was generated | Text | _ | Fulfilled; Partially fulfilled; Not Yet Fulfillment; Unfulfilled | Not Yet Fulfillment |
Order Unfulfilled Reason | Reason the order was not delivered successfully | Text | _ | _ | Customer has closed |
Customer Lat | Latitude of the customer location | Number | _ | _ | 21.044640 |
Customer Long | Longitude of the customer location | Number | _ | _ | 105.813726 |
Checkin Lat | Latitude of the location where the driver submitted the check in task | Number | _ | _ | 21.044640 |
Check-in Long | Longitude of the location where the driver submitted the check in task | Number | _ | _ | 105.813726 |
Distance Difference (m) | The distance between the location where the driver submitted the 'Check in' task and the actual customer location | Number | m (meter) | _ | 20 |
Task Name | The most recent task on Mobile app of the driver at the time the report was exported | Text & Number | _ | _ | 4. John Doe |
Signature Status | Specify whether the customer has signed digitally upon receiving the products or not | Text | _ | Not yet; Signed | Signed |
Email Sending Status | Specify whether the Delivery Note email enclosed with the Proof of Delivery has been sent to the customer or not | Text | _ | Not yet; Sent | Sent |
Updated over 4 years ago