Inventory Management dashboards and reports

There are several reports that are available in the dashboards for Inventory Management.

Burn Rate Calculator

The Burn Rate Calculator report was created to help you track how quickly items are being used at your facility. The report based on guidelines published by the United States Centers for Disease Control (CDC) in September 2020 and our Inventory Transaction model.

The gain for our clients is that the CDC spreadsheet requires manual entry of items and beginning quantities each day in order to calculate usage. Since you have Infor Financials & Supply Management Analytics, we’ve done the work for you. All you have to do is open the Burn Rate Calculator to see the usage analysis for your items on a daily basis. No manual entry required.

The top section of the report in blue - Quantity at the Start of the Day contains the Stock On Hand quantity at the start of the day.

The green section of the report, called the Quantity Used per Day, shows the quantity used per day.

The pink section of the report contains the calculation of the Number of Days Supply Remaining based on the average consumption rate.

Using the calculator:

When opened, the report defaults to today’s date. You can change the date using the filters on the dashboard.

The blue section at the top of the report displays what the stock on hand was at the start of the day today for the 14-day range. The data is grouped by Purchasing Major/Minor class, Inventory Major/Minor class, or Item (as selected in filters).

In the next section with the green heading, the Item Usage or Consumption Rate each day is displayed that shows the usage trend.

In the pink, or last section of the report, Number of Days Supply Remaining is calculated based on quantity used each day in the selected range. Use this section to see how the supply remaining changes based on the supply/usage trends in the 14-day range.

The filters used for slicing data are:

  • Date (defaults to current date)
  • Company
  • Critical Item flag
  • Inventory Locations
  • Inventory Items
  • Inventory Major/Minor
  • Purchasing Major/Minor Class
  • PPE flag
  • Dimension 1
  • Dimension 2

The report can be filtered to display items in groups or individually. Examples of group rollups include Purchasing Major/Minor classes, Inventory Major/Minor classes, or Inventory Locations.

Dimension 2 has the individual item selection as an option. If the user select items it will display all item level detail in the report. The Item filter in Dimension 2 can be combined with the inventory item, PPE, or Critical Item filters on the dashboard to display selected specific items in the report results.

Backorders

The Inventory Backorder Tracking dashboard has these charts and a detailed report:

  • The Backorder Quantities by Location chart displays summarized backordered quantities at each Inventory Location sorted high to low.
  • The Backorder Quantities by Inventory Class chart compares backordered quantities across inventory classes ranked high to low.
  • The Backordered Items by Inventory Class report on the lower half of the canvas displays details of the backorders by Item, Company, and Inventory Location.

Inventory Manager

The Inventory Manager dashboard has these charts:

  • The Historical Inventory Transactions chart summarizes transactions of all types over the inventory periods of the current inventory year.

    The views are based on the Inventory History subject area and the filters used for slicing data are:

    • Year
    • Period
    • Company
    • Critical Item
    • Inventory Items
    • Inventory Locations
    • Personal Protective Equipment
  • The Inventory Value By Location chart shows inventory values by location in a column chart.

    The views are based on the Inventory History subject area and the filters used for slicing data are:

    • Year
    • Period
    • Company
    • Critical Item
    • Inventory Items
    • Inventory Locations
    • Personal Protective Equipment
  • The Turn Rate chart is a trend chart over time showing the rate at which stock is turning over time. "Turn Rate" is how fast the goods are consumed - how many times in and out over a period of time. Turn Rates are summarized by location in this chart. Clicking one of the lines representing a stocking location will drill across to the Inventory Turns dashboard providing the detail for the data supporting the dot clicked.

    The chart displays Inventory History facts and the filters or attributes of the facts are:

    • Year
    • Period
    • Company
    • Critical Item
    • Item
    • Inventory Location
    • PPE
  • The Average SOH MOM – (Average Stock on Hand Month over Month) trend report shows summarized values for Average SOH over time.

    The views are based on the Inventory History subject area and the filters used for slicing data are:

    • Year
    • Period
    • Company
    • Critical Item
    • Inventory Items
    • Inventory Locations
    • Personal Protective Equipment

Inventory Transactions

