Interfacing Project Accounting budgets into General Ledger

Use this procedure to interface budget information from Project Accounting into a General Ledger budget. This will allow you 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.

Follow these steps to interface Project Accounting budgets into General Ledger:

  1. Access AC to GL Budget Interface (AC527).
  2. Use the following guidelines to enter fields on the Activity tab.
    Activity Group List, Activity Group, Activities, or Activity List

    Select the activity group list, activity group, activities, or activity list for which you want to interface budget information.

    Account Cat or Account Cat Group

    Select the range of account categories or the account category group for which you want to interface budgets.

    Update

    Select whether or not to interface budget information. Select Yes to interface budget information. Select No to create a report without interfacing budget information.

  3. Use these guidelines to specify the field values on the Budget Options tab:
    Run Group

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

    From AC Budget Year

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

    From AC Budget

    Select budget from which you want to interface information.

    To GL Budget

    Select the General Ledger budget that you want the program 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 will result 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.