Use this screen to refine the unbilled amounts by project. The Create Unbilled Analysis Report process (Projects » Billing » Unbilled Receivables) populates this screen by project, fiscal year, period, and subperiod with relevant system-defined reason codes. The table rows display the difference between inception-to-date billings and inception-to-date revenue by the system-defined code. Unbilled amounts that are not associated with system-defined codes will display as NONE. You can reassign the unbilled amount associated with the NONE code to various user-defined unbilled reason codes that will more accurately describe an unbilled balance. User-defined reason codes are initialized in the Maintain Unbilled Reason Codes screen (Projects » Billing » Unbilled Receivables).
Use this screen after running the Create Unbilled Analysis Report screen and before attempting to print the Unbilled Reason Code report in the Print Unbilled Analysis screen (Projects » Billing » Unbilled Receivables).
This non-editable field displays the project ID. The project description displays in the field to the right.
This non-editable field displays the fiscal year of the project. This fiscal year was selected in the Create Unbilled Analysis Report screen (Projects » Billing » Unbilled Receivables). Unbilled amounts are calculated up to and including the fiscal year, period, and subperiod combination in these fields.
This non-editable field displays the period of the project, which was selected in the Create Unbilled Analysis Report screen (Projects » Billing » Unbilled Receivables). Unbilled amounts are calculated up to and including the fiscal year, period, subperiod combination in these fields.
This non-editable field displays the subperiod of the project. This subperiod was selected in the Create Unbilled Analysis Report screen (Projects » Billing » Unbilled Receivables). Unbilled amounts are calculated up to and including the fiscal year, period, and subperiod combination in these fields.
Click this button to display project data at and below the project number entered. After you click this button, the Project field displays in the table window. This button is not available until you use Query to select a project.
Use this table window to review the unbilled balance by project and unbilled reason code. You can reclassify the unbilled amount associated with the None reason code to more accurately describe the unbilled balance for reporting purposes.
This non-editable field displays all project numbers at and below the Project number in the header of the screen. The associated reason code data and amounts display in each row. This field does not display unless you click the Detail Levels button.
This non-editable field displays the system-defined unbilled reason codes. You cannot change any of the system-calculated amounts or unbilled reason codes; however, you can add lines to further define the unbilled amounts. When you add lines and amounts to the table you must be sure to adjust the amount associated with the None reason code. The total amount in either the Actual Amount or Target Amount columns must be equal to the Total field at the bottom of the screen before the record can be saved. Use the Running Total field to evaluate the total in the table window for the Actual Amount or Target Amount column.
This non-editable field displays the unbilled reason code description that is established in the UNBILLED_RSN_CD table. You cannot change this description in this screen, but you can change it in the Maintain Unbilled Reason Codes screen.
The Actual Amount column contains amounts calculated using the actual burden columns in the Projects tables. You cannot change the system-calculated amounts in this column. When you add a new line with a user-defined code, you can enter an amount in this column. When you do this, the Running Total will change. You must fully allocate the NONE or other project-specific reason code or change the NONE amount so that the Running Total matches the Total. You cannot save the record until these two amounts are the same.
The Target Amount column will contain amounts calculated using the target burden columns in the Projects tables. You cannot change the system-calculated amounts in this column. When you add a new line with a user-defined code, you can enter an amount in this column. When you do this, the Running Total will change. You must fully allocate the NONE or other project-specific reason code or change the NONE amount so that the Running Total matches the Total. You cannot save the record until these two amounts are the same.
Use this column to allow or disallow recalculation of user-defined unbilled reason codes.
System-defined reason codes are always recalculated. S displays in this column for system-calculated records. If S displays, the Recalculate column is non-editable.
The initial value for this column is Y. If the value is Y, Costpoint will remove the user-defined rows in that table and include the values in the NONE amount when the Create Unbilled Analysis process is executed. Set this field to N to prevent this type of recalculation. For example, if you have reassigned the NONE amount to a reason code of COMP for completed contract, you may want to change this field to N so that you will not have to reassign the NONE amount to COMP each time you run the Create Unbilled Analysis Report tables process. An unbilled amount for a completed contract may exist until a final audit is done. Use this flag to define an unbilled amount that will not be recalculated until you reset the flag. Once you set this field to N, the row will not be recalculated until you change this field to Y.
Enter notes to provide a more detailed explanation of why the unbilled item exists. You can include these notes on the report.
These non-editable fields display the difference between total revenue and total billings from the Project and Billings tables. The system calculates total revenue by adding the PSR_PY_SUM. TOT_REV_AMT, and PROJ_SUM.TOT_REV_ACT/TOT_AMT up to and including the fiscal year, period, and subperiod combination entered in the Create Unbilled Analysis Report screen. The PROJ_BILL_HS.BILLED_AMT, up to and including the fiscal year, period, and subperiod entered in the Create Unbilled Analysis Report tables screen, is subtracted from the total revenue calculated. This represents the true unbilled amount that is in the system for a given project.
This column displays the total of all the rows in the child table window. As you edit amounts on the rows, the amount in this column is automatically updated. You cannot save the record unless the Total and the Running Total columns are the same.
Changes to this screen update the RPT_UNBILLED_RSN table.