Unbilled Analysis Report

Use this screen to print the Unbilled Analysis Report (Summary or Detail) or the Unbilled Reason Code Report. The Unbilled Analysis Report provides information on the computation of the unbilled balance and the major components of the balance.

Select the report you want to print using the drop-down arrow on the Print icon on the toolbar.

When should I use this screen?

Use this screen whenever you want to print the Unbilled Receivable Analysis Report or the Unbilled Reason Code Report. To obtain the most current data, you must run the Update Unbilled Analysis Report Tables process before printing these reports.

Field Descriptions

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. 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.

Selection Ranges

Use the fields in this block to limit the data that displays on the report. You can limit by:

Use this drop-down box to select the value that you want to use to limit the data that will print on the report. The options available are:

Project
Organization
Project Manager
Project Type
Project Classification
Project Account Group
Customer
Bill User Group
Reason Code

Use this drop-down box to select the range option that you want to use to limit the records that print on the report. The value that you enter in the Start and End fields depends on the selection that you make in the Option field. The following options are available:

All- Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. 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 records. 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 records from the beginning of the available records to a specific record 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 records from a specific record to the end of all the available records. 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 value for the range that you want to include on the report. The value entered in this field depends on the selection made in the Select field.

If you select One, Range, or To End, in the Option field, you must enter a value in this field.

If you select All or From Beginning in the Option field, this field will be inactive.

Enter, or use Lookup to select, an ending value for the range that you want to include on the report. The value entered in this field depends on the selection made in the Select field.

If you select "All" or "From Beginning" in the Option field, you must enter a value in this field.

If you select "One," or "To End," in the Optionfield,this field will be inactive.

This non-editable field displays "One" because you can only print the report for one accounting period at a time.

Enter, or use Lookup to select, the fiscal year of the transactions that you want to include on the report.

Enter, or use Lookup to select, the period of the transactions you want to include on the report.

Enter, or use Lookup to select, the subperiod of the transactions that you want to include on the report.

This non-editable field displays the suberiod ending date.

Options

Use the fields in this block to select the project and organization levels that you want for the report. You can also select the rate type and several printing options.

Include

Use the fields in this group box to select the project and organizational level at which you want to print the report.

Enter the organization level to include on this report. All the records on the report will be rolled up to this level of the organization. This field is not available if you selected Bill Group in the Select drop-down list.

Enter the project level to include on this report. All the records on the report will roll up to this level of the project. This field is not available if you select the Project Unbilled Level check box.

Select this checkbox to print the Unbilled Analysis Report at the current unbilled project level, which is where the General Ledger balance resides. This check box is not available if you selected Customer or Reason Code in the Select drop-down list.

Revenue Rate Type

Select this radio button to print an actual rate.

Select this radio button to print a target rate.

Show

Select this checkbox to include the amount in thousands on the report.

Select this checkbox to include lines with no activity on the report.

Select this checkbox to include inactive projects in your report. Selecting this checkbox will make the report substantially longer if you have many inactive projects in your database.

Select this checkbox to include the Reason Code Notes entered in the Assign Unbilled Reason Codes screen (Projects\Transactions\Unbilled Receivables) on this report.

Reports

When you're ready to print, select the report you want from the drop-down box in the Print icon on the toolbar. Your choices are:

The Summary Report provides a quick reference on the unbilled balance computation. It includes the following information:

The Detail Report (printed in legal/landscape) provides information on the major components that comprise the unbilled balance. All amounts on this report are displayed rounded to the nearest whole currency unit (such as the dollar or Euro). The Detail Report includes the following information: