What This Report Shows

  • This report creates a tab-delimited file (using the vendor fiscal year masters). The file will be named VENFYR plus the selected fiscal year and with a tsv extension. Vendors can be sorted by vendor identification or vendor name. The file will contain the following data fields:
    • Fiscal Year
    • Vendor ID
    • Vendor Name
    • Remarks
    • Statuses for:
      • Active
      • 1099
      • Payroll
      • Minority
      • Female
      • Employee
      • RFP
      • Catalogue
      • Electronic
      • Direct Draft
      • ACH Active


  • Additionally, the total number of invoices, gross amount, and 1099 amount are included in the file.


Requirements

  • Vouchers must be distributed for the amounts to show on the report.


Vendor Fiscal Year File

  1. Procurement → Vendor Payments → Reports → Fiscal→ Vendor Fiscal Year File
  2. Some of the range criteria available are shown below.
  3. Click Run/Print Report (Process wheel).


FIELDSOpt.Rec.Req.Description
Fiscal YearEnter the fiscal year
Sort ByVendor ID or Vendor Name
Vendor IDEnter a specific vendor ID
Vendor NameEnter a specific vendor name
Opt. = Optional  Rec. = Recommended  Req. = Required