Reports

📘

To maintain the system performance, we currently restrict the date range to export reports to no more than 1 month

Compulsory Configurations

• You need to enable the configuration Reports at both the Manufacturer and the Branch
• You need to enable the module Report for the User group. Refer to this article: Manage Users

🚧

Report Export Permission

At the moment, only the user accounts that belong to the Manufacturer and Branch can view and export reports. User accounts that belong to the lower-level Organization Types, such as Depot, will not have this permission

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

📘

The steps outlined below only apply to the following reports: ST02, ST04, ST05, ST08, ST09, ST10, ST12. For other reports, you will need to do additional steps

• Step 1: Select the report: Click on the field below the text 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 your selected date range exceeds 31 days, there will be an error message as below. In this case, please select another date range.

• Note: If the language for display is a language other than Vietnamese (for example, English, Indonesian, Japanese...), the default language of reports is English.

• Step 3: Select whether there will be a header in the report or not By default, you will see a toggle button named Exclude Report Header. When you leave this button off, there will not be a header of 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, as in screenshots 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 template shortly

ST01 - Orders By All Drivers

• Calculation Formula
• Re-delivered Order = Total Not-yet-fulfilled Orders + Total Unfulfilled Orders
• Net Re-delivered Revenue = Number Of Cases x Case Price + Number Of Items x Item Price
• Net Revenue = Number Of Cases x Case Price + Number Of Items x Item Price
• Total Actual Time = Check out Time - Check in Time

ST02 - KPI Scoreboard

• Calculation Formula
• VFR (Volume Fill Rate) = Sum of VFR of all trips/ Number of trips of all trucks
• Truck Utilizations (%) = Vehicle Used/Total Vehicles (Total vehicles include active vehicles and inactive ones)
• Service Level (%) = Total delivered orders/ Total planned orders of all drivers (Total delivered orders include Partially Fulfilled Orders and Fulfilled Orders)
• Driver Adoption ratio = Number of drivers who have used Abivin App during delivery trips/Total number of drivers in the route plan
• Compliance Driver ratio = All Executed Task/ Planned tasks of all drivers
• Delivery GPS Compliance = Number of correct Checkin (within 200m from the delivery stop)/ Total Number of Checkin of all drivers

ST02.2 - KPI MTD Scoreboard

• Calculation Formula
• Average VFR by Volume = Volume of all product going out of each Depot / Total capacity of all assigned trucks of each depot x 100%
• Planned Time Utilization = "(A) Planned working time of each deliveryman for 1 day / working hour in driver's contract x 100%
  Result: Average of (A) of all deliverymen of each depot"
• Actual Time Utilization = "(B) Actual working time of each deliveryman for 1 day / working hour in driver's contract x 100%
  Result: Average of (B) of all deliverymen of each depot (%)"
• Average Transaction Time = "(C) Average Service time of each truck at each stop
  Result: Average of (C) all truck of each depot"
• Average Drop Point = "(D) Average number of the stop of each trip, for each truck
  Result: Average of (D) of all truck of each depot"
• Percentage by Value of On-time Delivery (sponsor items) = Percentage of on-time delivery: Sum by value of all orders completed on the planned date with sponsored items / Sum by value of all order with sponsored items x 100%
• Percentage by Value of On-time Delivery (non-sponsor items) Percentage of on-time delivery: Sum by value of all orders completed on the planned date with non-sponsor items / Sum by value of all orders with non sponsor items x 100%
• Percentage by Value of Rejected orders (sponsor items) = Percentage of rejected delivery: Sum by value of all orders rejected on the planned date with sponsor items / Sum by value of all orders on the planned date with sponsor items x 100%
• Percentage by Value of Rejected orders (non-sponsor items) = Percentage of rejected delivery: Sum by values of all orders rejected on the planned date with non-sponsor items / sum by value of all order on the planned date with non-sponsor items x 100%
• Driver Adoption = Total number of completed tasks through mobile of all deliverymen / Total number of tasks of all deliverymen of each depot x 100%
• Planner Adoption = Total number of orders vRoute is able to plan / Total number of orders input to vRoute x 100%
• Total Adoption = Average of driver and planner compliance x 100%
• Delivery GPS Compliance = Number of tasks completed by driver, for POD, within 60m of each store, for all store/ total number of tasks of all deliverymen x 100%

ST03 - Orders By Single Driver

• (*): The data of this field is directly affected by the delivery result that the driver actually submitted on the Mobile App:
• Actual Total Revenue = Planned Total Revenue, if the delivery result was submitted as Completed
• Actual Total Revenue < Planned Total Revenue, if the delivery result was submitted as Partly Delivered
• The data cell is left blank, if the delivery result was submitted as Not Completed

ST04 - Routes By Single Driver

ST05 - Inventory By products

