Supply chain | Supply Chain Management, Commerce

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

(1) Share

Report

Posted on by MH-22100618-0

Hi Expert,

The issue at the Asset KPIs report in Microsoft Dynamics 356 Finance and Operations.

The report correctly displays for fields like Total Time, Uptime, Downtime, and Availability % and fields related with them, but the Repair Time, Fail Rate, MRT fields appears as a blank (no values) or its not calculated.

Need your help and advice to solve this issue, please!!

All responses (10)

Answers (0)

Jonas "Jones" Melgaard 1,983 on at

Like (1)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

It's not certain that the from-date and to-date specified in the KPI calculation catches the work orders placed.

Think your category looks fine. My category looks like this
MH-22100618-0 18 on at

Like (0)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

How can I ensure that the from-date and to-date I am selecting are not incorrect?

I usually just pick any date range without relying on anything specific.

Could you please confirm if the Project Category Setup that I shared previously is correct?

I’ve already posted the work hours in the Journal, but the Repair Time field still does not show any value.
Jonas "Jones" Melgaard 1,983 on at

Like (1)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

Okay, this is odd..

The next best thing I can think of is that the from-date and to-date in the KPI calculation dialog is wrong.
MH-22100618-0 18 on at

Like (0)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

No, I don't activate the total because on the first when I activated it that does not appear any value in the KPIs report so because that I have turned off and not activated that.
Jonas "Jones" Melgaard 1,983 on at

Like (1)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

Have you activated "Total" on the asset type that you have added the work order to?
MH-22100618-0 18 on at

Like (0)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

Thank you very much, Mr. Jones, for your detailed explanation.

I have already tried following that approach, but unfortunately, no results appeared in the Repair Time field. I'm wondering if there might be an issue with the category configuration that’s preventing the data from reflecting correctly in the KPIs report. Could you please advise if there's a specific setup we need to check or correct to ensure it reflects properly?

Looking forward to your feedback!
Jonas "Jones" Melgaard 1,983 on at

Like (0)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

I found this article from Microsoft: Asset KPIs - Supply Chain Management | Dynamics 365 | Microsoft Learn
Suggested answer

Jonas "Jones" Melgaard 1,983 on at

Like (1)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

It comes from work orders.

Repair time:

Number of faults:

Repair time = Posted hours in work order journals

MRT = Mean repair time = Repair time / Number of faults

Fail rate = 1 / MinimumOne(MTBF)
MTBF means "Mean time between failures"

Fail rate is zero in my case due to my bad test data; I only have a single failure for this asset.
MH-22100618-0 18 on at

Like (0)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

Thank you, Mr. Joans I hope now you can help me, to find solution why the repair time on this report not get value.
Jonas "Jones" Melgaard 1,983 on at

Like (1)

Report

The Repair Time field on the Asset KPIs report is appearing with no calculation!!!

Your question text is empty.

It's difficult providing help if the only thing attached to the question is a screen shot.