Difference between revisions of "Vendor Performance Report"
From Adjutant Wiki
(→Export Options) |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
| − | |||
===General Information=== | ===General Information=== | ||
| − | |||
'''Default Menu Location''' Reports >> Purchase Order >> Vendor Performance Report | '''Default Menu Location''' Reports >> Purchase Order >> Vendor Performance Report | ||
| Line 13: | Line 11: | ||
| − | + | ==Instructions== | |
| + | |||
'''1.''' Use the '''Vendno'''(vendor number), '''Item'''(item number), and '''Date Filters''' to set the range of the report. | '''1.''' Use the '''Vendno'''(vendor number), '''Item'''(item number), and '''Date Filters''' to set the range of the report. | ||
| Line 22: | Line 21: | ||
'''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 27: | ||
'''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 | ||
| − | |||
| − | |||
=Fields/Filters= | =Fields/Filters= | ||
| Line 47: | Line 39: | ||
'''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 |
| − | |||
==Example Report== | ==Example Report== | ||
[[image:vprpdf1.png]] | [[image:vprpdf1.png]] | ||
| + | [[category:Purchasing]] | ||
Latest revision as of 16:02, 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