• Calculation Formula
• Inventory Begin = On-hand Quantity at 0h of the start of the selected date range
• Inventory Purchase = The number of products in Purchase orders with status Put Away + Total Increase in the on-hand quantity of that product during the selected date range.
• Inventory Sale = The number of products in Sale orders with status Shipped + Total Decrease in the on-hand quantity of that product during the selected date range.
• Inventory End of a selected date range = Inventory Begin of the date range + Inventory Purchase during the selected date range - Inventory Sale during the selected date range

ST06 - Orders And Products

• To download this report, first follow from Step 1 to Step 3 that have been described in the section General steps to generate and export report. Then, before you click on Download, please take the additional steps below.
• Step 4: Select Information fields: Click on the field below the text Shown Columns, then select the appropriate information fields on the drop-down menu by clicking on the corresponding check box icon . When that icon turns to , that means an information field has been selected and will be presented on the report

• Step 5: Select Driver: Click on the Select Driver field. Scroll the drop-down menu up and down to find the appropriate driver, or you could directly input the Username/Full Name of the desired driver into the search bar, then select from the drop down menu. If you want to export report for all drivers, click on the check box Choose All Drivers

ST07 - Customers and Orders by date and by a single driver

• This report is designed specifically for orders of VRP model

• (*): The data of this field is directly affected by the delivery result that the driver actually submitted on the Mobile App:
• Actual Total Revenue = Planned Total Revenue, if the delivery result was submitted as Completed
• Actual Total Revenue < Planned Total Revenue, if the delivery result was submitted as Partly Delivered
• The data cell is left blank, if the delivery result was submitted as Not Completed

ST08 - Trip Utilization By Vehicles

• This report demonstrates the average amount of weight and volume that were utilized per trip by all the vehicles of the organization. This will help you manage your fleet more effectively as it can tell whether there is a vehicle having a low utilization rate so that you can make adjustments.

• Calculation Formula
• Weight Utilization = (Planned Total Weight / Vehicle Weight Capacity) / Number of Trips x 100%
• Volume Utilization = (Planned Total Volume / Vehicle Volume Capacity) / Number of Trips x 100%

ST09 - Total Orders By All Vehicles

• Dispatchers can refer to this type of report to see an overview of the orders assigned to each vehicle. In this report, you can know the amount of orders along with their weight and volume in total that each vehicle was in charge of. In addition, the number of orders is also divided into four categories based on the delivery results: Fulfilled Orders; Partially Fulfilled Orders; Unfulfilled Orders; Not Yet Fulfilled Orders

ST10 - Total Routes By All Vehicles

• This type of report is used for collecting key statistics of the routes assigned to each vehicle. Those statistics help dispatchers to see if the vehicle went according to plan, considering its traveling distance and time. Notably, they can also be aware of the vehicle's average speed, the time the drivers spent doing their tasks on the Mobile App and the number of times when the check-in location is more than 200 meters away from the store. This report is important when dispatchers want to keep track and know the efficiency of the drivers' daily delivery tasks

• Calculation Formula
• Actual Average Speed = Actual Distance / Actual Time

ST11 - Route By Single Vehicle

• This type of report gathers data from a single vehicle. Therefore, after selecting the Date Range, you have to select the vehicle from which you want information

• The purpose of this report is similar to that of the report ST10 - Routes By All Vehicles. The only difference is that this report uses the data of a single vehicle based on each of its delivery dates

• Calculation Formula
• Actual Average Speed = Actual Distance / Actual Travelling Time

ST12 - Order Status

• This type of report displays the detailed information of all the orders within the Date Range you have selected. Apart from the key information of the order such as its weight, volume, time window or fulfillment status , here you can also have a quick overview of who the customer of the order is, which driver is in charge of the order and which vehicle was assigned to deliver the order. Thus, the important objective of the report is to let the dispatchers notice the orders that have not been delivered on time, then they can trace back to the driver who is in charge and find out the possible reasons.

ST13 - Balance Sheet By Single Driver

• You have to select a driver before downloading this type of report as it only uses the data of a single driver

• Dispatchers use this type of report to know the amount of money actually collected by each driver compared to the plan. This is crucial for cases when the amount of cash collected is not equal to the amount that drivers are supposed to collect. The dispatchers can know the cause for those cases based on the delivery status of the order, or they can look into more detail by contacting the driver in charge of the order as the information of the drivers and salesmen are also stated in this report

• (*): The data of this field is directly affected by the delivery result that the driver actually submitted on the Mobile App:
• Actual Total Revenue = Planned Total Revenue, if the delivery result was submitted as Completed
• Actual Total Revenue < Planned Total Revenue, if the delivery result was submitted as Partly Delivered
• The data cell is left blank, if the delivery result was submitted as Not Completed

ST14 - Delivery Statistics

• To download this type of report, after selecting the Date Range, you have to select Salesman in order for the report to gather data information of the salesman who placed the order. You can also tick the Choose All Salesman checkbox to gather data of all the salesmen who placed the orders within the chosen Date Range

• This type of report will help dispatchers be aware of which order was placed by which salesman as well as the revenue generated from that order. Therefore, it will be easier to keep track of the sales figures and assess the KPIs of each salesman