Activate Alternate Project Revenue Profiles

Use this screen to update project setup tables with information from the alternate project revenue profiles established on the Manage Alternate Project Revenue Profiles and/or Manage Alternate Revenue Profile Prior Year History screens.

Before you use this application, you must have entered all the necessary adjustments (changes in revenue parameters and prior year cost and revenue) on the Manage Alternate Project Revenue Profiles and Manage Alternate Revenue Profile Prior Year History screens in your production database. After you have completed these screens and created your separate alternate database from the production database, select the Alternate Revenue Calculations option on the Corporate Settings subtask of the Configure General Ledger Settings screen. You can access Activate Alternate Project Revenue Profile only in the alternate database. Once you have selected this option and run the application to activate the alternate revenue profiles, you will not be able to access and modify the alternate project revenue profiles.

This application performs the following functions:

  • It replaces selected information for existing records, deletes selected existing records, and adds new records to the following tables based on the information set up in the corresponding alternate tables populated by Manage Alternate Project Revenue Profiles and Manage Alternate Revenue Profile Prior Year History:
    • CEIL_DIR_CST
    • CEIL_DIR_HRS
    • EMPL_CEIL
    • PROJ (update of information only, no adds or deletions)
    • PROJ_EDIT (update of information only, no adds or deletions)
    • PROJ_MOD
    • PROJ_MOD_AWARD_FEE
    • PROJ_REV_SETUP
    • REV_ADJ_HIST
    • VEND_CEIL
    • PSR_PY_SUM
    • PSR_PY_BURD_SUM
  • It validates the data updated or inserted to make sure that it meets the same requirements that are contained in the Import Project Master Data application for the tables mentioned. If errors are encountered, the application prints a report that lists the errors and warnings for all records and does not activate the alternate project revenue profiles.
  • It cleans up the project ledger as needed based on the updates done on the first bullet. The cleanup involves:
  • Zeroing out any allowable amounts and/or hours units for the fiscal years specified in the Clear Allowable Amounts for group box,
  • Removing the discounted labor rates in the Rate Schedule tables if the discount method changes, and
  • Removing records from other tables that are either above the level of the revised revenue formula setup, or not equal to the revenue-formula-level PROJ_ID, depending on the table being cleaned up.