Contents of the Update General Ledger Beginning Balances Screen
Use the fields and options to configure the Update General Ledger Beginning Balances screen.
Identification
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.
Field | Description |
---|---|
Parameter ID |
Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY. When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query. You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults. |
Description |
Enter, or click to select, a parameter description of up to 30 alphanumeric characters. |
Selection Ranges
Field | Description |
---|---|
Fiscal Year |
Enter the fiscal year from which you need to bring forward ending balances, or use Lookup to select it. You can only enter open fiscal years. |
Fiscal Year to be Updated |
This non-editable field displays the fiscal year for which Costpoint will update the beginning balances. That fiscal year is the next year in the sequence of fiscal years established on the Manage Fiscal Years screen. Confirm that this year is correct before you run the update process. For example, if the 2009 fiscal year just ended and you want to update beginning balances for the 2010 fiscal year, you enter 2009 in Fiscal Year, and Costpoint displays 2010 in Fiscal Year to be Updated, assuming that 2010 is the next fiscal year sequentially on the Manage Fiscal Years screen. |
Include Adjustment Periods |
Select this check box to include amounts in adjustment periods. Note: You can use this check box if you select the
Allow this default to be changed in Update process check box on the Configure General Ledger Settings screen.
|
Options
Print Options
Field | Description |
---|---|
Print Subtotals |
Select this check box to display subtotals on the Update General Ledger Beginning Balances Report. |
Show
Field | Description |
---|---|
Changed Balances Only, All Balances |
Select either All Balances or Changed Balances Only to indicate if you want the Update General Ledger Beginning Balances report to display all balances or only balances that have changed. |
Set Fiscal Year Status to Closed |
Select this check box if you want the update process to set the status of the fiscal year to Closed. To close the fiscal year using the update process, you must close all periods for the selected fiscal year before you run the process. You cannot enter data in closed fiscal years. Note, however, that you can change the status of a fiscal year from Closed back to Open on the Manage Fiscal Years screen, if necessary. |
Closing Rate Type |
If you select Set Fiscal Year Status to Closed, select the closing rate type for the carry-forward of project indirect burden for the fiscal year from which you need to bring forward ending balances. The options are Target and Actual. (Note that you must always update the general ledger beginning balances using this process before you can update prior year history for projects in the Update Project Prior Year History screen.) Costpoint stores target and actual indirect rates for each fiscal year in the Projects folder, and it stores indirect burden amounts project. When you run the Update Project Prior Year History process to create this history, Costpoint uses the closing rate type for the fiscal year. (Open fiscal years do not have a closing rate type assigned.) If you do not select Set Fiscal Year Status to Closed, this field is not available. |
Sort By
Field | Description |
---|---|
1st Sort |
Select the primary sort for the report from the drop-down list: Account or Organization. |
Update Beginning Balances
- To update beginning balances without generating the Update General Ledger Beginning Balances report, make all of your entries in the Update General Ledger Beginning Balances screen, click Update G/L Beginning Balances on the Action menu.
- To update balances and print the report, click Print/Update G/L Beginning Balances on the Action menu.
Costpoint displays a message that asks you to confirm that you want to run the update process. If you select OK, Costpoint generates the Update General Ledger Beginning Balances report and then runs the update process.
When the update process starts, a DO NOT INTERRUPT message displays, along with a counter that indicates the number of records processed.
Additional Processing Information
When you post system journals, Costpoint stores the resulting data in several key tables. That data provides the basis for financial statements and other reports and inquiries that present posted data at both summary and detail levels. The discussion below is a high-level overview of the general processes involved in updating the general ledger beginning balances.
During posting, Costpoint collects transactions from the journals, assigns them unique sequence numbers, and stores them, as appropriate, in the following key tables:
Field | Description |
---|---|
Transaction Posting Detail (GL_DETL) |
This table holds detail information for each transaction posted to the general ledger. As an example, Costpoint stores each line from an AP voucher as an individual row in this table. Detail information appropriate to the posting source, such as the check number, invoice number, timesheet date, and so on, is retained in this table. Account/organization/project data and beginning balance information are not stored in this table. However, reference number detail data is stored in this table. |
Transaction Posting Summary (GL_POST_SUM) |
Costpoint stores summary information in this table when you post to the general ledger. Costpoint accumulates data from the Transaction Posting Detail table for each unique combination of account, organization, project, fiscal year, period, subperiod, journal type, and journal sequence number and saves that summary information in this table. Detail information, such as check number or purchase order number, is not stored in this table. Costpoint stores beginning balance information in this table (Journal Code = BEG, Pd = 0, and Subpd = 0) when you enter beginning balances for your first fiscal year during initialization. After initialization, Costpoint updates the beginning balances in this table when you run the Update General Ledger Beginning Balances process. |
Financial Statement Summary Account Balances (FS_SUM) |
This table also contains summary information but at a higher level than the Transaction Posting Summary table. When you post to the general ledger, Costpoint accumulates data from the Transaction Posting Detail table for each unique combination of account and organization and stores it in this table incrementally for each accounting period (for each fiscal year). Each additional posting for an account/organization combination changes the stored period total, regardless of the journal source. |
Reference Summary (REF_SUM) |
If you use reference numbers during data entry, this table, which stores reference number data, is updated in the same manner as the Financial Statement Summary Account Balances table. When you post to the general ledger, Costpoint accumulates data from the Transaction Posting Detail table for each unique combination of account and reference number and stores it in this table incrementally for each accounting period (for each fiscal year). Each additional posting for account/reference number combination changes the stored period total, regardless of the journal source. |
Accounts and Organizations |
Note: Although it is not specifically detailed in the process descriptions that follow, Costpoint brings forward beginning balances for both currency amounts and hours from the selected fiscal year to the next fiscal year. However, the Update General Ledger Beginning Balances report does not include hours data.
When you generate the Update General Ledger Beginning Balances report, the following occurs:
When the update process runs, the following occurs:
Note: The table row is not overwritten during this phase of the procedure.
|
Reference Numbers |
If you use reference numbers for data entry, the following additional steps take place. Costpoint the following general steps before starting the update:
When the update process runs, Costpoint either creates new beginning balance records for the new hours and amounts or updates existing beginning balance records in the Reference Summary table. This data is summarized by account and reference number and is stored in the Beg Amt and Beg Hrs fields of this table. Note: The table row is not overwritten during this phase of the procedure.
|