CONFIGURE THE AP/AR AGING TABLES into OBIA

This section explains how to control the lengths of the aging buckets in the AP and AR aging snapshot tables. These tables are:

• W_AP_AGING_INVOICE_A
• W_AR_AGING_INVOICE_A
• W_AP_AGING_SUPPLIER_A
• W_AR_AGING_CUSTOMER_A

In these four tables, outstanding AP/AR balance information is broken out into rows. Each row represents the outstanding balance information for a particular aging bucket. Four aging buckets are provided out-of-the-box, with the following durations:

• Bucket 1: 0 – 30 days
• Bucket 2: 31 – 60 days
• Bucket 3: 61 – 90 days
• Bucket 4: 90+ days

Use the DAC to configure the lengths of these aging buckets, as described below.

To configure the length of aging buckets

1. Click on the ‘Tasks’ tab.
2. Query for the following tasks
   • PLP_APSnapshotInvoiceAging
   • PLP_ARSnapshotInvoiceAging
3. For each of these tasks, click on the ‘Parameters’ tab and update the parameters with names starting with ‘$$BUCKET’.

Save your work.