Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AC127

AC127 - Budget Import

Use AC127 (Budget Import) to import activity group budgets or activity and
account category budgets. You can define budget header and budget detail
records from interfaced non-Lawson budget records.

Using the Duplicates option, you can specify how to treat duplicate budgets:
ignore them, merge them, or replace them.

Run AC27.1 (Budget Import Adjustment) to adjust budgets you want to import
from your existing non-Lawson system to the Activity Management system.

Run AC227 (Budget Import Listing) to list the budgets defined in AC27.1
(Budget Import Adjustment) as budgets that will be imported to the LAWSON
INSIGHT Activity Management system when you run AC127 with Yes as the Update
option. Use No to report on budget import data only.

Updated Files

    ACACTGRP   - Updates the Total Budgeted field for activity within an
                 activity group.

    ACBUDDTL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years budget balances for
                 activity budgets.

    ACBUDDTLX  - This is one of the primary files maintained by this program.
                 Maintains period budget amounts for the activity budget.

    ACBUDHDR   - This is one of the primary files maintained by this program.
                 Maintains budget header information and total budget balance
                 for the activity budget.

    ACBUDREL   - References this file to validate that the budget relationship
                 exists for the old budget number on the budget you are
                 converting.

    ACCONSOL   - This is one of the primary files maintained by this program.
                 Maintains annual budget and future years' budget consolidation
                 balances for activity budgets.

    ACCONSOLX  - This is one of the primary files maintained by this program.
                 Maintains period budget consolidation balances for the activity
                 or activity group budget. Maintained by account category for
                 activity budgets.

    ACCUAMT    - This file is maintained by this program for budgets with a
                 non-base currency. Maintains annual budget and future years
                 budget balances for activity and
                 activity group budgets.

    ACCUAMTX   - This file is maintained by this program for budgets with a
                 non-base currency. Maintains period budget balances for the
                 activity or activity group budget. Maintained by account
                 category for activity budgets.

    ACSUMBUD   -

    CKPOINT    - Used for restart capability.

    RATOTALS   - This file is accessed by a common routine used by this
                 program.


    ULTOTALS   - This file is accessed by a common routine used by this
                 program.



Referenced Files

    ACACCTCAT  - References this file to validate account categories.

    ACACCTCATX - References this file to validate that the account category is
                 assigned to the activity group or activity.

    ACACTGPREL - References this file to validate that the activity group
                 relationship exists for the old activity group on the budget
                 you are converting.

    ACACTIVITY - References this file to validate that the activity
                 relationship exists for the old activity on the budget you are
                 converting.

    ACACTREL   - References this file to validate that the account category
                 relationship exists for the old account category on the budget
                 you are converting.

    ACCAL      - References this file to validate the calendar and to ensure
                 that calendar records exist for the complete date range
                 established on the budget header.

    ACCALX     - References this file to ensure that calendar records exist for
                 the full date range defined on the budget header.

    ACCOMMIT   - This file is accessed by a common routine used by this
                 program.

    ACCOMMITX  - This file is accessed by a common routine used by this
                 program.

    ACLEVEL    - This file is accessed by a common routine used by this
                 program.

    ACMASTER   - This file is accessed by a common routine used by this
                 program.

    ACMASTERX  - This file is accessed by a common routine used by this
                 program.

    ACPERCCMPL - This file is accessed by a common routine used by this
                 program.

    ACRPTGRP   -

    ACRPTGRPX  - References this file to retrieve the account categories for
                 the group.

    ACSPREADX  - References this file to retrieve spread code detail.

    ACSTATUS   - References this file to validate the activity is valid for
                 budgeting.

    CMPUTE     - References this file to validate the compute.

    CUCONV     - This file is accessed by a common routine used by this
                 program.

    CURELAT    - This file is accessed by a common routine used by this
                 program.

    FBFACTOR   - Reference this file to validate the factor code.

    GLCGCPY    - This file is accessed by a common routine used by this
                 program.

    GLCHARTDTL - This file is accessed by a common routine used by this
                 program.

    GLCHARTSUM - This file is accessed by a common routine used by this
                 program.

    GLMASTER   - This file is accessed by a common routine used by this
                 program.

    GLNAMES    - This file is accessed by a common routine used by this
                 program.

    GLSYSTEM   - This file is accessed by a common routine used by this
                 program.

    MXLISTHDR  - References this file to validate lists.

    MXLISTMBR  - References this file to determine the records in the list.

    RWGRPDET   - This file is accessed by a common routine used by this
                 program.

    RWROWDET   - This file is accessed by a common routine used by this
                 program.

    ULPOST     - This file is accessed by a common routine used by this
                 program.


INVOKED Programs

    GLBL
    IFUP
    GLRV
    IFCC