Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AC580

AC580 - Balance Rebuild

Use AC580 (Balance Rebuild) to rebuild the ACMASTER (Activity Master),
ACMASTERX (Activity Master Detail), ACCONSOL (Activity Consolidation), and
ACCONSOLX (Activity Consolidation Detail) files.

AC580 also rebuilds the ACGLMAST (AC GL Account Unit Master), ACGLMASTX (AC
GL Account Unit Master Detail), ACGLCONSL (AC GL Account Unit Consolidation),
and the ACGLCONSLX (AC GL Account Unit Consolidation Detail) files from the
Activity Transaction file. The program can also be used by multicurrency users
to rebuild the ACCUAMT (Activity Currency Amount) and ACCUAMTX (AC Currency
Amount Detail) files to maintain multicurrency transaction information.

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.

Updated Files

    ACACTGRP   - Updates the Consolidation field on this file.

    ACACTIVITY - Updates the High Post Date, Balance Amount, Balance Unit,
                 Balance Hours, Total Cost, and Total Billable fields on this
                 file.

    ACBUDDTL   - References this file to retrieve year-to-date budget amounts
                 and calculate life-to-date budget amounts in activity group
                 currency.

    ACBUDDTLX  - References this file to retrieve period-to-date budget amounts
                 in activity group currency.

    ACBUDHDR   - References this file to validate the activity budget header.

    ACCHGORDER - References this file to validate activity group and activity
                 change orders.

    ACCHGORDX  - References this file to validate activity group and activity
                 change order detail.

    ACCOMMENTS - References this file to validate activity comments.

    ACCONSOL   - Creates this file for activity group consolidation amounts in
                 the activity group currency. Creates or updates this file for
                 summary-level activity consolidation amounts in the activity
                 group currency. Maintains future years' balance and current
                 year balance for amounts and units.

    ACCONSOLX  - Creates this file for activity group consolidation amounts in
                 the activity group currency. Creates or updates this file for
                 summary-level activity consolidation amounts in the activity
                 group currency. Maintains period balances for amounts and
                 units.

    ACCUAMT    - Creates this file for posting-level activity amounts in the
                 activity (non-base) currency. Maintains the previous year's
                 balance and current year balance.

    ACCUAMTX   - Creates this file for posting-level activity amounts in the
                 activity (non-base) currency. Maintains period balances.

    ACGLCONSL  - Creates this file for activity group consolidation amounts in
                 the activity group currency. Creates or updates this file for
                 summary-level activity consolidation amounts in the activity
                 group currency. Maintains future years' balance and current
                 year balance for amounts and units.

    ACGLCONSLX - Creates this file for activity group consolidation amounts in
                 the activity group currency. Creates or updates this file for
                 summary-level activity consolidation amounts in the activity
                 group currency. Maintains period balances for amounts and
                 units.

    ACGLMAST   - Creates this file for posting-level activity amounts in the
                 activity group currency. Maintains the previous year's balance
                 and current year balance for amounts and units.

    ACGLMASTX  - Creates this file for posting-level activity amounts in the
                 activity group currency. Maintains period balances for amount
                 and units.

    ACMASTER   - Creates this file for posting-level activity amounts in the
                 activity group currency. Maintains the previous year's balance
                 and current year balance for amounts and units.

    ACMASTERX  - Creates this file for posting-level activity amounts in the
                 activity group currency. Maintains period balance for amount
                 and units.

    ACSUMBUD   -

    ACTRANS    - References this file to retrieve activity transactions to
                 build master file balances.

    CKPOINT    - Used for restart capability.


Referenced Files

    ACACCTCAT  - References this file to validate the account category.

    ACCAL      - References this file to validate the calendar.

    ACCALX     - References this file to validate period and period end dates
                 for the calendar.

    ACLEVEL    - References this file to determine if the activity is summary
                 level or posting.


INVOKED Programs

    IFCU
    IFCR
    IFSG