O. Vendor Item Numbers
- Bart Rogacewicz
To get to the Vendor Item Numbers screen, click on Reports -> O. Vendor Item Numbers.
The Vendor Item Number report provides a simplified report that was created to show Vendor Item numbers for items in the database and give the ability to add/edit them on the fly. The report can be narrowed down by Department, Group or Category.
There are a few methods and combinations to each report generated with this feature:
By not selecting any supplier, the report will generate all items in the database and display their vendor/vendor item number if available.
By selecting a supplier, the report will generate all items in the database and items that are NOT linked to the supplier chosen will display blank fields for the vendor/vendor item number for a convenient way to change the supplier and the item number
By selecting a supplier AND choosing Only Show Items Linked to this Supplier, the report will generate only the items linked to the selected supplier.
Regardless of method the report is generated by, you can click on any Vendor Item field and a pop-up window will display allowing you to edit the information as such:
Simply edit any or all information that you choose and click "Save" to write it to the item record, taking you back to the previous screen.
When ready to generate the report simply click "Generate Report".
To print the report page, click the "Print" button or press the "Enter" key when the "Print" button is highlighted.
If you'd like to export the report to a file, click the "Export Data" button or press the "Enter" key when the "Export Data" button is highlighted.
Export to Excel only works on full versions of Microsoft Excel/Office. It does NOT work with the Office Starter 2010 and other starter/third party versions. If using any one of these, export to a Comma Separated Values (CSV) instead.
The user may also clear all the data displayed on the screen by clicking the "Clear" button or by pressing the "Enter" key when the "Clear" button is highlighted.