Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How to Calculate Earned Hours

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

In the Productivity Summary report, there is a column titled Earned Hours. How is this field calculated? I thought I had the formula figured out with:

(Output / Standard Output) * Actual Crew

But that doesn't seem to be accurate.

Any help would be great.

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: How to Calculate Earned Hours

    Hello,

    Thank you for the follow-up.It could be that the partner didn't view this as a change to "plain vanilla" NAV. However, Report 50040 is definitely a non-standard NAV Report, so it will require contacting the partner contact who developed the Report. The Report doesn't exist in a standard NAV database supported by Microsoft. 

    I appreciate your understanding.

    Best Regards

    Tom

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Calculate Earned Hours

    Hey Thomas, thanks for responding. The information you just said is very interesting as I was told that we have a vanilla Nav and no enhancements. However, here is the screenshot of the report I'm referring to.

    6114.Capture.JPG

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: How to Calculate Earned Hours

    Hello,

    Thank you for posting your question. 

    At this point, I am not sure about the results because there is not a Report in Standard NAV Versions called Productivity Summary.   When you run the Report and the Request Page is presented, please click in the upper left corner - drop down arrow - then click Help > About this Page.   What Page Report Number is shown?  As an example, below is the standard Account Schedule Report. Note that the About this Page shows a Report No. 25 as highlighted.

    pastedimage1572619238554v1.png

    Please confirm your findings. 

    If the Report is numbered in the 50000 or 14 million range, it would be a custom Report that was designed by your partner. You would want to contact the partner for clarification on the report data.

    I hope this helps move you forward.

    Best Regards,
    Tom

    Thomas Blaisdell

    Microsoft Dynamics Business Central & NAV Support North America

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans