New fields for custom log reports

The COId, CONumber, and COSubject fields have been added to the vw_ProjectAnalytics_Commitments and vw_ProjectAnalytics_CostToDate views for custom log reports.

How it works

  1. Go to Reports and select the Custom Reports tab.

  2. Select the appropriate Report Category and Report Sub-Category.

  3. Select the Custom Reports tab.

  4. Select Add Custom Report.

  5. Select the database icon and select NEW DATA.

  6. Select Shared and select the Shared DataSource in the dropdown.

  7. Select CONNECT.

  8. Expand the dbo folder to view the list with the Sage Construction Management views.

  9. Expand the vw_ProjectAnalytics_Commitments or vw_ProjectAnalytics_CostToDate views and select the new fields as needed.