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
-
Amount
-
Status
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.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Accounting Period
Use this group box to select the ending period you would like to print. All transactions in Open Billing Detail that are this period or before are printed on the report.
Option
This field always displays One.
End Fiscal Year
Enter, or click 
to select, the fiscal year for which you want to print. All transactions in the Open Billing Detail table that have fiscal years up to and including the fiscal year selected here are printed on the report.
End Period
Enter, or click to select, the period for which you want to print. All transactions in the Open Billing Detail table that have periods up to and including the period selected here are printed on the report.
End Subperiod
Enter, or click to select, the subperiod for which you want to print. All transactions in the Open Billing Detail table that have subperiods up to and including the subperiod here are printed on the report.
Project
Use this group box to limit the projects that are included in the report.
Option
Use the drop-down list to select the range of projects you want printed on the report. This range must include, for each project that you want on the report, the Invoice Project (the highest level of the project that you are billing). The transactions that have been posted at and below the invoice project level are included on the report, regardless of whether or not they have been established on the Manage Project Billing Information screen. Valid options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, a valid starting project. Costpoint validates the project entered here against the projects entered on the Manage Project User Flow.
End
Enter, or click to select, a valid ending project. Costpoint validates the project entered here against the projects entered on the Manage Project User Flow.
Non-Contiguous Range
Select this check box to choose a noncontiguous range of projects to print on the report. Use the Project Non-Contiguous Ranges subtask to select the ranges.
Bill Groups
Use this group box to print the report for a particular billing user group or a range of billing user groups. This group box is not available unless the Assign Bills to User Groups check box is selected on the Configure Billing Settings screen.
Option
Use the drop-down list to select the range of billing user groups for which you want to print the report. Valid options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, a starting billing user group.
End
Enter, or click to select, a valid ending billing user group.
Options
Suppress Cost
Select this check box to suppress the labor cost on the report. If your user ID has been set up in Costpoint System Administration to suppress labor, no labor cost amounts are available.
Include Notes
Select this check box to include the notes or comments that have been entered in the transaction screens.
Subtasks
|
Subtask
|
Description
|
|
Project Non-Contiguous Ranges
|
If you selected the Non-Contiguous Ranges check box, use the Project Non-Contiguous Ranges subtask to select a noncontiguous range of projects.
|