Costpoint Help

Update Reference Summary Balances

When Deltek Customer Care recommends it, use this screen to update balances in the Reference Summary (REF_SUM) based on activity in the General Ledger Detail (GL_DETL) table.

Warning: Do not run this update process unless Deltek Customer Care instructs you to do so.

Generally, only database problems or the occurrence of a technical problem during posting routines make it necessary to run this utility.

You can also use this during your regular period-end processing to check for discrepancies between the GL_DETL table and the REF_SUM table. To do that, click the arrow next to and select Load Balance Differences.

If Costpoint display any rows in the table window, that indicates an out-of-balance condition. Call Deltek Customer Care before proceeding. If the table window is empty when the process ends, the GL_DETL and REF_SUM tables balance. You can proceed with the period-end closing process.

This process uses dynamic worktables. Because these tables are user-specific and are deleted when the process ends, each user can run only one process at a time.

Before you start the update process:

  • Confirm that the GL_DETL table contains complete and accurate data. Deltek Customer Care can advise you on how to determine the accuracy of the GL_DETL table data. The update process replaces all period and subperiod hours and currency amounts for the fiscal year with data from the GL_DETL table.
  • Back up your database.
  • Make sure no one else is using Costpoint.
Note: Multiple users can run the process simultaneously if they are logged in with different user names. However, Deltek strongly recommends that you not do this. For the best data integrity, only one user at a time should run the update process in this screen, and only under the guidance of Deltek Customer Care.

Related Topics:

Display the Update Reference Summary Balances Screen

You access the Update Reference Summary Balances screen from the Accounting domain.

Contents of the Update Reference Summary Balances Screen

Use the fields and options to configure the Update Reference Summary Balances screen.

Table Information for the Update Reference Summary Balances Screen

This process updates the REF_SUM table.

Parent Topic:

General Ledger Utilities