AFAQY Knowledge Base
    Reports
    Reports

    Reports

    📖 Afaqy Knowledge Base / Tepra / Fleet / Reports

    CONTENTS
    ‣
    IVMS
    • Monitoring
    • Tracking
    • Reports
    • Events
    • Messages
    • Dashboard
    • Notifications
    • Vehicles
    • Drivers
    • Trailers
    ‣
    Fleet
    • Prerequisites
    • Purpose & Functionality
    • Integration Across Modules
    • Key Capabilities
    • Frequently Asked Questions
    ‣
    Dashboard
    • View
    • Actions
    ‣
    Vehicles
    • View
    • Actions
    ‣
    Vehicle Assignments
    • View
    • Assign
    • Actions
    • Quick Control Panel
    ‣
    Preventive Maintenance
    • View
    • Create
    • Actions
    ‣
    Meters History
    • View
    • Create
    • Actions
    ‣
    Engine Hours
    • View
    • Create
    • Actions
    ‣
    Issues
    • View
    • Create
    • Actions
    • Quick Control Panel
    ‣
    Work Order
    • View
    • Create
    • Actions
    ‣
    Accidents
    • View
    • Create
    • Actions
    ‣
    Fuel History
    • View
    • Create
    • Actions
    ‣
    Inventory
    ‣
    Spare Parts
    • View
    • Actions
    • Create
    ‣
    Warehouses
    • View
    • Actions
    ‣
    Spare Part Requests
    • View
    • Actions
    ‣
    Users
    • View
    • Actions
    ‣
    Inspections Forms
    • View
    • Actions
    • Create
    ‣
    Completed Inspection
    • View
    • Actions
    • Create
    ‣
    Expenses
    ‣
    Expenses List
    • View
    • Actions
    • Create
    ‣
    Expenses Archive
    • View
    ‣
    Vendors
    ‣
    Vendors List
    • View
    • Actions
    ‣
    Vendors Archive
    • View
    ‣
    Reports
    • Create
    ‣
    Report Categories
    • NADEC Reports
    • Vehicles Reports
    • Accidents Reports
    • Parts Reports
    • Work Order Reports
    • Service Entry Reports
    • Vendor Reports
    • Completed Inspection Reports
    ‣
    Settings
    • General Settings
    • Vehicles
    • Inspections
    • Work Order
    • Inventory
    • Accidents
    • Service Entry
    • Users
    • Reminders
    • Preventive Maintenance
    • Vendors
    • Expenses
    • Dashboard

    The Reports module offers detailed analytics and summaries across all aspects of fleet operations.

    image
    image
    image

    Create

    To generate a new report in the Fleet Reports module, follow these steps:

    1. Browse the report categories (e.g., Vehicles, Parts, Work Order, Service Entry).
    2. Click on the report name you wish to generate.

    Depending on the report:

    • Some reports (like Trucks Details) will prompt you to select specific parameters, such as vehicle type or group, before generating the report.
    • Others will directly open a list view containing report data, ready to filter and export.
    1. After selecting any required inputs, click Submit to generate the report.
    2. View & Analyze Data
      1. Reports display in a dynamic table or with visual charts. You can:

      2. Sort columns
      3. Search by keyword
      4. Expand rows for more detail (if available)

    Report Categories

    Reports are divided into eight main categories:

    1. NADEC Reports
    2. Vehicles Reports
    3. Accidents Reports
    4. Parts Reports
    5. Work Order Reports
    6. Service Entry Reports
    7. Vendor Reports
    8. Completed Inspection Reports

    Each report provides filtering, searching, sorting, and export capabilities to support operational decision-making and ensure traceability across fleet activities.

    NADEC Reports

    This category includes specialized reports tailored for NADEC operations, covering fleet assets and human resources in detail. It includes the following report types:

    • Trucks Details
    • Cars Details
    • Manpower
    • Resigned Employees
    • Vehicle Status – By Region

    1.1 Trucks Details Report

    Description

    Displays details about all NADEC trucks based on their types and groups. Helps in managing truck distribution and type-based insights.

    Insights Provided

    • Number and type of trucks
    • Group-wise truck distribution
    • Overview of truck assets under NADEC

    View

    • Tabular data grouped by:
      • Truck Type
      • Vehicle Group
      • Quantity and identifiers (if applicable)

    Required Input

    • Vehicle Types
    • Vehicle Groups

    Actions

    • Search by truck group or type
    • Filter by available dropdowns
    • Export CSV, XLS, XLSX, or PDF

    1.2 Cars Details Report

    Description

    Summarizes all cars registered under NADEC, categorized by type and group, aiding fleet composition visibility.

    Insights Provided

    • Vehicle type-wise breakdown of cars
    • Group affiliations
    • Count of cars per category

    View

    • Table sorted by:
      • Car Type
      • Group
      • Quantity or IDs

    Required Input

    • Vehicle Types
    • Vehicle Groups

    Actions

    • Search and filter by fields
    • Export CSV, XLS, XLSX, or PDF

    1.3 Manpower Report

    Description

    Provides a detailed list of manpower records associated with the NADEC fleet, supporting operational planning and allocation.

    Insights Provided

    • Personnel count
    • Role/type of manpower
    • Group or region allocation

    View

    • Table of manpower data including:
      • Name / ID
      • Position
      • Assigned Group or Region

    Required Input

    • Employee Role
    • Region (optional)
    • Group (optional)

    Actions

    • Search, Filter, and Sort
    • Export in standard formats

    1.4 Resigned Employees Report

    Description

    Tracks details of employees who have resigned, useful for turnover analysis and fleet HR reporting.

    Insights Provided

    • Resignation dates
    • Former group/vehicle association
    • Employee roles and IDs

    View

    • Table with:
      • Employee Name/ID
      • Resignation Date
      • Previous Assignment Details

    Required Input

    • Date Range
    • Group / Role (optional)

    Actions

    • Search and Filter
    • Export options available

    1.5 Vehicle Status – By Region Report

    Description

    Displays the operational status of vehicles grouped by their region, helping assess fleet readiness in each operational area.

    Insights Provided

    • Status distribution by region
    • Active vs inactive assets per location
    • Regional vehicle availability

    View

    • Table showing:
      • Region Name
      • Vehicle Status (Active, In Service, Down, etc.)
      • Count of Vehicles per Status

    Required Input

    • Region
    • Vehicle Status
    • Date Range (optional)

    Actions

    • Search, Filter, and Sort
    • Export in preferred formats

    Vehicles Reports

    This category includes three report types:

    • Expenses Report
    • Status Report
    • Meters Cost Report

    2.1 Expenses Report

    Description

    Provides an overview of all fleet-related expenses including fuel, insurance, services, and other cost categories. The report displays expense details per vehicle, along with summarized cost indicators at the top.

    Insights Provide

    • Total fuel, insurance, service, and other expenses
    • Expense breakdown by vehicle, type, date, and status
    • Status-wise monitoring of financial activity

    View

    • Summary widgets for each expense category (Fuel, Insurance, Service, Other, Total)
    • Tabular view including:
      • Vehicle Name / Plate Number
      • Expense Name
      • Expense Type
      • Date
      • Status
      • Actions

    Required Input

    • Vehicle
    • Expense Type
    • Vehicle Group (optional)
    • Vehicle Type (optional)
    • Status (optional)
    • Date range

    Actions

    • Search: By vehicle or field
    • Sort: All visible columns
    • Filter: Via the filter button to narrow results
    • Export: CSV, XLS, XLSX, or PDF

    2.2 Status Report

    Description

    Tracks the operational statuses of all vehicles in the fleet over time. Useful for evaluating vehicle availability, utilization, and identifying downtime patterns.

    Insights Provided

    • Vehicle name, current/previous statuses
    • Start and end dates for each status
    • Duration spent in each state

    View

    • Status table including:
      • Vehicle Name
      • Status
      • Status Date
      • End Date
      • Duration

    Required Input

    • Vehicle (active or archived)
    • Vehicle Groups
    • Date range

    Actions

    • Search, Sort, and Filter: By vehicle name, status, date, group, etc.
    • Export: CSV, XLS, XLSX, or PDF

    2.3 Meters Cost Report

    Description

    Analyzes cost efficiency of vehicle usage by calculating cost per meter and cost per engine hour across the fleet.

    Insights Provided

    • Average cost per meter by vehicle type
    • Per-vehicle analysis including:
      • Total Cost
      • Total Meters
      • Total Engine Hours
      • Cost per Meter
      • Cost per Hour
      • Duration

    View

    • Bar chart for cost per meter by vehicle type
    • Detailed table for cost breakdown

    Actions

    • Search, Sort, and Filter by any input field
    • Export: CSV, XLS, XLSX, or PDF

    Required Input

    • Vehicle (active or archived)
    • Date range
    • Status
    • Vehicle Groups
    • Vehicle Type

    Accidents Reports

    This category includes a single yet critical report type that helps in monitoring and analyzing vehicle accident history across the fleet.

    • Accidents Report

    3.1 Accidents Report

    Description

    Provides a comprehensive view of all fleet vehicle accidents recorded in the system. This report supports risk assessment, safety monitoring, and insurance tracking.

    Insights Provided

    • Total number of recorded accidents
    • Vehicle(s) involved in each incident
    • Dates and locations of accidents
    • Associated costs or damage notes (if available)

    View

    • Tabular list containing:
      • Vehicle Name / Plate Number
      • Accident Date
      • Location
      • Description or Notes
      • Status (if applicable)
      • Related Driver (if recorded)

    Required Input

    • Vehicle
    • Date Range
    • Vehicle Group (optional)
    • Region or Location (optional)

    Actions

    • Search: By vehicle, date, or keyword
    • Sort and Filter: By date, vehicle, or location
    • Export: CSV, XLS, XLSX, or PDF

    Parts Reports

    This category includes three report types:

    • Parts by Usage Report
    • Parts by Vehicle Report
    • Spare Parts Flow Report

    4.1 Parts by Usage Report

    Description

    Provides an overview of how spare parts are consumed across the fleet. It highlights the most frequently used and most expensive parts.

    Insights Provided

    • Top parts by total cost
    • Top parts by total usage
    • Detailed list of part usage across vehicles

    View

    • Two graphical charts:
      • Top Parts by Cost
      • Top Parts by Usage
    • Tabular view including:
      • Part Name
      • Usage Count
      • Number of Vehicles Using It
      • Last Usage Date
      • Total Cost

    Required Input

    • Part Name (optional)
    • Usage (optional)
    • Last Usage Date (optional)

    Actions

    • Search: By part name
    • Sort and Filter: By usage, date, and number of vehicles
    • Export: CSV, XLS, XLSX, or PDF

    4.2 Parts by Vehicle Report

    Description

    Shows a breakdown of all parts used by each vehicle, including total cost and quantity consumed. Useful for assessing maintenance intensity per vehicle.

    Insights Provided

    • Number of parts used per vehicle
    • Total parts cost per vehicle
    • Breakdown of parts, quantities, and related work orders

    View

    • Summary list:
      • Vehicle Name
      • Number of Consumed Parts
      • Total Cost
    • Expandable detailed view per vehicle:
      • Part Name
      • Related Work Order IDs
      • Quantity
      • Cost per Part
      • Total Cost

    Required Input

    • Vehicle
    • Vehicle Group
    • Location
    • Completion Date (range)

    Actions

    • Search, Sort, and Filter by any field
    • Expand vehicle row for details
    • Export: CSV, XLS, XLSX, or PDF

    4.3 Spare Parts Flow Report

    Description

    Offers a log-based summary of spare part movements across inventory and vehicle usage, giving insights into stock and consumption trends.

    Insights Provided

    • Flow of parts in/out of inventory
    • Movement dates and affected vehicles
    • Cost and quantity of each flow

    View

    • Table showing:
      • Part Name
      • Flow Type (In/Out)
      • Quantity
      • Source/Destination (e.g., Warehouse or Vehicle)
      • Date
      • Cost

    Required Input

    • Part Name
    • Date Range
    • Flow Type

    Actions

    • Search, Sort, and Filter by any field
    • Export: CSV, XLS, XLSX, or PDF

    Work Order Reports

    This category includes three detailed report types:

    • Work Orders per Vehicle Report
    • Work Order Status Summary Report
    • Work Order Summary Report

    5.1 Work Orders per Vehicle Report

    Description:

    Shows a breakdown of all work orders carried out by each vehicle, including cost distribution and detailed service history.

    Insights Provided:

    • Labor and parts cost per vehicle
    • Total number of work orders per vehicle
    • Expanded list of individual work orders with key maintenance details

    View

    • Summary list:
      • Vehicle Name / Plate Number
      • Number of Work Orders
      • Total Work Order Cost
    • Expandable view per vehicle:
      • Work Order ID
      • Start & Completion Dates
      • Duration
      • Vendor
      • Odometer & Engine Hours
      • Service Tasks & Resolved Issues
      • Location
      • Labor Cost, Parts Cost, and Total Cost

    Required Input

    • Vehicle
    • Vehicle Group
    • Vehicle Type
    • Make
    • Location
    • Start and Completion Dates

    Actions

    • Search, Sort, and Filter
    • Expand vehicle row to view related work orders
    • Export: CSV, XLS, XLSX, or PDF

    5.2 Work Order Status Summary Report

    Description

    Provides a list of all work orders on the system, categorized by current status, allowing teams to track ongoing and completed maintenance jobs.

    Insights Provided

    • Status distribution of work orders
    • Full details per work order
    • Maintenance performance analysis by vendor, unit, and task

    View

    • Work Order ID
    • Related Vehicle
    • Status
    • Location
    • Start & Completion Dates
    • Duration
    • Vendor
    • Odometer & Engine Hours
    • Service Tasks & Resolved Issues
    • Labor Cost, Parts Cost, and Total Cost

    Required Input

    • Vehicle
    • Vehicle Group
    • Status
    • Location
    • Unit
    • Vendor
    • Start and Completion Dates

    Actions

    • Search, Sort, and Filter by any field
    • Export: CSV, XLS, XLSX, or PDF

    5.3 Work Order Summary Report

    Description

    Provides a high-level summary of all work orders logged in the system, with tools to analyze workload, cost, and vehicle engagement.

    Insights Provided

    • Total count of work orders per vehicle
    • Distribution by type, status, and duration
    • Overview of costs across work orders

    View

    • List of all work orders
    • Basic details including:
      • Work Order ID
      • Related Vehicle
      • Vendor
      • Status
      • Start & End Dates
      • Cost Summary

    Required Input

    • Work Order information
    • Vehicle or Vendor (optional)
    • Date Range (optional)

    Actions

    • Search, Sort, and Filter
    • Export: CSV, XLS, XLSX, or PDF

    Service Entry Reports

    This category includes two key reports that help you evaluate the performance and cost of services performed across your fleet:

    • Services Summary Report
    • Service Tasks Summary Report

    6.1 Services Summary Report

    Description

    Provides a full overview of all service entries performed in the system, helping you analyze service activity, vehicle maintenance frequency, and related costs.

    Insights Provided

    • Total labor and parts costs per vehicle
    • Number of service entries and work orders per vehicle
    • Vehicle statuses and group associations
    • Last service dates

    View

    • Vehicle Name / Plate Number
    • Vehicle Status
    • Last Service Date
    • Number of:
      • Service Entries
      • Work Orders
      • Service Tasks
    • Total Cost, Total Labor, and Total Parts
    • Vehicle Group(s)

    Required Input

    • Vehicles
    • Vehicle Type
    • Vehicle Status
    • Service Entries
    • Number of Work Orders
    • Number of Service Tasks
    • Total Labor, Total Parts, Total Cost
    • Last Service Date

    Actions

    • Search, Sort, and Filter by any field
    • Export: CSV, XLS, XLSX, or PDF

    6.2 Service Tasks Summary Report

    Description

    Get a comprehensive view of all service tasks executed by your fleet. This report helps identify the most frequent and cost-heavy maintenance activities.

    Insights Provided

    • Top service tasks by frequency
    • Top service tasks by cost
    • Service tasks grouped by vehicle
    • Usage trends and cost per task

    View

    • Top Service Tasks by:
      • Vehicle (Chart)
      • Cost (Chart)
    • Tabular List:
      • Service Task Name
      • Usage Count
      • Related Vehicles
      • Last Used Date
      • Total Cost (Labor + Parts)

    Required Input

    • Service Task
    • Usage
    • Vehicles
    • Total Labor, Parts, and Cost
    • Last Used Date

    Actions

    • Search, Sort, and Filter by task or vehicle
    • Export: CSV, XLS, XLSX, or PDF

    Vendor Reports

    This category includes one report that helps evaluate external vendor-related spending across the fleet.

    • Expenses per Vendor Report

    7.1 Expenses per Vendor Report

    Description

    Provides a breakdown of all expenses attributed to vendors, allowing you to track spending by third-party providers, analyze cost efficiency, and support budgeting or vendor negotiations.

    Insights Provided

    • Total expenses per vendor
    • Expense types (e.g., service, parts, labor) handled by each vendor
    • Frequency and amount of vendor interactions
    • Date-wise distribution of vendor payments

    View

    • Tabular report including:
      • Vendor Name
      • Expense Type
      • Expense Amount
      • Vehicle (if linked)
      • Expense Date
      • Notes or Descriptions

    Required Input

    • Vendor Name
    • Expense Type
    • Vehicle (optional)
    • Date Range

    Actions

    • Search: By vendor, expense type, or vehicle
    • Sort and Filter: Based on vendor, date, or cost
    • Export: CSV, XLS, XLSX, or PDF

    Completed Inspection Reports

    This category includes one report designed to help you review and audit completed vehicle inspections across your fleet.

    • Completed Inspections Report

    8.1 Completed Inspections Report

    Description

    Summarizes all inspection forms completed for vehicles, helping ensure compliance with safety standards and providing visibility into recurring issues or inspection failures.

    Insights Provided

    • Number of completed inspections per vehicle
    • Inspection dates and assigned inspectors
    • Completion status and form name
    • Associated issues or failed items (if any)

    View

    • Tabular report including:
      • Vehicle Name / Plate Number
      • Inspection Form Name
      • Inspector Name
      • Date of Inspection
      • Completion Status
      • Comments or Notes

    Required Input

    • Vehicle
    • Inspection Form Name
    • Inspector
    • Date Range
    • Completion Status (optional)

    Actions

    • Search: By vehicle, form, or inspector
    • Sort and Filter: Based on date, vehicle, or status
    • Export: CSV, XLS, XLSX, or PDF
    ℹ️

    Some reports include interactive charts and drill-down features for deeper analysis.