- Help Center
- What's new
- 2024 Release Notes
-
What's new
-
Getting started
-
Projects
-
Timesheets
-
Resourcing
-
Invoices
-
Revenue Forecasts
-
Expenses
-
Purchase Orders
-
Users & People
-
Leave management
-
Margin (profit/loss)
-
Billable and cost rates
-
Integrations
-
Access levels
-
Single Sign On
-
Quotes
-
Companies
-
Contacts
-
Glossary & Definitions
-
Administration
-
Utilisation
-
Notifications
-
Security
-
Other
-
Admin & Config
13 October 2024 - SQL views include write-off columns
Included in this release:
Feedback or questions?
Email us as support@projectworks.io and one of the team will get back to you!
Following the introduction of write-offs to Projectworks in September, additional write-off columns have been added to a number of views, so that write-offs can be included in your SQL report building.
[BI].[FactProjectTimesheets]
Four new columns have been added:
-
OverrideType
-
OverrideAmount
-
OverrideBy
-
OverrideDate
[BI].[FactProjectBurn]
One new column has been added
-
OverrideAmount
[BI].[FactUserActivity]
One new column has been added
-
OverrideType
[BI].[FactUserActivityWithHolidays]
One new column has been added
-
OverrideType