The Inventory Operations Health report provides actionable insights into how Recurrency impacts key inventory metrics on a short term cadence. A faster reporting cycle helps users monitor inventory health, understand trends, and make informed decisions in near real-time.
The report is highly filterable and supports detailed analysis by:
Location
Stockable / Non-stockable
ABC Class
Primary Supplier
Buyer
Product Group
Item
It includes metrics such as weekly inflow/outflow, inventory aging, fill rate, and new backorders to help you stay on top of critical inventory dynamics.
Weekly Inflow/Outflow
Weekly Inflow/Outflow captures the total value of inventory moving in and out of your system each week.
Inflow: Calculated from purchase orders, it reflects the total value of goods received.
Formula:
Unit Price × Unit Size × Quantity ReceivedData Sources:
P21:
p21_po_lineSAP B1:
por1_purchase_order_rows
Outflow: Represents the total cost of goods shipped to customers within the week.
Formula:
Sum of costs from all invoiced lines (based on invoice date).
Data Sources:
P21:
p21_invoice_lineSAP B1:
inv1_ar_invoice_rowsoinv_ar_invoices
Transfers Toggle
A “Show Transfers” toggle allows you to include or exclude inventory transfers between locations:
On: Includes transfers in the inflow/outflow calculation for a complete picture of internal and external movement.
Off: Shows only external movement (e.g., purchases and sales).
This flexibility helps you analyze both inbound and outbound flows at a granular level.
Weekly Fill Rate
The weekly fill rate measures the percentage of orders shipped and completed on time each week.
Calculation
Uses the same calculation as Inventory Mission Control but applies it on a weekly basis.
Includes the fill rate grace period (defined in your settings).
Excludes cancellations.
An order is considered on time if completed within the grace period.
Weekly New Backorders
This metric captures the total inventory value of new backorders created each week.
Calculation
Identify positive backorder delta values (based on transaction date).
Determine the average unit cost for each item/location.
Multiply the backorder delta by unit cost.
Exclude transactions > $1,000,000 to filter out potential errors.
Sum by week.
Data Sources:
P21:
p21_inv_tranSAP B1:
oinm_inventory_transactions
This metric provides visibility into emerging backorder issues.