Configure the AP/AR Aging Tables

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 by default, with the following durations:

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

Use DAC to configure the lengths of these aging buckets, as described in the following procedure.
To configure the length of aging buckets:

1. In the Design view, display the Tasks tab.
   
2. Query for the following tasks:
   
   • PLP_APSnapshotInvoiceAging
     
   • PLP_ARSnapshotInvoiceAging
     
3. For each of these tasks, display the Parameters tab in the lower pane and update the parameters with names starting with '$$BUCKET'.
   You can also use the $$HISTORY_MONTHS parameter to specify how many historic month end snapshots you want to retain (the default value is 24 months).
   Note: You cannot create aging snapshots for months prior to your initial load ETL. Aging snapshots are created one month at a time, as you go forward with your regular ETL runs. For example, if you start your system in January 2009 (that is, run the initial ETL some time in January 2009), and you set $$HISTORY_MONTHS to 12, you will have one snapshot at the end of January 2009, two at the end of February 2009, three at the end of March 2009 and so on until the end of December 2009 when you will have 12 snapshots.
   
4. Save your changes.