Summary
The Vendor Detail Export tool is used to generate a .CSV file that includes a filtered list of AP History details.
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).
- 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.
3 Export the file.
- Click the Submit button to export the vendor details.
- Once the export has finished processing, you can download the file from the notification link or the Jobs Viewer.