13.4 Features and Enhancements

This topic includes details about the new features and enhancements in WorkBook Release 13.4.

CRM

CRM Billing Plan and Pipeline Details Tab Updated to Support Gross Revenue

Deltek Tacking Number: 1675725

Instead of entering just the Gross Revenue, you now have the option to enter Gross Revenue hours, Gross Revenue purchases, and cost of purchases in the Pipeline Details tab (CRM > Pipelines > Show/Hide Pipeline Card) to allow for a more granular way of tracking Price Quote values. New fields have been added to support this enhancement. These are:
  • Gross Revenue - Hours
  • Gross Revenue - Purchases
  • Cost - Purchases
  • Expected Gross Revenue
  • Expencted Monthly Gross Revenue

For more information, see Pre-Conversion: Pipeline Details Tab Fields and Calculations.

Gross Revenue is now linked to the Price Quote. When the Price Quote is updated, gross figures flow through to the Gross Revenue figure on the Pipeline Details tab. When a pipeline is converted into a job, you are presented with an updated view of the values via two new columns in the Pipeline Details tab:
  • Pipeline column: When you convert a pipeline into a job, the pipeline figures at the point of conversion are displayed under this column.
    Note: The values under this column become read-only after conversion.
  • Price Quote column: After you have converted a pipeline into a job, the Pipeline Details tab pulls in the values from the Price Quotes on the job attached to the pipeline and displays the figures under this column. For more information, see Price Quote Column Fields and Calculations.

Having these figures conveniently displayed side by side can help you to easily compare projected and current revenue.

In addition, the Pipeline Billing Plan (CRM > Pipelines > Show/Hide Pipeline Card) calculates for the Gross Revenue instead of the Net Revenue, making it consistent with the billing plan in the Jobs module.

Finance & Administration

Employee Department Recording on Cost Entries

Deltek Tracking Number: 1564501

Previously, WorkBook did not record the Employee Department ID that the employee resource was associated with at the time or a transaction being created (such as time, expense, mileage, and material cost associated with an employee). This created inconsistencies in data when an employee was moved from one department to another, and the latter department ID was incorrectly reported in some transactions and reports.

To address this issue, an EmpDepID column is added to tables supporting employee-related cost entries. When an employee-related entry is created, the Employee Department ID on the Employee is recorded and can be referenced later. This delivers consistency of data reporting, even if the employee is later moved from one department to another.

Updated tables include:
  • Time Entry (TimeReg table)
  • Personal expense entry (ExpenseEntry table)
  • Mileage entry (JobMilage table)
  • Material Entry (JobMatExp table)
  • Financial posting (FinPosting table)
Note: This change is only within data tables, and does not impact the interface.

Integration with Pagero

Deltek Tacking Number: 1761063

You can now integrate WorkBook with Pagero, a cloud-based software platform that provides e-invoicing and e-document services. Integrating Pagero with WorkBook enables you to:
  • Send e-invoices to Pagero, which Pagero in turn sends to your intended recipient.
  • Receive e-invoices from Pagero, which Pagero received from your behalf.

See the Deltek WorkBook Integration Guide for Pagero for more information on the Pagero integration, including prerequisites and initial setup.

Jobs

Reports – Report 386 (Client Job Cost Details) – New Option to Include or Exclude Inactive Employees

Deltek Tacking Number: 1564538

When running Report 386, you can use this new parameter to include or exclude the records of employees who left the company in the middle of a reporting period. You can generate Report 386 using the Reports icon from Jobs > Jobs List.

Report 581 - Job Reconciliation Report

Deltek Tacking Number: 154914

The Job Reconciliation report (Report 581) enables you to see an overview of the financial position of a job at a particular date. It draws information from across the Jobs module and gives you a single place to review the financial health of a job and identify any anomalies or issues that may need action. See Job Reconciliation Report (Report 581) for detailed information about this report.

