Accounts Payable Activity Report
Accounts Payable Menu -> A/P
Reports -> Accounts Payable Activity Report
This report lists A/P Invoice and payment activity, with the
dates and balances for a selected range of Vendors for the
specified time period.
The Summary either by Vendor or by Division returns the number or
invoices, the sum of those invoices, the sum of payments including
discounts, and the outstanding balance totals.
The Detailed output to PDF is by Vendor and lists vendor number and
name with the invoices, dates and amount information.
The Detailed output to spreadsheet also includes the PO#, product
numbers, G/L Inventory Account number and description.
The prompts are:
-
- DIVISION, "ALL" OR "SEL"
-
- Type ALL to include all divisions in the report.
- To print the report for a single division, leave this field
blank for the Head Office Division, or enter a specific division
code, or select a division from the drop-down list.
- Type SEL to select several specific divisions or divisions by
accounting region to include in the report, as outlined in Division Select By Region.
STARTING VENDOR NAME
- Leave this field blank for all vendors, or type in the
beginning vendor name, or select a starting Vendor from the
Vendor Search window.
- ENDING VENDOR NAME
- Leave this field blank for all vendors, or type in the ending
name, or select an ending Vendor from the window.
STARTING VENDOR #
- Leave this field blank for all vendors, or enter the Vendor
#, or enter the first few characters of the vendor name (ALPHA
KEY) to list matches in the search/selection pop-up, or search for
the starting vendor in the Vendor Search
window.
- ENDING VENDOR #
- Leave this field blank for all vendors, or enter the Vendor
#, or enter the first few characters of the vendor name (ALPHA
KEY) to list matches in the search/selection pop-up, or search for
the ending vendor in the window.
FROM DATE
- Accept the current month start or type in the desired starting
date.
- TO DATE
- Accept the current month end date or type in the desired ending
date.
REPORT TYPE
- Select one of the following reporting options:
- Click Detail to generate a list of invoices and check
payments by Vendor, in the selection range, with date and amount
detail information.
- Click Division Summary to list the total number of
invoices for each division Division in this selection range, with
division totals for Invoice Amount, amount Paid or Discounted, and
the total unpaid Balance.
- Click Vendor Summary to list the total number of
invoices for each Vendor in selection range, with vendor totals for
Invoice Amount, amount Paid or Discounted, and the total unpaid
Balance.
PRINT PRODUCTS
- This selection option is only available when the Detail
activity is being output to an Excel spreadsheet.
Check this box to list each product for each AP Invoice on the
spreadsheet with the product's P.O.# and G/L Inventory Account
information.
Uncheck this box if product details are not required.
REPORT OPTIONS
- This value defaults to the operator preference as defined in
Operators.
Select one of the output options to Print a report or export
the data to Excel as outlined in Report Options.
Finished?
- Click ACCEPT to generate the report, or CANCEL to abort.
Topic Keyword: APAP15