Purchase Order Burn Report

The Purchase Order Burn report provides a summary and detailed breakdown of hours and amounts accrued against specific Purchase Orders.

Report Criteria

Data item Definition

Enter Period End Date

The From and To dates indicate the Period End Dates for which transactions will be accrued against the Purchase Orders.

For example, if you run the report from January 1, 2024 to December 31, 2024 then the report will only consider transactions associated with a charge where the period end date for the charge falls within 2024. To cover a larger time frame you can run the report for further in the past and leverage the Active/Inactive Purchase Orders filter.

View

Allows you to run the report in a summary view by Purchase Order or a detailed output of all transactions related to the Purchase Order. This option can be changed after the report is run without changing any other filters if you’d like to see both views.

Past Warning Date

  • Yes: Show only Purchase Orders that have bill amounts for the given time period and are passed their warning date.
  • No: Show only Purchase Orders that have bill amounts for the given time period and are not passed their warning date.
  • All: Show all Purchase Orders that have bill amounts for the given time period.

Past Warning Balance

  • Yes: Show only Purchase Orders that have bill amounts for the given time period and are passed their warning balance.
  • No: Show only Purchase Orders that have bill amounts for the given time period and are not passed their warning balance.
  • All: Show all Purchase Orders that have bill amounts for the given time period.

Active Purchase Orders

  • Active: Show only Purchase Orders that have bill amounts for the given time period and the Purchase Orders’s end date is empty, greater than, or equal to today’s date.
  • Inactive: Show only Purchase Orders that have bill amounts for the given time period and the Purchase Orders’s end date is less than today’s date.
  • All: Show all Purchase Orders that have bill amounts for the given time period.

Invoiced Only

  • Yes: Show only Purchase Orders that have bill amounts for the given time period and the Purchase Order is associated with a transaction that is invoiced. The totals will reflect only the invoiced transactions against this Purchase Order and it will not display totals for transactions that have yet to be invoiced.
  • No: Show all Purchase Orders that have bill amounts for the given time period.

Recognized Revenue Only

  • Yes: Show only Purchase Orders that have bill amounts for the given time period and the Purchase Orders is associated with a transaction that has unbilled revenue created for it. The totals will reflect only the transactions that are associated with this Purchase Orders and have unbilled revenue against them. It will not display totals for transactions that have yet to have Unbilled Revenue.
  • No: Show all Purchase Orders that have bill amounts for the given time period.

Waiting to Bill Only

  • Yes: Show only Purchase Orders that have bill amounts for the given time period and the Purchase Orders is associated with a transaction and that transaction has not yet been revenue recognized or invoiced. The totals will reflect only the transactions against this Purchase Orders that have yet to be revenue recognized or invoiced and it will not display totals for transactions that have been revenue recognized or invoiced.
  • No: Show all Purchase Orders that have bill amounts for the given time period.

Company

The Purchase Order filter will filter the results based on the company(s) selected within this filter. This filter is optional.

Purchase Order(s)

The results are filtered by the Company filter. Using this filter will filter the results by the specified Purchase Order(s) selected.

Placement ID

The report will filter the results based on the placement(s) selected within this filter. This filter is optional.

Candidate ID

The report will filter the results based on the candidate(s) selected within this filter. This filter is optional.

Summary Fields

Data Item Definition

Company

The Company associated with the Purchase Order

PO Name

The Purchase Order Name

Description

The Purchase Order Description

Start Date

The Purchase Order Start Date

End Date

The Purchase Order End Date

Total Amount Budgeted

The Purchase Order Total Amount Budgeted

Warning Balance

The Purchase Order Warning Balance

Warning Date

The Purchase Order Warning Date

External Amount

The Purchase Order External Amount. This field is designed to be used if you are tracking any amounts outside of Bullhorn and the report will use it in the calculation of Total Amount

Total Hours Budgeted

The Purchase Order Total Hours Budgeted

Total Hours Accrued

The total amount of hours for the Bill Transactions associated to this Purchase Order

Amount Waiting to be Billed

