About rebuild programs

Three rebuild programs are provided in Project Accounting to rebuild data that is corrupt or out of balance:

  • Balance Rebuild (AC580)

  • Mass Report Currency Change (AC581)

  • Activity Transaction Rebuild (AC583)

    Note: Running rebuild programs is not part of a normal processing cycle. If you are running these programs for the first time, contact Infor Global Support for guidance in effectively rebuilding your data. Also, if you are having continuing issues with balances in Project Accounting, seek help from the Infor Global Support to identify the root cause of the issue that is causing incorrect balances.

Balance Rebuild (AC580)

Use Balance Rebuild (AC580) to rebuild these files:

  • Activity Master Balances ACMASTER (UNIX/Windows) or DBACMST (IBMi)

  • Activity Consolidation ACCONSOL (UNIX/Windows) or DBACCSL (IBMi)

This program also rebuilds these files:

  • AC GL Account Unit Master ACGLMAST (UNIX/Windows) or DBACGMT (IBMi)

  • AC GL Account Unit Consolidation ACGLCONSL (UNIX/Windows) or DBACGCO (IBMi)

Note: As an option, you can flag AC580 to rebuild consolidation balances only. With this option, master balances are retained.

The program can also be used by multi-currency users to rebuild the Activity Currency Amount ACCUAMT (UNIX/Windows) or DBACACU (IBM i) files to maintain multi-currency transaction information.

Balance Rebuild (AC580) checks the budget and change order files and removes orphan records. Budget detail records that do not have associated budget headers and change orders that are not associated with an existing budget are removed.

Balance Rebuild (AC580) allows rebuilding of beginning balance records from Beginning Balance Update (AC196) by indicating whether or not beginning balances will be calculated and updated in the balance files during the rebuild process. Also, Beginning Balance Update (AC196) can rebuild beginning balance records that were previously removed.

Mass Report Currency Change (AC581)

Use Mass Report Currency Change (AC581) to add report currencies to existing activity groups that have transactions or budgets. You can also use it to change or delete existing report currencies. This program can calculate actual and budget currency values for all transactions for the activity group using the currency rates and currency relationships you define in the Currency application.

Prior to running AC581, you can use Budget Exchange Rates (AC81.1) to enter exchange rates for budgets for which report currencies will be added or changed. Running AC581 automatically invokes the Balance Rebuild (AC580) program to rebuild balances.

Note:  Mass Report Currency Change (AC581) is only for clients who use the report currency functionality.

Activity Transaction Rebuild (AC583)

Use Activity Transaction Rebuild (AC583) to rebuild the following files when you move a detail account category from one summary account category to another using Move Detail Account Category (AC08.7), or if you make any changes to the calendar assigned to the activity:

  • ACTRANS (UNIX/Windows) or DBACATN (IBMi)

  • ACCOMITX (UNIX/Windows) or DBACMIX (IBMi)

  • ACCOMMIT (UNIX/WIdows) or DBACMIT (IBMi)