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.
Vendor details page
If you click on a vendor name, a new pop up window opens with a list of all the items where the vendor is marked as primary vendor.
In this page, the user sees the list of items that are marked in the ERP with this vendor as the primary vendor. It can give insight to sort the items by highest stock value or sale value.
The user can view the stock and sales on the sku level ( stock keeping unit, [item + location] level) by expanding the > item no.
For further detail, the user can click the [open in items] button, mid screen to the right.
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 |