Asset - Due for Service Report

This report identifies assets that have met or exceeded their allowed usage and are due for servicing, helping to quickly highlight equipment that is due or overdue for service based on actual usage.

How it works

• Calculates total Days in Service from asset movement records (tblAssetran)

• Includes:

  • Completed rentals (Out → In dates)

  • Same-day usage (counts as 1 day)

  • Ongoing rentals (counts up to the reporting date)

• Only includes usage after the last service date (ReturnFromService)

Logic

The query compares:

• Days in Service vs. Days Required for Service (Days_req_service)

Only assets where:

Usage ≥ Service Threshold

are returned.

Filters

• Assets must require servicing (Days_req_service > 0)

• Only assets in location the location the report is run from