In addition, System Variable 267 has been updated to include the Job Reconciliation report (Report 581). This setting affects the calculation of the % Margin for the Profitability and Completion and Job Estimate at Completion Forecast sections of the report.

My Settings

Redesign of My Settings/Whereabout Dialog Box

Deltek Tacking Number: 1765217

To continue with simple, impactful changes to the UI, the available options within the My Settings/Whereabout dialog box have been changed. Those options that were not required have been removed to provide a cleaner, fresher styling.

Updates include:
  • My Settings/Whereabout Dialog Box Changes - The dialog box that is displayed when you select My Settings on your avatar shortcut menu on the main toolbar has been redesigned to provide cleaner, fresher styling. In addition, the number of options that it provides has been reduced.
  • Change Whereabout Pop-Up Redesign - When you access your avatar shortcut menu on the main toolbar and navigate to Change Whereabout, all existing active whereabout types and Reset Status options are displayed in a pop-up window. You can select your status from them when Company Variable 74 (Require Employees to Track Time Using Whereabout) is set to either 1 - Not Required or 3 - Required for Some Employees, and User Must Track Time is disabled. Status updates in both your user profile and the WorkBook footer are always in sync.

Resources

Resources - Resource Information Card - Ability to Add More Terms to Gender

Deltek Tacking Number: 1551938

You can now add custom gender terms, which you can then assign to individual users in WorkBook. You set this up in Settings > Employee Settings > Gender Terms

You can select all available gender terms from the Gender drop-down list on the following pages/views:
  • Resources > Employee Settings Grid
  • Employee Resource Card > Settings > Employee Basic Settings

You can also select gender terms from the Gender column in Settings > Employee Settings > Employee Settings

In addition, the N/A option has been added as a third predefined option. Previously, only two predefined options - Female and Male - were available for selection. Note that you cannot delete the predefined options because they are hardcoded.

Scheduling

Ability to Assign Team to Sprint Added

Deltek Tacking Number: 1828222

You can now assign Scrum Teams to sprints. This change has been made to better support the Agile process by shifting accountability for a sprint from an individual resource to an entire Scrum Team. Previously, you could only assign individual employee resources (Scrum Responsible) to sprints.

In addition, the following updates have been made:
  • You now have access to/visibility into only those Scrum boards for which you are in a team that is responsible for the sprint, or for which you are a Scrum Responsible. This removes the inclusion of unneeded data.
  • The Team Responsible field has been added to the Scrum Sprint View filter.
  • The Team Responsible column has been added to the Scrum Sprints Setup page.
These changes impact the following views:
  • Scheduling > Schedule Overview > Scrum Board > Scrum Sprint Overview > Scrum Sprint Setup
  • Scheduling > Schedule Overview > Scrum Board > Scrum Sprint View filter
  • Scheduling > Schedule Overview > Scrum Sprint Overview > Scrum Sprint View filter
  • Tasks > Scrum Board > Scrum Sprint Overview > Scrum Sprint Setup

Ability to Rank Sprint Backlog Items in Scrum Board Added

Deltek Tacking Number: 1612431

WorkBook now allows the ranking/prioritization of tasks on the Scrum board. You can perform this in the following views:
  • Scheduling > Scrum Board > Scrum Sprint Overview
  • Scheduling > Scrum Board > Scrum Board
  • Jobs > Support Views > Scrum Board
  • Tasks > To-do > Scrum Board

For instructions, see Rank Sprint Items on the Scrum Board.

In addition, several improvements relating to task prioritization have been made, including:
  • The Effort and Backlog Priority fields have been added to the Task Card.
  • The total effort for a selected sprint is now displayed on the tab toolbar.
  • You can now filter tasks by sprint in Job > Tasks > Support Views > Scrum Board.

All changes made to the prioritization of tasks are saved in the task log.

Absence Type Icons Update

Deltek Tacking Number: 1722179

Icons for absence types have been updated to the new 2D mono standard. This is in support of the ongoing effort to improve WorkBook's user interface through the standardization and rationalization of iconography.

