Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents for 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

Warning: Update the REF_SUM table only if the balances in the GL_DETL table are correct and Deltek Customer Care advises you to perform the update process.

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.