Contents of the Update Reference Summary Balances Screen
Use the fields and options to configure the Update Reference Summary Balances screen.
Identification
| Field | Description |
|---|---|
| Fiscal Year |
Enter, or click
|
to select, the fiscal year for which you want to run the utility.
Table Window
Click the Fill Balance work table with differences option on the Action menu to check the GL_DETL and REF_SUM tables. Costpoint verifies that the data for the fiscal year in the two tables agree. If they do, a message indicates that, and the table window remains empty. If one or more account/reference number combinations are not in balance, Costpoint displays the proposed replacement data in the table window.
| Field | Description |
|---|---|
| Account, Reference |
Costpoint displays any account/reference number combinations for which the data in the GL_DETL table and the REF_SUM table do not agree. |
| GL Detail Summary Amt |
This column displays the total year-to-date balance for the account/reference number from the GL_DETL table. |
| GL Detail Summary Hrs |
This column displays the total year-to-date hours charged to this account/reference number from the GL_DETL table. |
| Ref Summary Amount |
This column displays the sum for the fiscal year of all the period Amount columns from the REF_SUM table for the account/reference number. |
| Ref Summary Hours |
This column displays the sum for the fiscal year of all the period Hour columns from the REF_SUM table for the account/reference number. |
Update the REF_SUM Table
If Deltek Customer Care recommends that you proceed with the update process to correct the out-of-balance situation, click the arrow next to
and select
Update REF Summary Balances to replace the balances in the REF_Sum table based on the data in the GL_DETL table.