The following pages display the new icons:
  • Time & Expense > Time Sheet > Daily
  • Time & Expense > Time Sheet > Weekly
  • Settings > Holidays and Absence > Absence Codes
  • Scheduling > Calendar
  • Scheduling > Timeline Calendar > Day View
  • Task > Calendar View

Effort Added to Task and Sprint

Deltek Tacking Number: 1757432

You can now add effort (measured in story points) to individual tasks via the new Effort field on the Task card. Also, a new Total Effort field that displays the sum of story points in each sprint has been added to the sprint title bar within the following views:
  • Scheduling > Scrum BoardScrum Sprint Overview tab
  • Tasks > Scrum Board > Scrum Sprint Overviewtab

Public Hours Displayed on Scheduling Views

Deltek Tacking Number: 1812910

The icon for bank holidays has been changed from the 3D colored beachball icon to the 2D mono bank icon to clarify which days are registered as absences and which are bank/public holidays. In addition, the way in which public holidays are displayed has been improved. The Company holidays are indicated on specific scheduling views in the color that is associated with the Company to which the employee who owns the timesheet belongs. These improvements affect the following views:
  • Scheduling > Calendar View
  • Scheduling > Task Matrix View

Scrum Board View Added to Tasks Module

Deltek Tacking Number: 1828389

The Scrum Board is now accessible via the Task Module.

Settings

Ability to Mark Departments as Inactive

Deltek Tacking Number: 1816400

This feature continues work on the ability to mark Departments as inactive and its effect throughout WorkBook. Previously you could delete a Department if no employee resources were allocated against it, or you could merge Departments, which moved the allocated resources from one Department to another. However, these options have an impact on historic data, including complete or closed jobs. Having the option to mark a Department as inactive enables you to retain historical detail and removes the option to select inactive Departments going forward.
  • Job List Views
    Jobs that are in Quotation, In Progress, On Hold, or Ready for Invoicing status are now displayed in parentheses and highlighted in red in the following views:
    • Simplified View
    • Job List
    • Expenditure Overview Cost Prices
    • Expenditure Overview Sales Prices
    • Purchase Orders Overview
    • Jobs List with Dimensions Settings
    • Expenditure Overview Cost & Sale
    • Project Retainer
  • Costs

    Inactive Departments are now displayed in parentheses in Costs > Summary > Department Profit Split and in Costs > Hours > Total on Department/Summed per Department views.

  • Contacts

    In Settings > Contacts > Contact New Job Request template, inactive Departments that are set and displayed as defaults on the field are highlighted in red and enclosed in parentheses. In addition, inactive Departments are not available for you to select in the drop-down list.

  • Grid Views

    In Employee Settings, Employee Price Group, CRM Pipeline, Schedule Overview, and Weekly Schedule, for a selected employee record, if the Department to which that record belongs is inactive, the field background is highlighted in red, and the Department name is enclosed in parentheses when displayed.

  • Resource Cards

    In the Resource card and other places that display employee information, if the Department to which the resource belongs is inactive, the field background is highlighted in red, and the Department name is enclosed in parentheses.

Move an Employee to Another Company

Deltek Tacking Number: 1819876

In Resources > Resource default grid > Resource Information, you can now select employees and move them to another Company. Only active Departments in the selected target Company are enabled for selection.

System Administration

OAuth2 Updates

Deltek Tacking Number: 1828847, 1904577

WorkBook has updated its OAuth2 authentication protocol, including the following new features and enhancements.

