Percentage of Completion shown for projects

Question

I had a prospect ask this question about percentage complete. Any thoughts anyone if this is achievable?

“In one of our recent meetings, we discussed being able to have a “percentage of completion” shown for our projects in the software and you said you would look into it. Is this something that we are going to be able to do? I’m creating processes and accounts in preparation for beginning the software implementation process and I keep coming back to needing some easy way to see percentage of completion. I’ll need it to do the reclasses for WIP materials to COGS to align with where we are in the contract but I’ll also need it to compare our revenue billed with what we’ve completed to make sure we haven’t over/underbilled. When I’m reclassing the WIP materials to COGS at EOM, it will essentially be an estimate. But if there is some sort of field for the PMs to be able to include their estimation of progress, that would greatly help me since I’m not the one out on site.”

Thanks for Yall’s help!

aaghaei · Accepted Answer

Hello ​@jparoski72Some of the information can be found in the project profile or different reports/GIs but there is not really a place to have a holistic view of projects specially for the WIP review, adjustment and posting purposes. For the exact same reason a while back I posted this topic here in the below link. Please have a look and see if it is helpful in your case.

CAS2809 · Answer

Hi ​@jparoski72Not sure if this would help but we added the project completion % on the project summary:To add this, go into the generic inquiry and under the Results Grid subheading add in this line (in yellow):The formula in the ‘data field’ column that does the calculation is the following:=NullIf([PMBudget.CuryActualAmount],0) / NullIf([PMBudget.Amount],0)*100With regards to WIP, unsure if the Project Summary will work as you are not able to fix a date range so it’s always going to be real time information. There is a WIP report built into the system already but we have had to alter heavily to suit our requirements and you could then add the formula into the report.Cheers

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded