Inventory widgets

Several sets of widgets are available in your Inventory Analytics Dashboard folder that you can drag and drop on to your Analytics Dashboards.

In order for you to access each Analytics Dashboard, your company must be licensed to use it and you must be assigned to the capabilityA group of functions and features that can be hidden or revealed to simplify the user interface. Capabilities can be enabled or disabled by changing preference settings, or they can be controlled through an administration interface. for the Analytics Dashboard. See your BI administrator for access.

The Inventory Analytics Dashboard is located in Analytics Dashboards > Inventory > Dashboards.

The Inventory widgets are located in Analytics Dashboards > Inventory > Widgets, in the following folders:

In addition, you can add the Title & Help widgetDashboards: Objects added from the Content pane to the dashboard are displayed in widgets. Widgets are containers that allow you to interact with and manipulate the content contained within them. to your dashboardA web page that can contain one or more widgets that graphically represent business data. to provide a title widget and a link to dashboard help.

Active Item Value & Count

These widgets display the total value of inventory on hand and count that is considered active by:

Type Chart type Widget name

warehouse

Graph

Active Item Value & Count By Warehouse

product groupIn security, a list of users or other groups that can be used to assign access permissions and capabilities. Groups can be referenced from other authentication sources or can be local to Pronto Xi Business Intelligence. Local groups are managed from BI Administration. The list of groups that an authentication user is a member of is part of the user's passport for an Pronto Xi Business Intelligence session. In reporting, grouping is the action of organising common values of query item together and only displaying the value once. Headers and footers often appear after each instance of a common value in a grouped column

Graph

Active Item Value & Count By Product Group

division-department-category-class-product group-item hierarchyIn Analytics Dashboards, regular dimensions contain descriptive and business key information and this information is organised into a hierarchy; from it's highest level of granularity, to its lowest. The hierarchy contains multiple levels. For example, a hierarchy that has three levels such as "All Products", "Product Group", and "Products".

Graph

Active Item Value & Count By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Active Item Value & Count By ABC Class

sales type

Graph

Active Item Value & Count By Sales Type

reporting item hierarchy

Graph

Active Item Value & Count By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Active Item Value & Count By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Active Item Value & Count By Reporting Warehouse Hierarchy

InActive Item Value & Count

These widgets display the total value of inventory on hand and count that is considered inactive by:

Type Chart type Widget name

warehouse

Graph

InActive Item Value & Count By Warehouse

product group

Graph

InActive Item Value & Count By Product Group

division-department-category-class-product group-item hierarchy

Graph

InActive Item Value & Count By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

InActive Item Value & Count By ABC Class

sales type

Graph

InActive Item Value & Count By Sales Type

reporting item hierarchy

Graph

InActive Item Value & Count By Reporting Item Hierarchy

reporting product group hierarchy

Graph

InActive Item Value & Count By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

InActive Item Value & Count By Reporting Warehouse Hierarchy

Inventory Ageing

These widgets display the relative age of the inventory value on hand by:

Type Chart type Widget name

warehouse

Graph

Inventory Ageing By Warehouse

product group

Graph

Inventory Ageing By Product Group

division-department-category-class-product group-item hierarchy

Graph

Inventory Ageing By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Inventory Ageing By ABC Class

sales type

Graph

Inventory Ageing By Sales Type

reporting item hierarchy

Graph

Inventory Ageing By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Inventory Ageing By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Inventory Ageing By Reporting Warehouse Hierarchy

Inventory Consignment On Hand Value

These widgets display the total value of inventory on hand from a supplier on a consignment basis by:

Type Chart type Widget name

warehouse

Graph

Inventory on Consignment On Hand Value By Warehouse

product group

Graph

Inventory on Consignment On Hand Value By Product Group

division-department-category-class-product group-item hierarchy

Graph

Inventory on Consignment On Hand Value By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Inventory on Consignment On Hand Value By ABC Class

sales type

Graph

Inventory on Consignment On Hand Value By Sales Type

reporting item hierarchy

Graph

Inventory on Consignment On Hand Value By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Inventory on Consignment On Hand Value By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Inventory on Consignment On Hand Value By Reporting Warehouse Hierarchy

Inventory On Consignment Value

These widgets display the total value of inventory that has been sent to customer sites on a consignment basis by:

Type Chart type Widget name

warehouse

Graph

Inventory on Consignment Value By Warehouse

product group

Graph

Inventory on Consignment Value By Product Group

division-department-category-class-product group-item hierarchy

Graph

Inventory on Consignment Value By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Inventory on Consignment Value By ABC Class

sales type

Graph

Inventory on Consignment Value By Sales Type

reporting item hierarchy

Graph

Inventory on Consignment Value By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Inventory on Consignment Value By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Inventory on Consignment Value By Reporting Warehouse Hierarchy

Inventory Value

These widgets display the current value of the total inventory on hand by:

Type Chart type Widget name

warehouse

Graph

Inventory Value By Warehouse

product group

Graph

Inventory Value By Product Group

division-department-category-class-product group-item hierarchy

