17 August 2025 - Custom reporting updates and additional parameters to some API endpoints
Included in this release:
-
Ability to join previously made questions to a new question in Custom Reporting
-
Include UserID and Project ID in Tasks API endpoint parameters
Feedback or questions?
Email us at support@projectworks.com and one of the team will get back to you!
Updates to Reporting - Project view in Custom Reporting
We are adding two new columns to the Reporting - Projects view:
-
InvoicedAmountBeforeTax - to show the total invoiced amount for the project before tax
-
InvoicedAmountWithTax - to show the total invoiced amount for the project including tax
We are renaming two column names in the Reporting - Projects view for clarity:
-
InvoicedAmount column will be renamed to WorkedInvoicedAmount and it shows the total value of invoiced time worked in the project from time entries recorded against the project timecodes.
-
InvoicedHours column will be renamed to WorkedInvoicedHours and it shows the total sum of hours from time entries recorded against the project timecodes.
What does this mean for me?
You can now get a better invoiced amount breakdown per project with the additional columns.
We have updated reports in that use the InvoicedAmount and InvoicedHours columns to reference the new column names, so there should be no action for you to take. In the unlikely event that your report is broken, do reach out through support@projectworks.com for assistance!
Introducing the ability to join previously made questions to new queries in Custom Reporting
You can now use previously created and saved questions while building a new question. This is a useful way to break down a question into multiple smaller queries to be joined together into a larger question, simplifying the question building process.
Additional parameters to Get Projects and Get Tasks API endpoints
A number of you are utilising our GET /api/v{version}/Projects and GET/api/v{version}/Tasks API endpoints to extract the projects or timecodes a person is assigned to.
To make it more efficient and easier to obtain the information you require:
-
UserID has been added to the parameters of both of these endpoints, and
-
ProjectID has been added to the Tasks endpoint.
What does this mean for me?
If you are utilising these API endpoints, you can now make a single API call to identify the:
-
projects that a person is assigned to;
-
timecodes that a person is assigned to;
-
timecodes that are associated to a project.
Stay in the loop
Want to stay up-to-date with Projectworks product updates as they drop? To get monthly updates straight to your inbox, sign up to our product mailing list.