Skip to main content

Vendors - IQ

This article explains the vendor tabfor subscribers of Inventory IQ

Updated over a week ago

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

Did this answer your question?