Assign Unbilled Reason Codes

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.  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.  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.  Unbilled amounts are calculated up to and including the fiscal year, period, and subperiod combination in these fields.

This non-editable field displays the difference between total actual 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_AMT up to and including the fiscal year, period, and subperiod combination entered in the Update Unbilled Analysis Report Tables screen.

The PROJ_BILL_HS.BILLED_AMT, up to and including the fiscal year, period, and subperiod entered in the Update Unbilled Analysis Report Tables screen, is subtracted from the total revenue calculated above. This represents the true unbilled amount in the system for a given project.

This non-editable field displays the difference between total target 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_TGT_AMT up to and including the fiscal year, period, and subperiod entered in the Update Unbilled Analysis Report Tables screen.

The PROJ_BILL_HS.BILLED_AMT, up to and including the fiscal year, period, and subperiod entered in the Update Unbilled Analysis Report Tables screen, is subtracted from the total revenue calculated above.  This represents the true unbilled amount in the system for a given project.

This non-editable field displays the total of all the rows in the Actual Amount column of the table window.

As you edit amounts on the rows, the amount in this field is automatically updated. You cannot save the record unless the Total and the Running Total fields are the same.

This non-editable field displays the total of all the rows in the Target Amount column of the table window.

As you edit amounts on the rows, the amount in this field is automatically updated. You cannot save the record unless the Total and the Running Total fields are the same.

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 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 before the record can be saved.  Use the Running Total field to evaluate the total for the Actual Amount or Target Amount column.

This non-editable field displays the unbilled reason code description that is defined 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 field displays amounts calculated using the actual burden fields in the Projects tables.

You cannot change the system-calculated amounts in this field. When you add a new line with a user-defined code,  you can enter an amount in this field.

When you do this, the Running Total (Actual) will change. You must fully allocate the "NONE" or change the "NONE" amount so that the Running Total (Actual) matches the Total (Actual). You cannot save the record until these two amounts are the same.

The Target Amount field contains amounts calculated using the TargetBurden fields in the Projects tables.

You cannot change the system-calculated amounts in this field. When you add a new line with a user-defined code, you can enter an amount in this field.

When you do this, the Running Total (Target) will change. You must fully allocate the "NONE" or change the "NONE" amount so that the Running Total (Target) matches the Total (Target). You cannot save the record until these two amounts are the same.

Use this field to allow or disallow recalculation of user-defined unbilled reason codes. System-defined reason codes are always recalculated. S displays in this field for system-calculated records. If S displays, the Recalculate field is non-editable.

The initial value for this field is Y. If the value is Y, the system will remove the user-defined rows in that table and include the values in the "NONE" amount when the Create Unbilled Analysis process is run.

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

This field is particularly helpful when an unbilled amount will not change for a long period of time.

Enter notes to explain why the unbilled item exists. You can include these notes on the report.