New Features
  • You can now configure system mail sending with OAuth 2.0 for Microsoft and Google services. The following are added in Release 13.4:
    • Configuration options in Settings > OAuth 2.0 Integration Settings
    • Connect to OAuth 2.0 Server log-in button in Settings > OAuth 2.0 Integration Settings
  • Release 13.4 also implements OAuth 2.0 for further use of Google as follows:
    • Added configuration options in Settings > OAuth 2.0 Integration Settings
    • Added Sign in with Google log-in option in My Settings > Email Import Settings
    • Added Google OAuth 2.0 support for the following agents:
      • Ticket Import Public Agent (OAuth 2.0) – Agent Type 180
      • Mail Import Agent (OAuth 2.0 – Agent Type 178
      • Mail Import Public Agent (OAuth 2.0) – Agent Type 176
      • Mail Archive Agent (OAuth 2.0) – Agent Type 179
  • Calendar Synchronization
    • Calendar synchronization OAuth 2.0 settings are moved from System Variables 936, 937, 1182, and 1183 to My Settings > Email Import Settings. These System Variables are removed.
    • My Settings > Calendar Synchronization Settings:
      • The email account that you are signed in with is now displayed to you.
      • The OAuth 2.0 login window now opens in a new browser tab.
Enhancements
  • Settings > OAuth 2.0 Integration Settings:
    • All changes to the grid can only be made via the New/Edit dialog, which you access from the toolbar.
    • You cannot update Provider IDs or Client IDs for existing entries.
    • The Active column is replaced by the Scopes column, which displays all active features for which each setting is used.

See Deltek WorkBook Reconfiguring WorkBook to Use OAuth and Deltek WorkBook Configuring WorkBook to Use Google Workspace OAuth for updated instructions.

Time & Expense

API – Time Entry: Allow Filtering by Company

Deltek Tacking Number: 1561132

Some Time Entry API endpoints have been improved for performance and data quality.

Company Settings – New Company Variable to Require Confirmation when Submitting Time Entries

Deltek Tacking Number: 1937893

When you submit your own time entries for approval, you are now presented with a confirmation dialog box. Confirming the action is logged. Entries with blank hours are not valid and are not logged.

The confirmation dialog box does not affect automated submissions/approvals (such as agents) or submissions/approvals directly through the API.

To have WorkBook display the confirmation dialog box, you must first enable Company Variable 79 (Require Employees to Accept a Pop-Up Message When Approving Time). For instructions, see Enable Company Variable 79.

Translations

French Canadian Translation is Updated

Deltek Tacking Number: 2005407

Additional text that appears in WorkBook has been translated into French Canadian and imported into the translation layer.

User Interface

Icon Standardization

Deltek Tacking Number: 1765197

Creating consistency and reducing visual noise in the WorkBook user interface are a key part of updates that are currently being made to improve the user experience. One way in which this is being achieved is through standardization and rationalization of iconography. Updates include:
  • CRM module: Icons have been updated to the new 2D mono standard.
  • Dashboard module: Icons have been updated to the new 2D mono standard. Some icons that served redundant functions have been removed.
  • Reloading/refreshing updated rows in grids: Icon has been updated to the new 2D mono standard.
  • Inbox and Conversations header: Redundant icons have been removed and navigation controls have been rearranged.
  • Arrow icons: Updated to ensure that they are consistent for the same functions across WorkBook.
  • Scheduling module > Task follow-up pages: Some icons have been repositioned, and some have been updated to the new 2D mono standard.
  • Jobs module: Icons have been updated to the new 2D mono standard and some redundant icons have been removed.
  • Time & Expense module: Icons have been updated to the new 2D mono standard and some redundant icons have been removed.

New Tree View Component

Deltek Tacking Number: 1825203

A new Tree View component provides a consistent user experience in WorkBook.

Rich Text Editor

Deltek Tacking Number: 1846881

WorkBook has upgraded its rich text editor to provide improved editing and a more consistent user experience across WorkBook.

The areas of updated support include:
  • Add a new ticket quick (dialog box) – Quick Menu > Add Entry > Shortcuts > Ticket
  • Briefings (tasks, jobs)
  • Add a new task (dialog box)
  • Add a new ticket (dialog box)

Scheduling – Timeline Calendar and Calendar User Interface

Deltek Tacking Number: 1545925

For enhanced usability, several user interface (UI) improvements have been made to the Timeline Calendar, Calendar, and Personal Calendar views, such as:
  • In the toolbar of the Timeline Calendar, Calendar, and Personal Calendar, several buttons have been moved to the left, and two new buttons were added: Create New Task and Add an Existing Task.
  • There is now a visual indicator to show which cell is selected.
  • The styling of the grid header of the Timeline Calendar, Calendar, and Personal Calendar views has been improved.
  • The styling of the Name and Day columns of the Timeline Calendar has been improved.
  • The styling of the Timeline Calendar and Calendar booking cards has been improved.
  • View options have been added to the Calendar view to control what is displayed on the booking cards.

Reports

Job Reconciliation Report (Report 581)

Summary

This new report allows you to see an overview of the financial position of a selected job at a particular date. It draws information from across the Jobs module and gives you a single place to review the financial health of the job and identify any anomalies or issues that may need action. It does not support Download as XLSX Document (Row) Data, but it supports Download as XLSX Documents (Formatted) Data.

Location

Navigate to Jobs > Jobs List > Reports to run this report. WorkBook uses the highlighted job in the Jobs List as the source of information for this report.

Parameters

Parameter Use
Report To Date This is the date that indicates the To Date to be used to filter the transactions. This is the only required parameter.

Report Layout and Calculations

This report calculates for the selected job's profitability by comparing the total value of its Price Quotes and Sales Invoices with the Sales and Cost values of applied entries and the actual revenue recognized based on WIP adjustments and values derived via posting configurations. It also compares the total value of its Price Quotes with its total forecast value based on both the actual values and the forecasted or scheduled values.

Section Heading Section Descriptions
Job Overview for Job This field indicates the job number of the selected job.
Report To Date This is the date that indicates the To Date to be used to filter the transactions.
Summary This section displays, in two columns, information sourced from the selected job. It includes the name of the information and the corresponding value of the data point.
Column Heading Column Descriptions
Client This field indicates the client that the job belongs to.
Project This field indicates the project that the job is a part of.
Job Type This field displays the same job type that is indicated on the Job card.
Job Team This field displays the same job team that is indicated on the Job card.
Department This field displays the same Department that is indicated on the Job card.
Company This field indicates the Company and company initials that the job belongs to.
Currency This field indicates the currency used by the job.
Report Currency This field indicates the report currency used by the job. It is only visible if the report currency is different from the job currency.
Job Name This field displays the job's name as indicated on the Job card.
Job Status This field displays the job's status as indicated on the Job card.
Start Date This field displays the job's start date as indicated on the Job card.
End Date This field displays the job's end date as indicated on the Job card.
Project Manager This field displays the Project Manager that is indicated on the Job card.
Account Manager This field displays the Account Manager that is indicated on the Job card.
Finance Manager This field displays the Finance Manager that is indicated on the Job card.
Section Heading Section Descriptions
Profitability and Completion This section displays the overview and comparison of the total value of the Price Quotes and Sales Invoices of the selected job and the Sales and Cost values of applied entries and the actual revenue recognized based on WIP adjustments and values derived via posting configurations.
Column Heading Column Descriptions
Estimated The fields in this column get their data from the sum of all of the in-scope Price Quotes of the selected job. In-scope Price Quotes are Price Quotes that are under preparation, for approval, or approved.
Estimated Revenue This field displays the sum of the Total of each Price Quote that is under preparation, for approval, or approved.
Estimated Purchase Cost This field displays the sum of the Purchases of each Price Quote that is under preparation, for approval, or approved.
Estimated Net Margin Net Margin is the net of Revenue and Purchases. This field displays the sum of the Net Revenue or NR of each Price Quote that is under preparation, for approval, or approved.
Estimated % Margin Depending on the value set for System Variable 267, this field displays, as a percentage of up to two decimal places, the value of the Net Profit divided by either the Revenue or the Net Margin of all of the Price Quotes that are under preparation, for approval, or approved.
Estimated Cost of Hours This field displays the sum of the cost of any time hours applied to each Price Quote that is under preparation, for approval, or approved.
Estimated Net Profit Net Profit is the net of Net Revenue and any calculated cost of hours. This field displays the sum of the Net Profit of each Price Quote that is under preparation, for approval, or approved.
Estimated Total Hours This field displays the sum of the Hours of all Price Quotes that are under preparation, for approval, or approved.
Actual The fields in this column get their data from the value of WIP adjustments and revenue postings. This is based on your Posting Configuration setup and other actual postings to the selected job, including purchase invoices and expenses. All WIP adjustment transactions in any status are in scope.
Actual Revenue This field displays the sales value of the actual corresponding entries on the job. For example, if a time entry is posted to the job, the actual Revenue is the sales value of the posted time entry.
Actual Purchase Cost This field displays the cost value of the actual corresponding entries on the job. For example, if a purchase invoice or expense entry is posted to the job, the actual Purchase Cost is the cost value of that posted invoice or entry.
Actual Net Margin This field displays the total of the selected job's Revenue and all of its Purchase Costs.
Actual % Margin This field displays, as a percentage of up to two decimal places, the value of the Net Margin divided by the Revenue of the selected job.
Actual Cost of Hours This field displays the sum of the cost of any time entries on the job.
Actual Net Profit This field displays the total of the Net Margin and the cost of all the time entries logged on the selected job.
Actual Total Hours This field displays the total used hours based on the time entries logged on the selected job.
Revenue Recognized The fields in this column get their data from the value of WIP adjustments and the revenue recognized on the transactions posted on the selected job. Data is derived via posting configurations. For example, the time entry where the sales value of the time is recognized as revenue and is reflected on the WIP adjustment dialog box. Values are shown split as Revenue or Costs.
Revenue Recognized Revenue This field displays the actual Profit & Loss total on the WIP adjustments of the selected job. Note that Company Variable 75 should be set to 2.
Revenue Recognized Purchase Cost This field displays the total of all Purchase Costs on the WIP adjustments of the selected job. Note that Company Variable 75 should be set to 2.
Revenue Recognized Net Margin This field displays the total of the actual Profit & Loss and all the Purchase Costs on the WIP Adjustments of the selected job.
Revenue Recognized % Margin This field displays, as a percentage of up to two decimal places, the value of the Net Margin divided by the actual Profit & Loss total on the WIP Adjustments of the selected job.
Variance The fields in this column display the difference between either the Invoiced and Incurred or Actual and Recognized column and the Estimated Values column.
Completion The fields in this column display the percentage of the Invoiced or Actual column divided by the Estimate column.
Invoiced The fields in this column get their data from the value of the created Sales Invoices for the selected job.
Section Heading Section Descriptions
Job Estimate at Completion Forecast This section displays a comparison of the total value of the Price Quotes and the total forecast value of the job based on both the actual values and the forecasted or scheduled values.
Column Heading Column Descriptions
Estimated Revenue This field displays the sum of the Total of each Price Quote that is under preparation, for approval, or approved.
Estimated Purchase Cost This field displays the sum of the Purchases of each Price Quote that is under preparation, for approval, or approved.
Estimated Net Margin Net Margin is the net of Revenue and Purchases. This field displays the sum of the Net Revenue or NR of each Price Quote that is under preparation, for approval, or approved.
Estimated % Margin Depending on the value set on System Variable 267, this field displays, as a percentage of up to two decimal places, the value of the Net Profit divided by either the Revenue or the Net Margin of all of the Price Quotes that are under preparation, for approval, or approved.
Estimated Hours and Internal Costs This field displays the sum of the cost of any time hours applied to each Price Quote that is under preparation, for approval, or approved.
Estimated Net Profit Net Profit is the net of Net Revenue and any calculated cost of hours. This field displays the sum of the Net Profit of each Price Quote that is under preparation, for approval, or approved.
Estimated Total Hours This field displays the sum of the Hours of all Price Quotes that are under preparation, for approval, or approved.
Actual Revenue This field displays the sales value of entries posted against the selected job. It includes time entries, purchases, materials, expenses, and mileage.
Actual Purchase Cost This field displays the cost value of entries posted against the selected job. It includes time entries, purchases, materials, expenses, and mileage.
Actual Net Margin This field displays the total of the selected job's Revenue and all of its Purchase Costs.
Actual % Margin This field displays, as a percentage of up to two decimal places, the value of the Net Margin divided by the Revenue of the selected job.
Actual Total Hours This field displays the total used hours based on the time entries logged on the selected job.
Scheduled The fields in this column display the sales value and the cost value of the bookings made on the schedule. For example, the time entries logged on a specific schedule should be offset from the scheduled value. When an employee makes a time entry on the task that they are scheduled on, it should be for the day that they scheduled.
Open Purchase Orders / Open POs The fields in this column display the sales value and the cost value of the open balances of the Purchase Orders of the selected job.
Expected The fields in this column display the total of the preceding column for sales and costs. This provides a forecast value for each based on what has been processed on the selected job and what future items are still open.
Variance The fields in this column display the difference between the Estimated Value column and the Expected Value column.
Section Heading Section Descriptions
Detail by Activity This section is split into hours and costs and displays the hours, sales, and costs of the selected job according to the relative activity that they are recorded on. It shows previously reported information with a deeper level of detail.
Hours Detail by Activity This sub-section displays the sales value of hours according to the activity that they are recorded on. The hours are derived via the activity used on the Price Quotes (estimated hours), the activity on the time entry (actual hours), or the schedule. The numeric value of the hours is also reported here from the same data sources)
Costs Detail by Activity This sub-section displays the cost value of purchase items according to the activity that they are recorded on. It has a deeper level of detail compared to the data reported on the previous sub-section and is derived from the purchases on Price Quotes, the cost on open Purchase Orders, and the cost value of purchase invoices posted to the selected job.
Section Heading Section Descriptions
Open Purchase Order Detail by Activity This section displays details of open Purchase Orders, separating each value by activity. The details that are provided are related to the tracking of costs based on created Purchase Orders. The created Purchase Orders, which are linked to Price Quotes, should list the Price Quote number. Indicated supplier names are taken from the Purchase Order supplier, but broken down further by activity.
Column Heading Column Descriptions
Purchase Order / PO Number This field displays the Purchase Order number.
Price Quote / PQ Number This field displays the Price Quote number, which is linked to the Purchase Order.
Supplier This field displays the supplier name, which is taken from the Purchase Order.
Activity This field displays the activity related to the Purchase Order.
Inv No This field displays the Invoice number, which is linked to the Purchase Order and the related activity.
Order Value This field displays the total value of the Purchase Order.
Invoice Value This field displays the value derived from a Creditor Invoice, which is linked to the Purchase Order and the related activity.
Open Purchase Order / Open POs This field displays the remaining value of the Purchase Order line, net of the Invoice value.
% MU This field displays the margin applied to the cost of the line referred to in the Open PO field, expressed as a percentage.
Costs + MU This field displays the sales value of the line referred to in the Open PO field, calculated by the cost multiplied by the margin.
Section Heading Section Descriptions
Purchase Invoice Detail Not Related to Purchase Orders by Activity This section displays details of expenses or vouchers that are not linked to any Purchase Orders, separated by activity.
Column Heading Column Descriptions
Supplier This field displays the supplier name of the non-PO expense or voucher.
Activity This field displays the activity related to the non-PO expense or voucher.
Inv No This field displays the Invoice number, which is linked to the non-PO expense or voucher.
Invoice Value This field displays the value derived from a Creditor Invoice, which is linked to the non-PO expense or voucher.
% MU This field displays the margin applied to the cost of the line referred to in the non-PO expense or voucher, expressed as a percentage.
Costs + MU This field displays the sales value of the line referred to in the Invoice Value field, calculated by the cost multiplied by the margin.
Section Heading Section Descriptions
Sales Invoicing This section displays a comparison of the total value of Price Quotes and the total value of Sales Invoices, separated by activity. It provides a list of created Sales Invoices with a summary of the billings of the selected job, what has been paid or settled against the invoice, and the outstanding balance. This data supports the Invoiced field in the Profitability and Completion section of this report.
Column Heading Column Descriptions
Sales Invoice Summary and Detail

