web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Project Management Physical Percent completion task

(0) ShareShare
ReportReport
Posted on by 109

Hi Experts,

Im working in an accouting office, where we are using Business Central, specifically Project management module, in order to follow the time we spend on a customer accouting process.

Each customer is having hiw own "accounting projet" where we can plan time to spend for each task regarding the contract amount.

To increase granularity of the job taks time, we do not only use the hours spent, we need also to check the percentage completion of each task. It is a physical Percent, exactly the same as in Project Server. If I have 20 bill to account for my customer, and completed 10, then I'm having 50% task completion.

Do you have any idea on how to implement such a behavior ? 

Kind regards for any idea :)

Hicham

  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Hi

    This is just my assumption here since I never used Project Modules. But I think you may need 2 new fields in your project section. One to enter your estimate of total project hour. Then one to calculate % based on hours you spent on this project.

    or you can look into 3rd part add on

    appsource.microsoft.com/.../apps

    For custom fields you can look into following or use developer.

    appsource.microsoft.com/.../PUBID.wsb_solutions|AID.custom_fields|PAPPID.1ba841c1-087c-4fb7-b0bf-35db594ce248

    appsource.microsoft.com/.../PUBID.hougaard-4699382|AID.designer|PAPPID.4c032704-5c36-4480-b710-29e8565568bc

  • Hicham OE Profile Picture
    109 on at

    HI MahGah, thank you for your reply, and sorry for all the time spent to reply to you.

    In fact, i'm not sure that you could get my point.

    I'm talking about a physical progress of a task, this means that, for example, If I have 100 meters of cable to install and only installed 50 meters, this means that I'm having 50% of progress. independently of the time spend to do this work.

    this 50% are the real value of my work from which I can calculate my earned value and get deeper and exact financial state.

    The %Completion of task based on time spend versus time planned is not representative of the work done.

    I think that without this really important "Physical Percent Progress", it would be impossible to get the real financial state of a project, but also impossible to forecast the remaining work, in order to invoice customer in case of more work needed, before the end of the project.

    If with a customer I'm planning 100 hours of work, and spend 50 % of work in 50 hours then all is ok.

    But in case of I did 50% of a work  in 70 hours, this almost means that I will need 70 hours more to complete that job.

    Analysis :  I have to do some training :) to be best in my work, or, there is more work than expected, and I have to invoice customer for that. If he doesn't want to pay more, then I have to stop now before loosing time and money.

    Another advantage of this is to help for a strong forecast, improve the invoicing system, detect in advance any defect from employee, and show to customer that we are focusing on the job and we want to make sure to deliver the project in best conditions.

    It is always a bad thing to invoice customer after completing a job and telling him that we worked more than expected. there is a high risk to loose him.

    conclusion :

    I need to implement such behavior, in financial aspect.

    In another thread, you get exactly my point and you provided me the DYCE Job Billing app, that is nearly what I need in order to connect Job and sales order, and im still study it.

    I would like to improve that by adding this "Physical percent" exactly as shown here :

    support.microsoft.com/.../physical-percent-complete-task-field-4866cb37-f404-42e2-9241-6b144330c806

    other expalantion for the EVM (PMBOK)

    project-management.info/.../

    Hope I've been clear enough, and thank you to you and and for all for any good idea.

  • Suggested answer
    MahGah Profile Picture
    15,613 on at

    Hi Hicham OE

    Thanks for taking time and provide extra info. I clearly can see that I misunderstood you all together. 

    I cannot think of any out of box solution for this. You may need a little better PM solution. 

    I looked into all available app and did not see any app that match your exact need. But I link them below just in case you have time to review them.

    The closest one is this app but it is not available in many countries  https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.arbentiaconsultingsl%7CAID.arbentiaconsulting%7CPAPPID.7d980206-ba23-464e-9623-0d5e8541986a?tab=Overview

    This one has some functions but again not close to what you need (based on my understanding) 

    appsource.microsoft.com/.../PUBID.elbekvejrupas1591263556858|AID.evpr|PAPPID.3ee122ca-ec20-4b47-b156-bf1a3ee5fc29

  • Suggested answer
    Ben Baxter Profile Picture
    7,214 Super User 2026 Season 2 on at

    The base Jobs module will track some of what you're asking (Task Budget Cost and Task Actual Cost), but doesn't do the calculation of % complete per Task.  Since it isn't doing a % complete, it also doesn't have a projection as to what the Expected Cost to complete would be for the Task and overall Job.

    You should look into extensions to the Jobs module.  We've utilized "Job Manager" from Cost Control Software the most.  What you are describing above is part of their offering, and you'll get a far improved Statistics for a Job.  I would encourage you reach out to their team or your partner for a demo of the solution.

  • Hicham OE Profile Picture
    109 on at

    Hi Ben thank you for your reply.

    Due to the urgency,  we found a workaround that sounds nice and seems to be working fine.

    We simply created a custom ledger account to store the %Progress.

    So foreach job taks line of type ressource, we attach a ledger account line having 100 as quantity and we can validate it into job journal.

    I created also a calculated field in Job page that lookup for this lines and give the average.

    Note that we currently have only Job Planning line::Usage.

    for the moment the workaround is very promising and we are able to follow the physical progress of job and check for the job health.

    When I will have time, I will go through the app you shown me in order to improve my requirement.

    Thank you one more time.

    HIcham

  • PatriciaMorris Profile Picture
    5 on at

    I bet I've found a new way to follow the task progress and management, without introducing any new fields, but it's more complicated to expose it. Is anyone interested?

  • Suggested answer
    YUN ZHU Profile Picture
    103,216 Super User 2026 Season 2 on at

    Hi, If you can share it here, I believe it can help more people.
    Thanks in advance.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    11,423 Super User 2026 Season 1 on at
  • MahGah Profile Picture
    15,613 on at

    Hi PatriciaMorris

    If you can share the details it will help a lot. Thanks for sharing.

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 757 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 451 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 391 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans