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
337
  • 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

912
  • 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
1901
  • 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
699

ST15 - Products and Tasks by PDP Orders

Information fieldDescriptionData typeUnitPossible ValuesExample
No.Numerical orderNumber__1
Order CodeCode of the orderText & Number__SO-190829-0001
Order DateThe date when the order was deliveredDate
Format: Year-Month-Date (yyyy-mm-dd)
__2019-05-08
Driver NameName of the driver who delivered the orderText__John Doe
Truck Plate No.Plate numbers of the truck used to deliver the orderText & Number__31K3-5152
Truck TypeType of the truck used to deliver the orderText & Number__Twelve wheels truck
Origin Customer NameName of the origin customer, from where the products were picked upText__John Doe company
Origin Customer AddressAddress of the origin customer, from where the products were picked upText & Number__1st road, valley A, city B, country C
Destination Customer NameName of the destination customer, to where the products were deliveredText__John Doe company
Destination Customer AddressAddress of the destination customer, to where the products were deliveredText & Number__1st road, valley A, city B, country C
SKUThe product loaded in the orderText & Number
Format: (Product Code) Product Name
__(Product_A_Code) Product A Name
QuantityQuantity of the product loaded in the orderNumber__100
Quantity TypeUnit type of the product loaded in the orderText_Pallet; Case; Item etc.Pallet
Check ByName of the personnel who checked the orderText__John Doe
Fulfillment StatusDelivery result of the order at the time the report was generatedText_Fulfilled; Partially fulfilled; Not Yet Fulfillment; UnfulfilledFulfilled
Distance Difference (m)The distance that the driver actually traveled from the Origin Customer to the Destination CustomerNumber (Decimal)m (Meter)_90000.4
Trip HoursThe time duration during which the order was performedTime
Format: Hour:Minute:Second (hh:mm:ss)
_40:36:30
Arrival check-in Date/TimeThe specific Date and Time when the driver arrived at the Destination Customer locationDate/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/TimeThe specific Date and Time the Unloading task started at the Destination Customer locationDate/Time
(yyyy-mm-dd hh:mm:ss)
__2019-05-08 09:06:06
Signature StatusThe status of the customer signing digitally upon receiving the productsText_Signed; Not YetSigned
Signature Sign-on dateThe date on which the customer digitally signed upon receiving the productsDate
Format: Year-Month-Date (yyyy-mm-dd)
__2019-05-08
Email Sending StatusThe status of sending email enclosed with the Proof of DeliveryText_Not yet; SentSent

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
1892
  • 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
1901

Report ST16 - Information fields

Information fieldDescriptionData TypeUnitPossible ValuesExample
No.Numerical order of the Sales orderNumber--1
Order CodeManagement code of the Sales orderText & Number--S.O.#1
Branch NameName of the Branch that managed the Sales orderText & Number--Branch A1
Product NameName of the product loaded in the Sales orderText & Number--Product A1
Origin PickupName of the Origin Depot, where the Transporter vehicle will pick up productsText & Number--Depot A1
Destination DeliveryName of the Destination Depot, where the Transporter vehicle will drop off productsText & Number--Depot A1
TransporterName of the Transporter which have been selected to deliver the orderText & Number--Transporter A1
Vehicle TypeThe vehicle type that have been selected to deliver the orderText & Number--Vehicle Type A1
Transporter Service PriceThe 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
NumberCurrency unit
For example: VND
-4500000
After Discount RateThe 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
NumberPercentage (%)85%85%
SurchargeThe 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
NumberCurrency unit
For example: VND
500000
1000000
500000
Total Service PriceTotal 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
NumberCurrency unit
For example: VND
-234000
License PlateLicense plate numbers of the vehicle that delivered the orderText & Number--30K3-5155
Driver NameName of the driver who operated the delivery vehicleText & Number--John Doe
Driver Phone NumberPhone number of the driverNumber--012345678
Order Creation DateThe date on which the order was createdDate
Format: Date/Month/Year (dd/mm/yyyy)
--30/01/2020
Due dateThe 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 TimeThe date on which the Order is actually delivered to the Destination DepotDate
Format: Date/Month/Year (dd/mm/yyyy)
--30/01/2020
Planning StatusPlanning status of the Order at the time the report was exportedText-Approved
Not Submitted
Routed
Submitted
Approved
Origin Shipping StatusStatus of the Origin Depot's warehouseman handing products to the Transporter's driver at the time the report was exportedText-NOT FULFILLED
SHIP FULFILLED
SHIP PARTIALLY (LESS)
SHIP PARTIALLY (MORE)
SHIP UNFULFILLED
SHIP FULFILLED
Origin Pickup StatusStatus of the Transporter's driver picking up products at the Origin Depot at the time the report was exportedText-NOT FULFILLED
PICKUP FULFILLED
PICKUP PARTIALLY (LESS)
PICKUP PARTIALLY (MORE)
PICKUP UNFULFILLED
PICKUP FULFILLED
Destination Receiving StatusStatus of the Destination Depot's warehouseman receiving products from the Transporter's driver at the time the report was exportedText-NOT FULFILLED
RECEIVE FULFILLED
RECEIVE PARTIALLY (LESS)
RECEIVE PARTIALLY (MORE)
RECEIVE UNFULFILLED
RECEIVE FULFILLED
Destination Delivery StatusStatus of the Transporter's driver delivering products to the Destination Depot at the time the report was exportedText-NOT FULFILLED
DELIVERY FULFILLED
DELIVERY PARTIALLY (LESS)
DELIVERY PARTIALLY (MORE)
DELIVERY UNFULFILLED
DELIVERY FULFILLED
Service Payer Organization NameOrganization Name of the Depot that has to pay the Transport Service price of the OrderText & Number--Depot B52
Service Payer Organization DescriptionDescription 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 fieldDescriptionData TypeUnitPossible ValuesExample
Transporter CodeThe management code of the TransporterText & Number__Transporter_ABC
Transporter NameName of the TransporterText & Number__John Doe transport service
Number Of OrdersThe quantity of orders performed by the Transporter during the selected date rangeNumber__122
Total Order WeightThe total weight of all orders performed by the TransporterNumberKilogram (kg)_23000
Total Order VolumeThe total volume of all orders performed by the TransporterNumberCubic metre (m3)_23000
Total Service CostThe total transport service cost of all orders performed by the TransporterNumberCurrency Unit
For example: VND
_40000000
Fulfilled OrdersThe quantity of orders that have the Destination Delivery Status to be:
DELIVERY FULFILLED
Number__100
Partially Fulfilled (Less) OrdersThe quantity of orders that have the Destination Delivery Status to be:
DELIVERY PARTIALLY (LESS)
Number__100
Partially Fulfilled (More) OrdersThe quantity of orders that have the Destination Delivery Status to be:
DELIVERY PARTIALLY (MORE)
Number__100
Unfulfilled OrdersThe quantity of orders that have the Destination Delivery Status to be:
UNFULFILLED
Number__100
Not Yet Fulfilled OrdersThe quantity of orders that have the Destination Delivery Status to be:
NOT FULFILLED
Number__100
Late Delivered OrdersThe quantity of orders that have the Delivery task submitted on Mobile app at later time points than were planned on Web appNumber__100
Declined OrdersThe 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 fieldDescriptionData TypeUnitPossible ValuesExample
No.Numerical order of the driver
Driver CodeManagement code of the driver
Driver NameName of the driver
Vehicle TypeThe vehicle type operated by the driver
Number Of OrdersNumber 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 fieldDescriptionData typeUnitPossible ValuesExample
No.Numerical OrderNumber--1
Delivery DateThe date when the order was performedDate
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 trucksNumberpercentage (%)-9.09
Service Level (%)The ratio of the number of delivered orders over the number of planned orders of all driversNumberpercentage (%)-33.33
Driver Adoption (%)The ratio of the number of drivers who have used Abivin App over the total number of driversNumberpercentage (%)-9.09
Compliance Driver (%)The ratio of Executed Tasks over Planned tasks of all driversNumberpercentage (%)-42.86
Delivery GPS ComplianceThe 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 driversNumberpercentage (%)-52.7
Planned Distance (km)The total planned distance of all vehiclesNumberkilometer (km)-122.89
Actual Distance (km)The total actual distance traveled by all vehiclesNumberkilometer (km)-101.1
Kilometer Actual (Ratio)The ratio of Actual Distance over Planned Distance of all vehiclesNumberpercentage (%)-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
1895
  • Click on Date Range field, select the suitable date range from the drop down calendars
1895
  • 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
1895
  • If you want to export report for all drivers, click on Choose All Drivers check box
1895
  • 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
1901

Report ST23 - Information fields

  • Below is the list of all information fields in the report
Information fieldDescriptionData typeUnitPossible valuesExamples
No.Numerical orderNumber__1
Order DateThe date when the order was performedDate
Format: Year-Month-Date (yyyy-mm-dd)
__2019-09-22
Driver CodeCode of the driver who delivered the orderText & Number__Driver_01
Driver NameName of the driver who delivered the orderText__John Doe
Customer CodeCode of the customer who placed the orderText & Number__Customer_01
Customer NameName of the customer who placed the orderText & Number__John Doe
Customer AddressAddress of the customer who placed the orderText & Number__100 Doc Ngu, Hanoi, Vietnam
Order codeCode of the orderText & Number__SO_001
Order statusExecution status of the order at the time the report was generatedText_Open; ShippedOpen
Planned Total revenueTotal revenue of the order as plannedNumberCurrency unit (VND; MMK; Rp etc.)_10000000
Actual Total RevenueTotal Revenue of the order as actually performedNumberCurrency unit (VND; MMK; Rp etc.)_8000000
Fulfillment StatusDelivery result of the order at the time the report was generatedText_Fulfilled; Partially fulfilled; Not Yet Fulfillment; UnfulfilledNot Yet Fulfillment
Order Unfulfilled ReasonReason the order was not delivered successfullyText__Customer has closed
Customer LatLatitude of the customer locationNumber__21.044640
Customer LongLongitude of the customer locationNumber__105.813726
Checkin LatLatitude of the location where the driver submitted the check in taskNumber__21.044640
Check-in LongLongitude of the location where the driver submitted the check in taskNumber__105.813726
Distance Difference (m)The distance between the location where the driver submitted the 'Check in' task and the actual customer locationNumberm (meter)_20
Task NameThe most recent task on Mobile app of the driver at the time the report was exportedText & Number__4. John Doe
Signature StatusSpecify whether the customer has signed digitally upon receiving the products or notText_Not yet; SignedSigned
Email Sending StatusSpecify whether the Delivery Note email enclosed with the Proof of Delivery has been sent to the customer or notText_Not yet; SentSent