Print Open Billing Detail Report

Use this screen to print the Open Billing Detail Report.

This report contains much of the unbilled transaction information found on the Manage Open Billing Detail screen. It contains only transactions that have not been included on a posted bill.

Detailed information on the report includes:

  • Fiscal Year, Period, and Subperiod
  • Source Journal
  • Transaction Description
  • Journal Entry Number or Voucher No.
  • Timesheet Date
  • Hours
  • General Labor Category
  • Project Labor Category
  • Labor ID Type (Employee or Vendor)
  • Employee or Vendor Name
  • Status
  • Qty
  • Hours
  • Amount

The Status field displays a pre-defined system code for each transaction on the report. The status codes are not stored in Costpoint but derive from the values, if any, found in the On Hold and Write Off fields for Cost, Hours, and Units on the Manage Open Billing Detail screen. The Status codes are:

  • H: This code means that the transaction amounts/hours/units are on hold or partially on hold. You can determine whether the transaction is completely or partially on hold by comparing the Status value and Amount on the report.  If the Status is H and the Amount is 0.00, the transaction is on hold. If the Status field is H and the Amount is not 0.00, the transaction is on a partial hold.
  • W: This code means the transaction amount is being fully or partially written off. You can determine whether the transaction is being completely written off or only a portion is being written off. If the Status is W and the Amount/Hours/Qty field on the report is 0.00, the transaction is being fully written off. If the Status is W and the Amount/Hours/Qty field on the report is not 0.00, the transaction amount is being partially written off.
  • R: This code means that the transaction has amounts/hours/units in the Previously Billed field. There could also be amounts/hours/units in the On Hold and Write Off fields. R designates that there is a residual amount/hour/unit remaining to be billed.
  • HW: This code means that the transaction has both On Hold and Write Off amounts associated with the record. This is not a common occurrence.

You can print this report at any time, but you may find it most helpful to print immediately after posting the bills, so that you can view unbilled transactions. Additionally, you can print immediately before calculating your bills to get an idea of the transactions awaiting billing.