The Inventory Transactions dashboard has these charts:

  • The Inventory Transactions by Type chart displays transaction counts ranked high to low and sliced by Document Type.

    The filters used for slicing data are:

    • Company
    • Item
    • Document Type
    • Requesting Location
    • Date Range (defaults current month, current date)
    • Stocking Location
    • System Code
    • Fin Dims 1-4
    • Account
    • Accounting Entity
  • The Inventory Transactions by Requesting Location chart displays transaction counts by Requesting Location. Clicking one of the bars in the chart will drill across to the Requisition Lines report.

    The filters that can be used for slicing data are:

    • Company
    • Item
    • Requesting Location
    • Date Range
    • Doc Type
    • Stocking Location
    • System Code
    • Fin Dims 1-4
    • Account
    • Accounting Entity
  • Receipt Transactions displays information about the volume and placement of receipts. The default display is for the current period. The data in the chart can be changed by using these embedded attribute filters in the dashboard:
    • Date Range
    • Item
    • Accounting Entity
    • Company
    • Stocking Location
    • Requesting Location
    • Doc Type
    • System Code
    • Fin Dims 1- 4
    • Account
  • Transaction Expense displays expense distributions for items being consumed in the Inventory system. The default view in the dashboard is the current period of the current year, Current Month/First Date -- > Current Month/Current Date. Details about the expense are included along with the quantity and unit cost of the goods.
    The report can be further analyzed by slicing with these attributes embedded in the dashboard filters:
    • Date Range
    • Company
    • Item
    • Stocking Location
    • Requesting Location
    • Doc Type
    • System Code
    • Fin Dims 1- 4
    • Account
    • Accounting Entity.

Inventory Turns

The dashboard has these reports:

  • The Turns Over Time report illustrates the trend of actual inventory turns. Populating the "Target" filter dynamically updates the chart, allowing you to compare actual results against a target goal. The data can also be sliced by:
    • Company
    • Location
    • Item
    • Account Group
    • Manufacturer
    • Manufacturer Number (Vendor Catalog Number)
    • Period
    • Year
  • The Turnover by Location report compares the turnover rate between different Inventory Locations. The results will reflect the filter selections.

    Data can be sliced by:

    • Company
    • Location
    • Item
    • Account Group
    • Manufacturer
    • Manufacturer Number (Vendor Catalog Number)
    • Period
    • Year
  • Turns by Item was created to show information about an item's turn activity at an inventory location in (a) specific period(s). The report displays the data the way it's stored in the "InventoryUsageHistory" business class which summarizes a lot of information. For example we're going to see each item at each location for each period of each year included in the dashboard query based on your filter selection.

    Inventory Calendar definitions from the Inventory application make the Year and Period and the rest of the information is organized by:
    • Inventory Company
    • Inventory (Stocking) Location
    • Inventory Items (items stocked there)
    The report can be sliced by:
    • Company
    • Year
    • Period
    • Location
    • Item
    • Manufacturer
    • Manufacturer Division and/or Manufacturer Number
    • Account Group.

Inventory Valuation

The Inventory Valuation report is based on the Inventory on Hand subject area which is a snapshot of the ItemLocation business class at the last data refresh. The report shows the value of inventory at that point in time. Based on the Company and Inventory Location filters applied to the dashboard, the query will read each Item’s Unit Cost and multiplies it by the current Stock On Hand Qty listing values for each item. The report summarizes the results by Inventory Location Account Group, Company and Inventory Location. The values in the report are Unit Cost, Intransit Qty, Inspection hold Qty, Stock On Hand Qty, and Stock On Hand value.

Item Usage Expense by Cost Center

The Item Usage Expense by Cost Center report is based on the Inventory Transactions fact and is a drill across destination to provide supporting detail for other reports on other dashboards. Item Usage Expense is organized by financial elements along with these other transaction information:
  • Transaction Number
  • System
  • Document Type
  • Requesting Location
  • Item
  • and so forth

Data can be further analyzed by slicing with the attribute filters in the dashboard:

  • Date Range
  • Accounting Entity
  • Fin Dim 1-4
  • Account
  • Doc Type
  • System Code
  • Company
  • From Location
  • Item
  • PPE flag
  • Critical Item flag
  • Requesting Location
  • Company

Overstocked Items

The Overstocked Items report is a detailed report that shows the items that are holding more inventory than the item location's reorder point and requested order quantity. It displays a list of items, company, inventory location, average cost, stock on hand quantity, reorder point, reorder quantity, reorder point and reorder quantity, SOH value, reorder point and reorder quantity value, overstock value and overstock quantity.

The filters used for slicing data are:

  • Company
  • Inventory Location Name
  • Inventory Major Class
  • Inventory Minor Class
  • Items

POS by Delivery Date

The Purchase Orders by Delivery Date is a detailed report which displays a list of Purchase Order lines that provides a view into the quantity, open order quantity, PO lines unreceived, and receipt quantity of the items. The report consists of early delivery date, item number, item description, vendor long name, company, PO number and line number.

The filters used for slicing data are:

  • Company
  • Contract
  • Critical Item
  • Date Range
  • Item Number
  • Personal Protective Equipment
  • PO Number
  • Ship To Location
  • Vendor Long Name