Use this screen to print the Open Billing Detail Report. This report contains much of the unbilled transaction information found in the Open Billing Detail screen (Projects\Maintain\Billing). 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 Number
Timesheet Date
Hours
General Labor Category
Project Labor Category
Labor ID Type (Employee or Vendor)
Employee or Vendor Name
Amount
This screen consists of three blocks and one subtask. They can be used as follows:
Use the fields in the Identification block to enter a parameter ID and parameter description. You can save the parameters and use them each time the report is required.
Use the fields in the Selection Ranges block to enter limitations on the transactions that will be printed on the report. You can limit the transactions to be printed by accounting period and by project.
Use the fields in the Options block to enter printing options for the report.
Use the Project Non-Contiguous Ranges subtask to enter non-contiguous ranges of projects selected for the report.
You can print this report at any time, but you may find it most helpful to print immediately after posting the bills, so that unbilled transactions can be viewed. Additionally, you may want to print immediately before calculating your bills to get an idea of the transactions awaiting billing.
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should 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 produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to limit the transactions that will be printed on the report.
Accounting Period
This non-editable field displays a value of "One." You can print only one ending period each time. The report will include all periods up to and including the one entered here.
Enter, or use Lookup to select, the fiscal year of the transactions that you want to include on the report. The report will include all fiscal years up to and including the fiscal year entered in this field.
Enter, or use Lookup to select, the period of the transactions that you want to include on the report. The report will include all periods up to and including the period entered in this field.
Enter, or use Lookup to select, the subperiod of the transactions that you want to include on the report. The report will include all subperiods up to and including the subperiod entered in this field.
Project *
Use this drop-down box to select the range option for the project you want to include on the report. The following options are available:
All - Select this option to include all available projects. The Start and End fields are disabled for this option.
One - Select this option to include only one project. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of projects. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the projects from the beginning of the available projects to a specific project in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the projects from a specific project to the end of all the available projects. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting project number for the range that you want to include on the report.
If you select "One," "Range," or "To End" in the Project Option field, you must enter a project number in this field.
If you select "All" or "From Beginning" in the Project Option field, this field will be inactive.
Enter, or use Lookup to select, an ending project number for the range that you want to include on the report.
If you select "All," "Range," or "From Beginning" in the Project Option field, you must enter a project number in this field.
If you select "One" or "To End" in the Project Option field, this field will be inactive.
Select this checkbox to use non-contiguous ranges on the report. You must use the Project Non-contiguous Ranges subtask to complete the information needed for this option.
Use the fields in this block to select printing options for the report.
Select this checkbox to suppress the labor cost on the report.
Select this checkbox to include the notes or comments that have been entered in the transaction screens.
* A red asterisk denotes a required field.
Select this link to open the Project Non-Contiguous Ranges subtask, where you can enter non-contiguous ranges of projects for the report.
This screen uses the following tables:
OPEN_BILLING_DETL (Open Billing Detail)
PROJ_BILL_INFO (Project Billing Information)