Interfacing Project Accounting budgets into General Ledger

You can interface budget information from Project Accounting into a General Ledger budget to leverage the General Ledger budget edit and commitment tracking capabilities.

You cannot interface Activity group type budgets and life only budgets into General Ledger using this program.

  1. Access AC to GL Budget Interface (AC527).
  2. On the Activity tab, specify this information.
    Activity Group List, Activity Group, Activities, or Activity List

    Select the activity group list, activity group, activities, or activity list to interface budget information.

    Account Cat or Account Cat Group

    Select the range of account categories or the account category group to interface budgets.

    Update

    Select whether to interface budget information. Select Yes to interface budget information. Otherwise, select No to create a report without interfacing budget information.

  3. On the Budget Options tab, specify this information:
    Run Group

    Specify or select a Run Group to use for this interface budget information.

    From AC Budget Year

    Select the year to interface budget data. If left blank, then all years are copied.

    From AC Budget

    Select budget to interface information.

    To GL Budget

    Select the General Ledger budget to update.

    Activity Mapping Option

    Select the appropriate option to determine how budget information is mapped between Project Accounting and General Ledger.

    • Activity Default (A) = The default company and account unit is used.

    • Organization Code (O) = The related company and accounting unit combination is used.

    GL Budget Year Adjustment

    Specify the number of years by which the budget year is adjusted in General Ledger. You can specify a positive or negative number.

    For example, if Project Accounting budget year is 2005 and you enter -1 in this field, then the General Ledger budget is created for 2004.

    AC Period = GL Period

    Use these fields in conjunction with the GL Budget Year Adjustment field to accommodate any calendar differences that may exist between Project Accounting and General Ledger.

    If period 1 of the Project Accounting budget is mapped to a General Ledger budget period greater than 1, then a single budget year in Project Accounting results in two budget years created in General Ledger.

    Note: You must map a General Ledger period to Project Accounting period 1.

    Mapped Project Accounting periods must be sequential.

    You cannot map a General Ledger period to more than one Project Accounting period.

  4. Submit the job to interface budget information into General Ledger.