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.
Inventory Aging
Inventory aging provides a breakdown of current inventory value, grouped by how long the inventory has been held in stock.
Calculation
Start with the current inventory value for each item/location.
Trace back to positive inventory receipts and layer them by age.
Retain layers contributing to the current inventory total.
Bucket into age groups:
Only inventory still on hand is retained.
These remaining layers are assigned an age based on how long ago the inventory was received.
Use costs for the month/item/location and group them by month.
Age Bucketing Logic
Inventory receipts are grouped into monthly buckets based on the calendar month they were received — not their exact age in days.
A receipt is treated as if it was received on the first day of its calendar month, regardless of the actual date.
For example:
If today is July 2 and a receipt came in on June 26, it will be bucketed under "Last Month" (June) — even though it's only 6 days old.
Actual Buckets Used
Bucket | Calendar Month Received |
Current Month | This month (e.g. July) |
Last Month | 1 month ago (e.g. June) |
2 Months Ago | 2 Months Ago (e.g. May) |
3 Months Ago | 3 Months Ago (e.g. April) |
4 Months Ago | 4 Months Ago (e.g. March) |
📌 Note: Buckets do not reflect exact day count. A receipt can be only a few days old and still appear in the “Last Month” bucket if it was received in the previous calendar month
Data Sources:
P21:
p21_inv_tranSAP B1:
oinm_inventory_transactions
This helps identify slow-moving or aging inventory.
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.