When building a report in BI our customers are requesting a % complete based on Billed not Cost since most of our work is T&M our Cost to Date information which would normally work for a Fixed Dollar job does not work for a T&M project.
Since most of our projects are broken out into multiple Phase Codes we need the ability to show % Complete based on Phase but with the Billed to Date measurement not just the Cost to Date measurement. Simply putting the Billed to Date measurement into the Cost Detail Cube would allow T&M work to be foretasted based on % Complete by phase which is not available at this time.
Guest
| Company | Mills Electric |
| Job Title / Role | Other... |
| I need it... | Yesterday...Come on already |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
On our T&M Projects which most of them are, the "Billed to Date" to the client is the clients "COST" if you will. The problem right now is "Cost to Date" does not reflect mark-up & Overhead. So when the client requests Project Forecasting by Phase Code on a T&M Job, it needs to reflect the "Billed to Date" measurement instead of the "Cost to Date" measurement to get accurate forecasting. Otherwise the forecasting & % Complete measurement is inaccurate since Mark-Up and Overhead is not reflected.
After looking at the % Complete field by Phase Code in the Projected Cost tab, I am unclear if by manipulating this value will reflect the Bill to Date Measurement by Phase Code which is what I am going for.
The other option would be to put Phase Code under "Project Manager: Contract Billings" and add the ability to insert a user defined column in which I can input my own data I can then create a report as needed.
Since we bill every day we try can give the client a good representation of project completeness as accurate as possible sometimes on a daily basis. Depending on the size of the Project they may ask for a report every other day and sometimes during a Turn Around, daily. And I can't complete my roll out to the large sites without the ability to reproduce these reports and am left using our old system partially in tact wasting hours of the day of input until I can reproduce them.
Ryan,
Quick question - how would you envision linking the billings to the cost? I don't think we would get that if we just added billed as a measure.
What am I missing here?