What this Process Does

  • This query allows you to see a summary balance for each month of the year for a given vendor.
  • The gross amount and 1099 amount is shown by month as well as the number of invoices for the year.
  • It is also possible to drill down to the individual invoices and vouchers from this query.


Query Vendor Fiscal Year

  1. Procurement → Vendor Payments → Query → Vendor Fiscal Year
  2. Populate the fields you want to query on.
  3. If you want to view individual invoices or vouchers, click on the Invoice or Voucher button at the bottom of the vendor fiscal year browse or maintain screen.
  4. Click Cancel query is complete.


FIELDSOpt.Rec.Req.Description
Delete this record♦——Boolean should be turned on to delete the record
Vendor ID——♦Unique ID for this Vendor (cannot change without using Change Vendor ID process)
Fiscal Year——♦Fiscal Year voucher was expensed
# Invoices——♦# of invoices paid during selected Fiscal Year
Gross Amount——♦Dollar amount that was paid on voucher
1099 Amount——♦1099 dollar amount that was paid on voucher
Month Fields——♦Month that voucher was paid
Year Totals——♦Total Voucher Amount for Fiscal Year
Invoices——♦Select to see invoices related to selected Fiscal Year
Vouchers——♦Select to see vouchers related to selected Fiscal Year
Voucher Report—♦—Select to see Vendor Payments Vouchers by Check/EFT Number for Clear Fiscal Year report
Opt. = Optional  Rec. = Recommended  Req. = Required