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.