ACCOUNT GROUP MODIFICATIONS

We recommend that you view your initial Project Account Groups setup as permanent, and make modifications only when absolutely necessary. Please contact Costpoint General Support before making any modifications to your Account Groups.

Generally, you can make modifications to your Account Groups without any problems if you have not posted any transactions or executed any processes. This means you can make modifications during initialization if you have a "false start." Keep in mind that adding or deleting accounts to your Project Selected Accounts may mean additional modifications to your transaction validation screens (such as Link Projects/Accounts/Organizations).

If you have posted transactions and executed processes, most modifications require additional steps. Many of the function codes reside in the project summary ledgers (PROJ_SUM and PSR_PY_SUM) and are identified with an account function number (ACCT_FUNC_NO) to help categorize them. Furthermore, as the revenue process proceeds, additional tables are affected by the account function codes. For example, when you execute the Update Project Status Report Tables screen, it updates a table called PSR_FINAL_DATA. The account function codes are transferred from PROJ_SUM and are known in PSR_FINAL_DATA as the SUB_TOT_TYPE_NO, which groups the types of transactions for presentation on the report. In addition, many posting programs rely on a unique project/account/org combination in the General Ledger (GL_POST_SUM) to determine the amount required for the current posting. Changing the account in the Account Group, in effect, creates a new transaction combination that affects the amount posted. In summary, changing the Project Account Groups can have a wide-ranging affect on Costpoint. Although some information on changing Project Account Groups is provided below, contact Costpoint General Support before making modifications to your Project Account Groups.

The following are some examples of how to handle Account Group modifications:

Changing LABOR to NON-LABOR or Vice Versa

Modifying the REVENUE Function Code

Modifying the BILLED A/R Function Code

Modifying the UNBILLED-GENERL

Modifying the COST GOODS SOLD or WIP TRANS OUT

Account Function Numbers

Account Function Numbers are assigned to the accounts that are written to the Project Ledger tables (PROJ_SUM and PSR_PY_SUM). These numbers, which can be found in the ACCT_FUNC_NO columns of both tables, categorize the accounts for processes and direct them to their location on reports. One of these reports is the Project Status Report, which stores some of its information in the PSR_FINAL_DATA table. In this table, the numbers are assigned to the accounts in the SUB_TOT_TYPE_NO column.

The following table lists the ACCT_FUNC_NOS and SUB_TOT_TYPE_NOS in the PROJ_SUM and PSR_FINAL_DATA tables, respectively. Note that different numbers can exist for the same account type if the project is classified as Work-In-Process (WIP).

PROJ_SUM Table vs PSR_FINAL_DATA Table

(ACCT_FUNC_NO Column vs SUB_TOT_TYPE_NO column)