Graph

Inventory Value By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Inventory Value By ABC Class

sales type

Graph

Inventory Value By Sales Type

reporting item hierarchy

Graph

Inventory Value By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Inventory Value By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Inventory Value By Reporting Warehouse Hierarchy

Inventory Value & Count Over Maximum

These widgets display the value and total number of instances of inventory where stock levels exceed optimum by:

Type Chart type Widget name

warehouse

Graph

Inventory Value & Count Over Maximum By Warehouse

product group

Graph

Inventory Value & Count Over Maximum By Product Group

division-department-category-class-product group-item hierarchy

Graph

Inventory Value & Count Over Maximum By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Inventory Value & Count Over Maximum By ABC Class

sales type

Graph

Inventory Value & Count Over Maximum By Sales Type

reporting item hierarchy

Graph

Inventory Value & Count Over Maximum By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Inventory Value & Count Over Maximum By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Inventory Value & Count Over Maximum By Reporting Warehouse Hierarchy

Inventory Value & Count Under Minimum

These widgets display the value and total number of items required to bring inventory levels up to their safety levelIn a hierarchy, a level indicates a group of common or related members. For example, in a Time level, members may include Year, Month, Day or Fiscal Year, Calendar Year, etc. by:

Type Chart type Widget name

warehouse

Graph

Inventory Value & Count Under Minimum By Warehouse

product group

Graph

Inventory Value & Count Under Minimum By Product Group

division-department-category-class-product group-item hierarchy

Graph

Inventory Value & Count Under Minimum By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Inventory Value & Count Under Minimum By ABC Class

sales type

Graph

Inventory Value & Count Under Minimum By Sales Type

reporting item hierarchy

Graph

Inventory Value & Count Under Minimum By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Inventory Value & Count Under Minimum By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Inventory Value & Count Under Minimum By Reporting Warehouse Hierarchy

Item Count

These widgets display the total number of item codes defined by:

Type Chart type Widget name

warehouse

Graph

Item Count By Warehouse

product group

Graph

Item Count By Product Group

division-department-category-class-product group-item hierarchy

Graph

Item Count By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Item Count By ABC Class

sales type

Graph

Item Count By Sales Type

reporting item hierarchy

Graph

Item Count By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Item Count By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Item Count By Reporting Warehouse Hierarchy

Obsolete Inventory Value

These widgets display the total value of inventory on hand that is considered obsolete by:

Type Chart type Widget name

warehouse

Graph

Obsolete Inventory Value By Warehouse

product group

Graph

Obsolete Inventory Value By Product Group

division-department-category-class-product group-item hierarchy

Graph

Obsolete Inventory Value By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Obsolete Inventory Value By ABC Class

sales type

Graph

Obsolete Inventory Value By Sales Type

reporting item hierarchy

Graph

Obsolete Inventory Value By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Obsolete Inventory Value By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Obsolete Inventory Value By Reporting Warehouse Hierarchy

Safety Inventory Value

These widgets display the current value of the inventory level required to ensure that demand is met by:

Type Chart type Widget name

warehouse

Graph

Safety Inventory Value By Warehouse

product group

Graph

Safety Inventory Value By Product Group

division-department-category-class-product group-item hierarchy

Graph

Safety Inventory Value By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Safety Inventory Value By ABC Class

sales type

Graph

Safety Inventory Value By Sales Type

reporting item hierarchy

Graph

Safety Inventory Value By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Safety Inventory Value By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Safety Inventory Value By Reporting Warehouse Hierarchy

Use By Date Ageing

These widgets display the value of inventory on hand that is subject to a limited useable life, broken into expiry date ranges:

The expiry categories are Expired, 30 Days, 60 Days, 90 Days, and Above 90 Days.

Type Chart type Widget name

warehouse

Graph

Use By Date Ageing By Warehouse

product group

Graph

Use By Date Ageing By Product Group

division-department-category-class-product group-item hierarchy

Graph

Use By Date Ageing By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Use By Date Ageing By ABC Class

sales type

Graph

Use By Date Ageing By Sales Type

reporting item hierarchy

Graph

Use By Date Ageing By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Use By Date Ageing By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Use By Date Ageing By Reporting Warehouse Hierarchy

Use By Date Inventory Value

These widgets display the total value of inventory on hand that is subject to a limited useable life by:

Type Chart type Widget name

warehouse

Graph

Use By Date Inventory Value By Warehouse

product group

Graph

Use By Date Inventory Value By Product Group

division-department-category-class-product group-item hierarchy

Graph

Use By Date Inventory Value By Div - Dep - Cat - Class - PG - Item

ABC class

Graph

Use By Date Inventory Value By ABC Class

sales type

Graph

Use By Date Inventory Value By Sales Type

reporting item hierarchy

Graph

Use By Date Inventory Value By Reporting Item Hierarchy

reporting product group hierarchy

Graph

Use By Date Inventory Value By Reporting Product Group Hierarchy

reporting warehouse hierarchy

Graph

Use By Date Inventory Value By Reporting Warehouse Hierarchy