BeyondERP.Newsletter
Menu

Inquiry page · Asset management

Asset KPIs

An inquiry that calculates key performance indicators (KPIs) for assets and asset types over a period.

Business process
Monitor asset performance
Menu item
EntAssetObjectKPI
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry that calculates key performance indicators (KPIs) for assets and asset types over a period.
What you do hereUse this page to compare asset performance, such as uptime, downtime, repair time, availability, and mean time between failures (MTBF), and the maintenance costs posted on each asset.
ExampleFor example, a maintenance manager calculates KPIs for the last quarter and compares the availability and MTBF of each asset.
Asset KPIs page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Asset management > Inquiries > Assets > Asset KPIs.
  2. In the Calculate asset KPIs dialog, select the Time scale and enter the From date and To date.
  3. On the Records to include FastTab, select assets or asset types if needed.
  4. Select OK.
  5. Review each asset on the Overview FastTab and the details on the KPIs for selected line FastTab.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
UptimeTotal time minus downtime.Microsoft Learn UpTime
DowntimeThe maintenance downtime registered on the asset in the period.Microsoft Learn DownTime
Availability %Uptime divided by total time, as a percentage.Microsoft Learn AvailabilityPercent
MTBFMean time between failures: total time divided by the number of faults in the period.Microsoft Learn MTBF
MRTMean repair time: repair time divided by the number of faults in the period.Microsoft Learn MRT
Number of stopsThe number of maintenance downtime registrations on the asset.Microsoft Learn NumberOfStops
Preventive costCosts posted on the asset with cost type Preventive in the period.Microsoft Learn PreventiveCost
Total timeWorking time in the calendar used: the asset's resource calendar, or the standard calendar in Asset management parameters.Microsoft Learn TotalTime
Solution architect

4Design impact

If you change it laterWhether downtime counts in the KPIs depends on the reason codes used on the downtime registrations. Microsoft Learn
Technical architect

5Technical

Menu itemEntAssetObjectKPI Checked in Dynamics 365
FormEntAssetObjectKPI Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintenance manager EntAssetMaintenanceManagerMaintenance clerk EntAssetMaintenanceClerkTo use itMaintenance worker EntAssetMaintenanceWorkerBudget manager BudgetBudgetManagerAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerAccounts payable manager VendInvoiceAccountsPayableManagerGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=EntAssetObjectKPI
Everyone

7Sources