Vendor Listing Report

Top  Previous  Next

The Vendor Listing Report [apvenp] generates a listing of all vendors in your database.

 

 

Open:

 

To access the Vendor Listing Report [apvenp], click the 'A/P' module, then 'Vendor' sub-folder from the menu tree (see following screen shot).

 

The Vendor Listing Report [apvenp] is also located in the 'Report' folder under the 'A/P', 'Setup & Maintenance' and 'Vendors' sub-folders.

 

You can also access this report by typing the screen or acronym name in the blue prompt bar located above the 'Setup' menu.  Then, press Enter.

 

 

 

The screen then appears.

 

 

 

To select criteria, press the F2 Key or right click in most fields to make your selection.  You can also simply type in the criteria in the allotted fields. If you wish to include all criteria information, leave all fields blank except for any white colored fields as white fields are required before proceeding in PSL3.

 

 

Vendor Information:

 

Starting and Ending Vendor Numbers - Vendors to include in the report.  To restrict the report to only include information for a single vendor, input the same Vendor Number in both the Starting and Ending fields. To select all vendors, leave both fields blank.

 

 

Report Format:

 

Order By - The report can be ordered by Vendor Number (entries are sorted in ascending order, by number first, then alphabetically), Name or Tax ID.
Include - You can include vendors that are Active or Inactive (or both), select whether they have a W9 on file or not (or both) and specify only A/P Vendors or P/C Vendors (or both).
Type - Select whether you want to view a Detailed, Summary or Vendor Spend Report.

 

 

Vendor Spend Parameters / Period:

 

Period - System-assigned Period Number that indicates the Accounting Period in which these costs were entered.  If you chose to run the report by Period Number, then the Start Date and End Date fields default for the period chosen.

 

Start and End Dates - Transaction Effective Dates to include in the report as PSL3 is date-driven. To restrict the report to only include information for a single date, input the same date in both the Start Date and End Date fields. To select all dates from inception to future, leave both fields blank.  Press the F2 Key or right click in either date field for the calendar selection to appear.

 

 

 

 

Vendor Spend Parameters / Multiple Currency:

 

Source Currency - If you have more than one currency in your database, you can choose to include only transactions denominated in one currency, two, three, etc., or all currencies.  To choose multiple Currency Codes, press the F2 Key or right click in the field and hold down the Control Key while simultaneously using your mouse to select.  Each currency in your database and its conversion rate are listed in the report heading.
Target Currency - Base currency set up in the System Control Information Entry [suctrl] screen located in the 'Setup' module defaults.  This Currency Code is what all transactions are converted to on the report.  Each currency in your database and its conversion rate are listed in the report heading.

 

 

Print/Preview the Report: Located in the top right hand corner of the screen, you can choose the following options to generate the report:

 

Print - Opens the Print Dialogue box and sends the report directly to the printer.

 

Preview - Generates a PDF format report and appears instantly on your screen.  You are still able to print from the PDF format.

 

Spreadsheet - Generates an Excel format report and appears instantly on your screen.  You are still able to print from the Excel format.  Please note if you select this option, you are able to have additional sorting options within Excel.