Vendor Purchases Report

Accounts Payable Menu -> A/P Reports -> Vendor Purchases Report

The summarized purchases report prints the vendor number and name, with the current account balance, and the purchases total for the time period selected.
 The detailed report also includes a total purchases for each month in the range.

•The Account Balance reflects a running balance for posted and unposted invoices for the vendor regardless of the date, and only payments that are posted reduce this balance on the report.
 (Unposted payments are not reflected in this report, even though they are reflected in the Vendor Account Inquiry and may be reflected in the Account Balance in the Vendor Information or else they will show as an 'out of sync' condition in Vendor Information until they are posted.)

•The Purchases totals on this report only reflect monthly posted invoices.
 (However the Monthly & YTD Purchases that can be viewed in the Purchases LTD window in the Vendor Information include both posted and unposted invoices.)
 The purchases totals are not affected by any payments against the invoices and do not include amounts posted to a vendor's account from Post Miscellaneous Journals.

The prompts are:

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.

STARTING DATE

Accept the fiscal year start or type in the desired start date in the YYYYMM format.

ENDING DATE

Accept the current period end or type in the desired ending date in the YYYYMM format.

REPORT TYPE

Select one of the following reporting options:

•Click Summary to list the Vendors with their current Account Balance, and a Purchases total in the period.

•Click Detail to list the summary information for each Vendor as well as a Purchases total breakdown by month.
 This information is also accessible from Vendor Information in the window on the LTD Purchases field, however the Vendor Information purchases includes some unposted values.

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: APVF50