Supply chain | Supply Chain Management, Commerce

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

(3) 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!!

I have the same question (0)

All responses (10)

Answers (0)

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

Your question text is empty.

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

Was this reply helpful? Yes No
MH-22100618-0 20 on at

Like (0)

Report

Thank you, Mr. Joans I hope now you can help me, to find solution why the repair time on this report not get value.

Was this reply helpful? Yes No
Suggested answer

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
MH-22100618-0 20 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

Have you activated "Total" on the asset type that you have added the work order to?

Was this reply helpful? Yes No
MH-22100618-0 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
MH-22100618-0 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No