A/P Aging Analysis By Location Code

Overview

Use this job aid to print the Accounts Payable Aging Analysis by Location Code report. The report is sorted by name id and location code. Subtotals are printed by location code. The method of aging established in Setup Information determines the titles for the age categories. The report prints name id number, location code, name id description, prepaid balance, payments on hold, current balance, age category 1 balance, age category 2 balance, Age category 3+4+5+6, and account balance.

To print the accounts payable aging analysis by location code:

From the Toolbar, click ACP for Accounts Payable.
From the Accounts Payable menu, select Report Manager, and then select A/P Balance Reports.
Select Print A/P Balance Report.
Select A/P Aging Analysis - By Location Code.
In the Name Id Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the name id, or type the name Id you want to print the balance due report for.
In the Location Code Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the location code, or type the location code you want to print the balance due report for.
In the Name Id Description Beginning and Ending boxes, type the name Id description you want to print the balance due report for.
In the Reserved box type * and press Enter, select a value selection criteria.
Click OK.
In any of the Opt boxes, type an Option Code (0 = all values; 1 = equal to; 2 = not equal to; 3 = greater than; 4 = greater than or equal to; 5 = less than; 6 = less than or equal to) and then type an amount that the Option Code will qualify with.
Click OK.
In the Subtotal Option, Name Id Number and Location Code Box, type a subtotal option.
In the Legend Box, type a comment that will print at the top of the report. For example, the intended recipients name to help with distribution of the report.
In the Print A/P Balance Detail? box, type Y to include individual detail lines, or type N to summarize numeric values at the subtotal level only.
In the Print Grand Total Information? box, type Y to accumulate numeric values for grand totals and indicates the total number of records included in the report, or type N to print without accumulating grand total information.
In the Replace Name Id Number with Alternate Name Id#? box, type Y to print the report with Alternate Name Ids instead of the Actual Name Id, or type N to print the report with the actual name id.
Click OK.
In the Print Voucher/Disbursement Detail? box, type Y to print the voucher or disbursement detail, or type N to omit the detail.
In the Print Accounts With Zero Balance? box, type Y to include the accounts with zero balances, or type N to omit the accounts with a zero balance. Accounts with zero balance due are included if they contain unapplied disbursements or prepayments.
In the Calculate G/L Reconciliation Balance? box, type Y to specify the date to calculate balances and to determine the open A/P balance for reconciliation to the balances in the general ledger for a specific historical date, or type N to skip the calculation.
In the Amount Due Calculation Date box, type the date that you want to calculate the amount due for.
Click OK.
If you chose Y in Step 20, perform Step 24 and 25. If you chose N, continue with step 26. In the Calculate Date As Of? box, type the date you want to calculate the ledger reconciliation balance for.
In any of the beginning and ending boxes, type a range to calculate the ledger reconciliation balance with.
Click OK.
In the Printer box, type the number associated to the place you want your report to print to.
In the Print Type box, type the number associated to the characters per inch to print the report in. The default for this box is 1.
In the Copies box, type the number of copies of the report you want to print. The default for this box is 1.
In the Pages From and To boxes, type the page number range you want to print the report for. Leave the boxes blank to print all pages.
Click OK.

Learn more about the Balance Reports feature: