VENDOR FISCAL YEAR FILE (VENFYRFILE)

VENDOR FISCAL YEAR FILE (VENFYRFILE)

A new report has been created for OpenRDA and added to the Fiscal submenu under Reports in the Vendor Payments module. The Vendor Fiscal Year File 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, and statuses for Active, 1099, Payroll, Minority, Female, Employee, RFP, Catalogue, Electronic, Direct Draft, and ACH Active. Additionally, the total number of invoices, gross amount and 1099 amount are included in the file. This report facilitates production of a current vendor listing for publication on your website (simply strip out the columns/fields that you do not need); the Remarks field can be used to indicate the type of vendor (i.e., services provided) if desired.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Other Posts

POSITION CATEGORIES

Searching/quering job masters based on assigned category identifications is now available (and the field will also display on the define list). Position categories are maintained...

Read More...

EXPENDITURE DETAIL REPORTS

When payroll amounts are needed but not the detail, use of the financial management activity (instead of summarized payroll job and deduction transactions) is now...

Read More...