Overview
Use this job aid to print the Accounts Payable Report. The report is sorted by name id number and voucher number. Sub-totals are by name id only. Discount and net amount due are calculated for payment on or before the current operating date. The report is limited to transaction status U (unpaid). Disbursement detail is included. The report prints name id number, voucher (document) location, voucher (document) number, Voucher date, voucher description, voucher amount, amount applied, amount remaining, discount date, discount amount, net amount due, payment date, cash source, bank code, check number, applied amount.
To print the accounts payable report:
- From the Toolbar, click ACP for Accounts Payable.
- From the Accounts Payable menu, select Report Manager, and then select A/P Voucher Reports.
- Select Print A/P Voucher Reports.
- Select Accounts Payable Report.
- In any of the Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the range, or type the range you want to print the accounts payable report for. Or click the calendar icon and select a date range.
- Click OK.
- In any of the Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the range, or type the range you want to print the accounts payable report for.
- 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 Box, Name Id Number and Voucher number, type a subtotal option.
- In the Legend Line, 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 Voucher Detail? box, type Y to include voucher 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 indicate 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 Disbursement Detail? box, type Y to print the disbursement detail, or type N to omit the detail.
- In the Print GL Distribution Detail? box, type Y to include the general ledger distribution detail (accounts/amounts, etc.), or type N to omit the general ledger detail.
- In the Print Voucher Line Item Detail? box, type Y to include the voucher line item detail on the report, or type N to omit the voucher line item detail.
- In the Print Voucher Remarks? box, type Y to include remarks or type N to omit the detail.
- Click OK.
- In the Discount Calculation Date box, click the calendar icon, and select a date or type a date that the discount should be calculated for. If you do not want to calculate a discount, leave this box blank.
- Click OK.
- In the Beginning Cash Forecast Date box, click the calendar icon , and select a date or type a date that the cash forecast should be calculated for. If you do not want to calculate a cash forecast, leave this box blank.
- In the Days to Increment Categories boxes, type the number of days you want to increment your aging categories.
- 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 about the Voucher Reports feature:
- Accounts Payable Report
- Voucher Register
- Daily Voucher Report
- Cash Requirements Report
- A/P - G/L Distribution Report
- Voucher Export File (AGEXPIMP)
- Company Owned Unpaid Commodity Voucher Report