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

912912
  • 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
19011901
  • 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
699699

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
18921892
  • 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
19011901

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
18951895
  • Click on Date Range field, select the suitable date range from the drop down calendars
18951895
  • 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
18951895
  • If you want to export report for all drivers, click on Choose All Drivers check box
18951895
  • 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
19011901

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

_

_

  1. 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


Did this page help you?