The fields that display the invoiced amount without VAT or Tax are used to reconcile the Sales Invoice against the job data, specifically in the Profitability and Completion section. On the other hand, the fields that display the invoiced amount with VAT or Tax are used to reconcile against the Debtors module in Finance & Administration.

This same information is also provided at the Activity level, where the total of invoices is listed by activity and compared to the estimated value as per the sum of Price Quotes. The information in this section must be expressed excluding VAT or Tax.

Secondary Chart of Accounts Trial Balance Report (Report 585)

Summary

This report shows the list of all General Ledger accounts, both of account type Operating Balance Sheet, which are mapped to their corresponding Secondary Chart of Accounts account names and numbers. Note that if there are more than one Operating account or Balance Sheet account that is mapped to the same Secondary Chart of Account, the balances of all of the accounts are added and displayed as the balance for that Secondary Chart of Account. This report does not include the General Ledger account that is designated as the Net Profit P/L Account, as configured in Settings » Basic Finance Settings.

The Header and Sum From account types are omitted by default and are not included in Report 585. It does not have any line break functionality and is sorted based on the Secondary Chart of Accounts code or account number.

Location

Navigate to Finance & Administration > General Ledger > Chart of Accounts > Reports to run this report.

Parameters

Parameter Use
As of Date This is the date on which you run the report. This is the only required parameter.
Only show accounts with a balance Select this checkbox to omit accounts that do not have balances. This omits from the report any account where the balance of transactions in the period sums to 0 (zero).
Hide Horizontal Lines between Accounts Select this checkbox to remove horizontal lines between accounts in the report.
Currency This report always shows figures in the Company currency of the Company for which you run it. The Currency selector is therefore locked; you cannot change it.

