WIP Exception Report

The WIP Exception Report screen is divided into two sections; System Parameters and User Parameters. In the System Parameters section, the user must specify details for the format of the report; in the User Parameters section, the user must specify details pertaining to the content of the report. For general information on running reports and on defining System Parameters, please refer to the Running Reports help document.

Report Description

The WIP Exception Report can be generated for all Offices, or for a specific Office and range of Departments within that Office. The report is also generated based on a user specified range of Responsible Timekeepers, and for WIP of a specific age.

Report details include the following for each record: Client Number and Name, Matter Number and Name, Exception WIP Disbursements, Exception WIP Fees, Exception WIP Hours, Total WIP Disbursements, Total WIP Fees, and Total WIP Hours.

The report output can be generated into an Excel spreadsheet file, or in the same manner as most other reports (i.e. format selected in the System Parameters section). When generating an Excel file, the user must specify the full path and file name (i.e. c:\My Documents\WIP Exception.xls). Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output in addition to output in another format.

User Parameters

Office
From the list provided, the user must select the Office for which the report will be produced. The names of all Offices associated with your Firm will be displayed in the list. To include all Offices in the report, the user must select the "Select All" option. This field defaults to the Select All option.

Start Department, End Department
From the lists provided, the user must select the range of Departments to be included in the report. The names of all Departments associated with your Firm will be displayed in the list. The user also has the option to manually enter the unique identifiers of the Departments. To include all Departments in the report, the user must select the "Select All" option in both fields. These fields default to the Select All option.

Start Timekeeper, End Timekeeper
From the lists provided, the user must select the range of Timekeepers for whom the report will be produced. The user also has the option to manually enter the unique identifiers for the Timekeepers. These fields default to the first and last Timekeepers in the list.

WIP In Excess of X Days
The user must manually enter the age of the Work in Progress to be included in the report (i.e. to include WIP that is ten or more days old, the user must enter "10" in this field). This field defaults to "0".

Create Excel Output
To send the report contents to an Excel spreadsheet file, the user must select the "Y" (i.e. Yes) option form the drop down list provided. This field defaults to the "N" (i.e. No) option. Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output as well as output in another format.

Excel Destination
If the user has selected to send the report contents to an Excel spreadsheet file, they must then specify the exact path and name for that file (i.e. c:\My Documents\WIP Exception.xls).