Changing LABOR to NON-LABOR or Vice Versa

Make the modification in the Account Group and execute the Assign Account Function Codes toolkit for the Account Group(s) that were modified. This toolkit reviews the current Account Group setup and synchronizes the ACCT_FUNC_NOs in the PROJ_SUM and PSR_PY_SUM tables per that setup. Depending on the size of your database, this toolkit may take considerable time to complete. Keep in mind that if you want these modifications reflected on prior period reports, you must execute the appropriate report table update for those periods. Also, changing an account to a LABOR function code may not make the account appear on labor reports if the transactions have not been entered through a labor entry function (for example, Manage Timesheets, or the Employee Labor and Vendor Labor subtasks of the Manage System Assigned JE Number screen) or the Manage Accounts Payable Vouchers screen.

Modifying the REVENUE Function Code

Make the modification in the Account Group. Enter a journal entry transferring the Year-to-Date (YTD) revenue from the original project/account/org combination to the new combination. When you post revenue the first time after the modification, Costpoint looks at GL_POST_SUM to sum the amount that has been posted YTD and to determine the amount of the current posting.

Modifying the BILLED A/R Function Code

Make the modification to the Account Group and enter a journal entry to transfer the outstanding amount from the original billed receivable account to the new account. This journal entry is needed only if you want to keep the balance in one account. Keep in mind that the detail supporting the balance transfer still resides in the original account.

Modifying the UNBILLED-GENERL

Make the modification to the Account Group and enter a journal entry to transfer the YTD balance from the original unbilled-general account to the new account. The Unbilled Analysis Report derives the Unbilled Per G/L amount from GL_POST_SUM for the account that is currently designated with the UNBILLED-GENERL for a given project. By moving the YTD balance to the new account, you ensure that all transactions for the current year are included.

Modifying the COST GOODS SOLD or WIP TRANS OUT

If you are changing the Cost of Goods Sold account, you need to make the modification only in the Account Group and enter an optional journal entry to keep the YTD balance in one account. If you are changing the WIP Transfer Out account, you must make the modification in the Account Group, and you must enter the journal entry. The Create Cost of Goods Sold Entry screen sums GL_POST_SUM for the YTD balance of the account with the WIP TRANS OUT function code to determine the amount of the current posting. The journal entry transferring the YTD balance ensures that the current posted amount is correct.

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).