Calculations

This report displays the balances of accounts split into a debit and a credit column, based on the calculations described here. These balances are always positive, but they are designated as being debit or credit based on which column they appear in. The sum of the debit column should equal the sum of the credit column, unless a year-end closure procedure has not been completed in a prior financial year (see the following note).

Account balances that are included in this report are calculated based on their account type:
  • For Operating Accounts, the balance is calculated as the sum of all transactions in the period from and including the first day of the current financial year, to and including the date that is specified by the As of Date parameter.
  • For Balance Sheet Accounts the balance is calculated as the sum of all transactions where the booking date is before or equal to the date that is specified by the As of Date parameter.
  • The Balance Sheet Account that is designated as the Retained Earnings Account, as configured in Settings > Basic Finance Settings, shows a balance net of any year-end postings that have occurred in the finance year.
  • The Operating Account that is designated as the Net Profit P/L Account, as configured in Settings > Basic Finance Settings, is omitted from this report.
Note: This report always shows the balances of the Operating Accounts, even after a financial year-end closure procedure is completed for the financial year within which the As of Date occurs. However, this report is sensitive to whether a year-end closure procedure has been performed in a financial year prior to the As of Date.

If you run the report with an As of Date that is within a finance year where a final year-end closure has not been completed, the debit and credit columns will still balance.

However, if you run this report with an As of Date where a final year-end closure has not been completed in any preceding financial years, the debit and credit columns will not balance. To resolve this, you must perform the year-end closure for that prior finance year to ensure that all earnings in that financial year are transferred to retained earnings in the Balance Sheet. Running the Trial Balance subsequent to all final year-end closure procedures being completed for all preceding finance years results in debit and credit columns balancing.