The total dollar amount for the Bill Transactions associated to this Purchase Order where the transactions have not been Revenue Recognized or Invoiced

Amount Revenue Recognized

The total dollar amount for the Bill Transactions associated to this Purchase Order where the transactions have been Revenue Recognized but have not yet been Invoiced

Amount Invoiced

The total dollar amount for the Bill Transactions associated to this Purchase Order where the transactions have been Invoiced

Total Amount

The total dollar amount associated to Bill Transactions associated to this Purchase Order

Remaining Balance

Calculated Column: Total Amount Budgeted - (External Amount + Total Amount)

CRF Label

The label of the Customer Required Field (CRF) that the Purchase Order is associated with

Option Value

The Option Value of the Customer Required Field that the Purchase Order is associated with. This will always be the Purchase Order name

Option Display Label

The Option Display Label of the Customer Required Field that the Purchase Order is associated with. This will always be the Purchase Order name

Custom Date (1-5)

The Custom Date fields associated with the Purchase Order entity. These columns will not be visible if they are not enabled in field maps or if there is no data populated in the results of the report

Custom Int (1-5)

The Custom Int fields associated with the Purchase Order entity. These columns will not be visible if they are not enabled in field maps or if there is no data populated in the results of the report

Custom Text (1-5)

The Custom Text fields associated with the Purchase Order entity. These columns will not be visible if they are not enabled in field maps or if there is no data populated in the results of the report

Detail Fields

Data Item Definition

Company

The Company associated with the Purchase Order

PO Name

The Purchase Order Name

Billable Charge ID

The Billable Charge ID related to the Bill Transaction associated to this Purchase Order

Invoice

The Invoice ID related to the Bill Transaction associated to this Purchase Order

Transaction Date

The Work Date for the Bill Transaction associated to this Purchase Order

Earn Code

The Earn Code for the Bill Transaction associated to this Purchase Order

Rate

The Bill Rate for the Bill Transaction associated to this Purchase Order

Hours

The Hours for the Bill Transaction associated to this Purchase Order

Amount

The Dollar Amount for the Bill Transaction associated to this Purchase Order

Candidate ID

The Candidate ID for the Bill Transaction associated to this Purchase Order

Candidate Name

The Candidate Name for the Bill Transaction associated to this Purchase Order

Placement ID

The Placement ID for the Bill Transaction associated to this Purchase Order

Job ID

The Job ID for the Bill Transaction associated to this Purchase Order

Job Title

The Job Title for the Bill Transaction associated to this Purchase Order

CRF Type

The Type of Customer Required Field (CRF) that the Purchase Order is associated with. This will always be Purchase Order

CRF Label

The label of the Customer Required Field (CRF)that the Purchase Order is associated with

Option Value

The Option Value of the Customer Required Field (CRF) that the Purchase Order is associated with. This will always be the Purchase Order name

Option Display Label

The Option Display Label of the Customer Required Field (CRF) that the Purchase Order is associated with. This will always be the Purchase Order name

Period End Date

The Period End Date of the Billable Charge related to the Bill Transaction associated to this Purchase Order

Amount Waiting to be Billed

The total dollar amount for the Bill Transactions associated to this Purchase Order where the transactions have not been Revenue Recognized or Invoiced

Amount Revenue Recognized

The total dollar amount for the Bill Transactions associated to this Purchase Order where the transactions have been Revenue Recognized but have not yet been Invoiced

Amount Invoiced

The total dollar amount for the Bill Transactions associated to this Purchase Order where the transactions have been Invoiced

Total Amount

The total dollar amount associated to Bill Transactions associated to this Purchase Order

Custom Date (1-5)

The Custom Date fields associated with the Purchase Order entity. These columns will not be visible if they are not enabled in field maps or if there is no data populated in the results of the report

Custom Int (1-5)

The Custom Int fields associated with the Purchase Order entity. These columns will not be visible if they are not enabled in field maps or if there is no data populated in the results of the report

Custom Text (1-5)

The Custom Text fields associated with the Purchase Order entity. These columns will not be visible if they are not enabled in field maps or if there is no data populated in the results of the report