Vendors
In the top navigation bar, Vendors is a dedicated page to get an overview of active vendors flowing from your ERP system over to AGR. This article explains what is included in the base package subscription of Inventory IQ. to see how the vendor tab looks with the Insights subscription, click here:
Vendors workflow
Vendor Overview
At the top of the page we display a list of your top 3 vendors, ranked by highest stock value, in addition to displaying the total stock value across all vendors.
Export to Excel
right click on any line to export the full vendor list to excel
Vendor details page
When you click a vendor name, a pop-up window opens showing all items where that vendor is set as the Primary Vendor.
The item list provides a quick overview of the vendor's portfolio and its performance. For example, you can sort by Stock Value or Sales Value to identify the items with the highest inventory investment or sales contribution.
To see stock and sales at SKU level (item + location), expand the > Item No. to view the individual locations for each item.
Vendor notes can be made
The note will appear as below:
For further detail, the user can click the [open in reports] button, mid screen to the right.
Note, the search bar will allow you to search for an item number or item name.
Vendors IQ - KPI details and columns
KPI's
KPI | Calculations |
Top vendors, inventory IQ subscribers
| Here we are looking at the current stock value on hand (stock units * item's cost price).
the on hand stock is multiplied with today's cost price from the item card in the ERP system. |
Total Stock value  |
The total stock value shows the sum of stock value across all active suppliers: (stock units * item's cost price) |
information columns
In the vendor overview, and the vendor details page there is a list of information columns described here below:
Vendors - IQ Column Name | Description |
Vendor | Name and number |
Lead time days | The registered lead time in the vendor card in the ERP system, or overwritten on vendor level in AGR |
Add. lead time days | if registered on vendor level in AGR |
Item count | Number of active items that are linked to the vendor in the ERP system, as primary vendor |
Stock value | [stock units * cost price] on hand stock, item card cost price |
Item no | Item number (from the ERP system) |
Original item no | Supplier's item number (from ERP system) |
Item name | Item name from the ERP system |
Item group level 1 | Item group name, level 1 from the ERP system |
sale value last 12 months | [sale quantity (last 360days) * sale price] from the ERP's item card |