Show AP Aging Columns in the Disbursement window

A new feature for AcctVantage 2013.0.0.3 is the ability to have AP Aging Columns displayed in the AP Disbursement window. These will be the same columns you are used to seeing in the AP Aging window.

  • If you have made any changes to the Standard AP Disbursement View Definition, you'll want to follow the instructions for Steps 1-6 (below) to add the AP Aging Columns. This is necessary so you don't overwrite any custom changes you've made to the View Definition. Skip to the Alternate Instructions @ Step 1 for more information.
  • If you are using the Standard AP Disbursement View Definition, you can download and install the new Standard AP Disbursement View Definition, which will update the window to include these columns.

For more on the View Editor see this article.

Download and install the new Standard View Definition for the AP Disbursement window.

If you are using the Standard AcctVantage View Definition for the AP Disbursement window (in other words, if you have not made any changes to this window via the View Editor) then you can download and install the NEW Standard AP Disbursement View Definition and save yourself some time. Here's how:

  1. Download the AP Disbursement View Definition with AP Aging columns here.
  2. Unzip the ZIP file.
  3. Open up the folder where your AV Client application is.
    • Mac: Applications/AcctVantage Client/INSTALL
    • Windows: C:\AcctVantage Client\INSTALL (or C:\Program Files\AcctVantage Client\INSTALL)
  4. Within the AcctVantage Client folder you will see a folder titled INSTALL. Drop the View Definition into the INSTALL folder and restart your AV Client app -- the View Definition will be automatically loaded.
    • see Step 6 for a screenshot of what the window will look like.

1. (Alternate instructions) Open the View Editor

Navigate to Administration ➤ View Editor.

(Alternate instructions) Open the View Editor

2. Open the View Definition for the Disbursement window

  1. In the Views list in the upper left-hand corner of the View Editor, scroll down until you see the item APDocument.
  2. Click the triangle to the left of APDocument.
  3. Select the View Definition for Default, AP Disburse.
  4. To add an Aging Column, click the Insert Calc Column button.
    • For each column, you will be prompted to Enter the name of the callback method (Step 3).
    • You will also need to enter titles for these new columns (Step 4).
    • See the following table for these callback methods and titles (Step 2.1).
Open the View Definition for the Disbursement window

2.1. Callback Methods & Column Titles

Note: The time periods for each Aging Column are defined in Administration ➤ System Setup ➤ A/R & A/P. The number of days for each Aging Period will be the Column Title when using this table.

Column Description Column Callback Method Column Title
Current AP items Aging_ColCurrentCalcALP_cb Current
Aging Period 1 Aging_Col1CalcALP_cb !Aging_Column1Title_ALPT
Aging Period 2 Aging_Col2CalcALP_cb !Aging_Column2Title_ALPT
Aging Period 3 Aging_Col3CalcALP_cb !Aging_Column3Title_ALPT

3. Enter the name of the callback method.

After you click Insert Calc Column, you will be prompted to enter the name of the callback method. This must be entered exactly as it appears in the above table. Click OK to save the column.

Enter the name of the callback method.

4. Enter the Column Title.

After you enter the callback method for a column, you will need to enter the Column Title. This must be entered exactly as it appears in the above table. Press the tab key to save the Column Title.

Referencing the table in Step 2.1, repeat Step 3 and Step 4 for each of the AP Aging Columns.

Enter the Column Title.

5. The AP Aging columns have been added to the View Definition

The View Definition for the Disbursement window should look similar to this when you are finished.

Click Done in the View Editor when you are finished adding the AP Aging columns.

The AP Aging columns have been added to the View Definition

6. The Disbursement window with Aging Columns