AP> Reports> Vendor Detail Export
Vendor Detail Export
Summary
The Vendor Detail Export tool is used to generate a .CSV file that includes a filtered list of AP History details.
Related Links
Click here to view information on the Jobs Viewer window.
Step by Step
1 Open the Vendor Detail Export window (AP> Reports> Vendor Detail Export).
2 Complete the export filters.
- The Configuration field is used to select the export configuration that you would like to use. This field will default to the standard configuration, but you can select any custom export configuration set up for the Vendor Detail Export tool.
- Export configurations are created an maintained on the Export Configuration Maintenance window (SS> Maintenance> Export Configuration). Click here for information on Configurable Export Maintenance.
- The Data From field is used to specify what data will be included.
- If Fiscal Year is selected, the report will include data that matches the Fiscal Year and Minimum Amount selected below.
- If Computer Checks Batch is selected, the report will include data that matches the Computer Checks Batch selected below.
- Select the Fiscal Year you would like to report on.
- Enter a Minimum Amount to limit the export data to only those vendor transactions that exceed a specified minimum amount.
- The Computer Checks Batch field is used to generate the report for a single computer checks batch. Enter the batch number of use the field search button to select a batch from a list.
- The export will display vendor details for Fund, Department, Fiscal Year, Fiscal Period, Amount, Transaction Date, Check Number, Check Date, and Vendor Name. The export file will be grouped by Fund and then Vendor Number.