Project Group Fields Reference

Modified on Thu, 24 Sep at 9:35 AM

Project Group fields allow you to insert information from a WorkGuru Project Group into supported document templates.

Document Compatibility

All Project Group fields are supported on the following document templates:

When a project or invoice is associated with a project group only the project group information fields are supported on the following document templates:

Project Group fields are Universal Fields, which means they can be placed directly within supported document templates and do not need to be inside a repeating table. Merge fields are case sensitive and must be entered exactly as displayed below.

Project Group Information

Use these fields to display information about the Project Group.

DescriptionMerge Field
Project Group Description

[ProjectGroupDescription]

Project Group Name

[ProjectGroupName]

Project Group Dates

Earliest start date and latest due date across the group's projects. All dates print in the DD/MM/YYYY format.

DescriptionMerge Field
Project Group Start Date[ProjectGroupStartDate]
Project Group Due Date[ProjectGroupDueDate]

Project Group Financials

Grouped Forecast Costs

Combined forecast cost of all projects in the group.

DescriptionMerge Field
Task Costs[ProjectGroupTaskForecastCost]
Product Costs[ProjectGroupProductForecastCost]
Total Costs[ProjectGroupForecastCost]

Grouped Forecast Revenue

Combined forecast revenue of all projects in the group.

DescriptionMerge Field
Task Revenue[ProjectGroupTaskForecastRevenue]
Product Revenue[ProjectGroupProductForecastRevenue]
Total Revenue[ProjectGroupForecastRevenue]

Grouped Actual Costs

Combined actual cost of all projects in the group.

DescriptionMerge Field
Task Costs[ProjectGroupTaskActualCost]
Product Costs[ProjectGroupProductActualCost]
Purchase Order Disbursement Costs[ProjectGroupDisbursementCost]
Total Costs[ProjectGroupTotalCost]
Supplier Credit Note Total[ProjectGroupSupplierCredits]
Net Cost (Total Cost - Supplier Credit Total)[ProjectGroupNetCost]

Grouped Actual Revenue

Combined actual revenue of all projects in the group.

DescriptionMerge Field
Task Revenue[ProjectGroupTaskRevenue]
Product Revenue[ProjectGroupProductRevenue]
Purchase Order Disbursement Revenue[ProjectGroupPurchaseRevenue]

Grouped Invoice Totals

Combined invoice totals across all projects in the group.

DescriptionMerge Field
Total Invoiced[ProjectGroupTotalInvoiced]
Client Credit Note Total[ProjectGroupTotalCredits]
Net Revenue (Total Invoiced - Client Credit Total)[ProjectGroupNetRevenue]

Grouped Profitability

Combined forecast and actual profit, each as an amount or as a percentage, of all projects in the group.

DescriptionMerge Field
Forecast Profit Total (Value)[ProjectGroupForecastProfit]
Forecast Profit Total (Percentage)[ProjectGroupForecastProfit%]
Actual Profit Total (Value)[ProjectGroupActualProfit]
Actual Profit Total (Percentage)[ProjectGroupActualProfit%]

Troubleshooting

Project Group Fields Are Blank

Check that:

  • The applicable information has been recorded against the Project Group.
  • If using supported document templates other than project group templates, ensure the relevant transaction has a project group assigned.
  • The project group is NOT a parent or nested project group (has projects, not project groups as it's child)

Merge fields are case sensitive.

Merge Fields Appear Instead of Values

Check:

  • Merge field spelling
  • Capitalisation
  • Document compatibility
  • That both square brackets are present

Merge fields are case sensitive.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article