AP> Utilities> Vendor/Activity Export

Export Vendor/Activity Data

 

Summary

 

The Vendor/Activity Export window is used to generate an export file that includes either vendor master account information or cash disbursement activity information. These export files are designed to help organizations meet state auditing requirements.

 

Step by Step

 

1     Open the Vendor/Activity Export window (AP> Utilities> Vendor/Activity).

 

2     Configure and generate the export file.

 

  • Select the Export Type for the export file you would like to generate.
    • Select Cash Disbursement to generate an export file that includes all disbursement activities for all funds during the specified date range. This file will include vendor, invoice, check and purchase order data.
      • This will enable the Check Date From and Check Date To fields below. Specify a data range for the cash disbursement activity you would like to include in the export file.
    • Select Vendor Master to generate an export file that includes vendor master account information. This file will include details such as vendor name, address and TIN number.
      • Selecting Vendor Master will disable the date range fields below.
  • Click the Display icon to display the expected .csv file layout.
  • Click the Confirm icon to generate the export file.
  • Once the export has finished processing, the Export Settings window will open. This window is used to specify the export path for the Vendor/Activity file.
    • Check the Open toggle if you would like to open the exported file after it is saved locally.
    • Enter the export path location and click the Save icon to export the file to the local path.