Fuel management report

Submitted by rd on Fri, 12/02/2022 - 10:31

1. Purpose

- Allows the user to enter data on the amount of fuel supplied, supported, and beginning inventory for each day, thereby generating a monthly fuel import–export–inventory report.

2. Implementation conditions

- The customer is granted permission for the VN59 option.

3. Implementation instructions

- Go to menu Fuel Management/Fuel management report

-The function screen consists of two sections:

  • Fleet Information section: Allows the user to select search parameters.

  • Report section: Displays report details based on the user’s selection.

- Fleet Information section: Includes the following details:

  • From: Select the start date for the report query.

  • To: Select the end date for the report query.

  • Fuel In/Out/Inventory Report: Default option, allows selecting among Fuel Supply Report, Fuel Support Report, and Fuel Inventory Report.

  • Fleet: Default is Entire Fleet. Click the icon to select a specific fleet.

  • Vehicle: The user checks the checkbox to select the vehicles to view.

  • Click Search to display the results.

- Report section: Corresponding to each report type selected in the Fleet Information section, the report details will be displayed accordingly.

 

- Import existing reports 

  • License Plate: Vehicle license number.

  • Starting Km: The odometer reading at the beginning of the month (from the Fuel Data Entry Report).

  • Ending Km: The odometer reading at the end of the month (from the Fuel Data Entry Report).

  • Km: Calculated as Ending Km – Starting Km.

  • Driver’s Name: Name of the driver.

  • Fuel Inventory: Total remaining fuel for the month.

  • Fuel Supplied: Total amount of fuel supplied during the month.

  • Fuel by GPS (Km): Calculated as Km (GPS) × 1 / Fuel Consumption (km/l) or Km (GPS) × Fuel Consumption (l/km).

  • Fuel Difference: Fuel Supplied – Fuel by GPS (Km).

  • Km (GPS): Distance traveled during the month according to the GPS device.

  • Km Difference: Km – Km (GPS).

 

- Oil supply report    : Allows the user to enter the amount of fuel supplied each day and automatically summarizes the total monthly fuel supply for each vehicle by double-clicking the desired date.

  • License Plate: Vehicle license number.

  • Driver’s Name: Name of the driver.

  • Total: Total amount of fuel supplied during the month.

  • Day 1/2/.../31: Amount of fuel supplied each day (double-click the desired date to enter data).

​​​​​

 

- Support oil report    : Allows the user to enter the additional supported fuel amount for each day and automatically summarizes the total supported fuel for the month for each vehicle by double-clicking on the desired date.

  • License Plate: Vehicle license number.

  • Driver’s Name: Name of the driver.

  • Total: Total amount of supported fuel during the month.

  • Day 1/2/.../31: Amount of supported fuel for each day (double-click the desired date to enter data).

 

- Oil inventory report    : Allows the user to enter the daily remaining fuel amount and automatically summarizes the total monthly fuel inventory for each vehicle by double-clicking the desired date.

  • License Plate: Vehicle license number.

  • Driver’s Name: Name of the driver.

  • Total: Total remaining fuel during the month.

  • Day 1/2/.../31: Daily remaining fuel amount (double-click the desired date to enter data).

+ Select icon   to print report

+ Select the icon   to download the report in excel format

+ Select icons   to customize display columns, customize license plates on reports and set up printing signatures