MISCELLANEOUS TOOLKITS

Use this screen to execute various toolkit programs. You should restrict user access to this screen since these toolkits involve information from your database.

Assign Account Function Codes

Use the Assign Account Function Codes toolkit to assign account function codes to all accounts in the Project Ledger and in the Prior Years Project Ledger.

Check Pool Acct/Org Setups

Use the Check Pool Acct/Org Setups toolkit to help detect improper or questionable pool setups.

Update Contract and Funded Values

Use the Update Contract and Funded Values toolkit to update contract and funding values at each project level in the Project Master.

Update Period of Performance

Use the Update Period of Performance toolkit to update period of performance dates at each project level in the Project Master.

Compare Project Ledger to General Ledger

Use the Compare Project Ledger to General Ledger toolkit to insert rows into the errors table (Z_PJPTOOL_ERRORS) to reflect cost differences between the General Ledger and the Project Ledger.

Update Prior Years Units Columns

Use the Update Prior Years Units Columns toolkit to populate the Units columns in the Prior Years Project Ledger.

Set Up Validations Using POA

Use the Set Up Validations Using POA toolkit to select the Allow Charging check box in the Maintain Project Master screen (Projects » Project Setup » Project Master) for each project selected that has distinct rows in the project organization account table and to update the charging check boxes on this toolkit, if they are selected.

Display Invalid Pools in Project Ledger

Use the Display Invalid Pools in Project Ledger toolkit to insert rows into the errors table (Z_PJPTOOL_ERRORS) to reflect account/organization/pool combinations that are no longer valid.

Fix Invalid Pools in Project Ledger

Use the Fix Invalid Pools in Project Ledger toolkit to insert rows into Z_PJPTOOL_ERRORS to reflect account/organization/pool combinations that are no longer valid, and insert rows into the project ledger to back out the associated burden.

Synchronize Project Master and Project Edit Tables

Use the Synchronize Project Master and Project Edit Tables toolkit to compare and synchronize the PROJ and PROJ_EDIT tables.

Check and/or Rebuild Project Segment IDs

Use the Check and/or Rebuild Project Segment IDs toolkit to check the project levels against the actual project ID lengths and to rebuild the line project segment IDs in the project table from level 2 through each projects remaining levels.

Copy Pools

Use the Copy Pools toolkit to copy existing pools for a new fiscal year.

Fix Vendor Employee ID in Labor History

Use the Fix Vendor Employee ID in Labor History toolkit to fix the vendor employee ID in the Labor History table.

Set Level Correctly in Project Master

Use the Set Level Correctly in Project Master toolkit to set the level number correctly in the Project Master table.

Check for Unposted Journals

Use the Check for Unposted Journals toolkit to check for unposted journals for a given subperiod.

Change Period Report Parameters

Use the Change Period Report Parameters toolkit to update report parameters for eight project reports.

Delete Duplicate Project/Account Combinations of

Use the Delete Duplicate Project/Account Combinations toolkit to delete any duplicate project/account combinations.

Update POA table with valid Links/Reference Numbers

Use the Update POA table with valid Links/Reference Numbers toolkit to update the project/organization/account validation table with valid links and reference numbers.

Activate/Inactivate Project

Use the Activate/Inactivate Project toolkit to activate or inactivate a range of projects.

Group Duplicates in Labor History

Use the Group Duplicates in Labor History toolkit to combine duplicate rows in the Labor History table.

Compute Account Org Burden Rates

Use the Compute Account Org Burden Rates toolkit to build burdens by account and organization for a specific fiscal year.  

Select

Click this button to activate the highlighted toolkit.