Prerequisites

Perform activities to set up ADB for the detail ledger that will be used to maintain the standard balances and daily balances when calculating the averages.

Before you can use the ADB feature, you must set up your business units and ledgers for ADB processing:

Setup What

Business Units using the General Ledger Definition - Definition Page

Set up the business units for which you want to calculate average daily balances.

Select the ADB Incremental Calculation Method link on the General Ledger Business Unit Definition page, and select the definitions that you run regularly (using the incremental calculation method) for this business unit.

Detail Ledgers using the Application Fundamentals: Detail Ledger Page

Set up these ADB detail ledgers:

  • LOCALMTD

  • LOCALQTD

  • LOCALYTD

Ledger groups using the Application Fundamentals: Ledger Groups - Definition Page

Set up these ADB ledger groups:

  • LOCALMTD

  • LOCALQTD

  • LOCALYTD

Associate the ledger group with one of the ADB templates.

ADB templates using the Application Fundamentals: Templates - Record Definitions Page

Select each of these PeopleSoft ADB target ledger templates:

  • STNDADBMTD

  • STNDADBQTD

  • STNDADBYTD

  • Verify that the ADB records as set up.

  • Add the applicable ADB detail ledger to each of the templates to store the average balances.

The ADB process determines where to store the calculated averages using the table defined in Record (Table) Name field on this template. Create a unique template for each unique table name depending on where you want to store the averages. For example, if you want to store all the averages to one table, you need only one template. To set up the template, select ADB Reporting Ledger in the Default Ledger Type field and click the button to select the default table names. You can accept the default table or choose another ADB target ledger table.

Using Application Fundamentals: Ledgers For A Unit - Definition Page

  • Select Report Average Balances, and select an ADB calendar for the ACTUALS (RECORDING) detail ledger.

  • Indicate whether you want to maintain regulatory balances.

  • Select the Filter Posted Activity check box.

  • Click the Filter link to access the Include Account Types Posted to ADB Ledger page, and select the ADB account types. You can add more than one account type and click OK.

    Note: Filters enable you to specify which account types you want to post to the ADB ledger, for example, asset and liability.

Using Application Fundamentals: Ledgers For A Unit - Definition Page

Add the ADB ledger group to the business unit. This is where the ADB calculation process looks to determine what ledger group and ledger to use when calculating the averages.

  • Attach the ADB ledger groups that you created to the business unit.

    This is where the ADB calculation process looks to determine what ledger group and ledger to use when calculating the averages.

  • Select a detail calendar in the Calendar ID field.

    The calendar can be a daily or monthly calendar. For example:

    • LOCALMTD calendar could be monthly (D1).

    • LOCALTD Calendar could be daily (D2).

The calendar that you select determines how the average balances are stored. If you select a monthly calendar, for example, the current period reflects today's averages (or the day ADB was processed in the current month) and the prior period reflects the month-end average balances.

Note: Do not select Report Average Balances or any other ADB-related fields for these ADB target detail ledgers that you attach to a business unit in the Ledgers For a Unit component.

Post Adjustment Periods to ADB option using the Application Fundamentals: Ledgers For A Unit - Journal Post Options Page

Disable (or leave enabled) the Post Adjustment Periods to ADB option.

Select whether to post adjustment journal entries to the ADB ledgers using an adjustment period (as defined for the ledger group) or using a regular accounting period that is derived from the ADB calendar.