Difference between revisions of "Vendor Performance Report"
From Adjutant Wiki
| Line 18: | Line 18: | ||
'''Vendno''' and/or '''Item''' can be left blank to generate reports of all items from all vendors, all items from a single vendor, or all vendors of a single item. | '''Vendno''' and/or '''Item''' can be left blank to generate reports of all items from all vendors, all items from a single vendor, or all vendors of a single item. | ||
| − | |||
'''2.''' Use the '''Include non-stock''' and '''Exclude misc items''' to include/exclude those items from the report. | '''2.''' Use the '''Include non-stock''' and '''Exclude misc items''' to include/exclude those items from the report. | ||
| − | |||
'''3.''' Click on '''Report''' to generate a PDF of the report. This will bring up a screen with various export options. See below for an example of this screen. | '''3.''' Click on '''Report''' to generate a PDF of the report. This will bring up a screen with various export options. See below for an example of this screen. | ||
| − | |||
==Export Options== | ==Export Options== | ||
| Line 33: | Line 30: | ||
'''Raw Excel Export''' This button allows the user to export a raw CSV of the Vendor Performance Report. | '''Raw Excel Export''' This button allows the user to export a raw CSV of the Vendor Performance Report. | ||
| − | |||
| − | |||
| − | |||
'''Export Report''' Allows the report to be exported in a variety of formats, including XLSX, DOCX, CSV, and an image file | '''Export Report''' Allows the report to be exported in a variety of formats, including XLSX, DOCX, CSV, and an image file | ||
| − | |||
| − | |||
=Fields/Filters= | =Fields/Filters= | ||
| Line 49: | Line 41: | ||
'''LstRec Date:''' Report date range | '''LstRec Date:''' Report date range | ||
| − | '''Company''' | + | '''Company''' lc_company |
| − | |||
'''Date Range''' | '''Date Range''' | ||
| − | '''Vendor''' | + | '''Vendor''' custno, company |
| − | |||
| − | |||
| − | '''Item''' | + | '''Item''' item |
| − | |||
| − | '''Description''' | + | '''Description''' descrip |
| − | |||
| − | '''Vendor Part#''' | + | '''Vendor Part#''' vpartno |
| − | |||
| − | '''Last Receipt''' | + | '''Last Receipt''' ttod(lstrec) |
| − | |||
| − | '''Promised Lead Time''' | + | '''Promised Lead Time''' pleadtime |
| − | |||
| − | '''Average Recpt Days''' | + | '''Average Recpt Days''' leadtime |
| − | |||
| − | '''Rating Code''' | + | '''Rating Code''' rating |
| − | |||
Revision as of 16:01, 12 December 2022
General Information
Default Menu Location Reports >> Purchase Order >> Vendor Performance Report
URL Reports/VendorPerformanceReport_S.htm
Report Function Creates and displays graded reports of vendor services based on promised lead time. Vendors are graded by a rule setup in the Item Master screen.
Instructions
1. Use the Vendno(vendor number), Item(item number), and Date Filters to set the range of the report. Vendno and/or Item can be left blank to generate reports of all items from all vendors, all items from a single vendor, or all vendors of a single item.
2. Use the Include non-stock and Exclude misc items to include/exclude those items from the report.
3. Click on Report to generate a PDF of the report. This will bring up a screen with various export options. See below for an example of this screen.
Export Options
Pick Excel Columns Choose the fields needed for an Excel export of the report. The most frequently used are detailed in the next section of this article.
Raw Excel Export This button allows the user to export a raw CSV of the Vendor Performance Report.
Export Report Allows the report to be exported in a variety of formats, including XLSX, DOCX, CSV, and an image file
Fields/Filters
Vendor number: Specific vendor for the report
Item Number: Specific item number for the report
LstRec Date: Report date range
Company lc_company
Date Range
Vendor custno, company
Item item
Description descrip
Vendor Part# vpartno
Last Receipt ttod(lstrec)
Promised Lead Time pleadtime
Average Recpt Days leadtime
Rating Code rating
Example Report
