Mission Control is our planning and purchasing analysis platform, comprising two main sections: Current Status and Inventory History.
Current Status data encompasses the most recent point-in-time information, which is either the present moment or data collected within the past few hours.
Inventory History is presented as a chronological series categorized by month, excluding the ongoing month. You can access historical data for up to 18 months.
In both sections, all records are systematically organized by item-location-company for easy reference and management.
Inventory History Charts
Inventory History
Definition: The Inventory History chart illustrates the fluctuation of inventory value over time, calculated based on the transaction costs of items and the duration for which the inventory was held. Average Values are the calculated by obtaining the average of the month starting value and the month ending value.
Value: This information allows businesses to gain a comprehensive understanding of their inventory management efficiency. It aids in identifying trends, optimizing purchasing decisions, and ensuring effective allocation of resources.
Data Sources:
P21:
p21_inv_tranAverage Inventory Quantity and Value are derived from this source table using the
quantityandunit_cost_amountcolumns.
SAPB1:
oinm (inventory transactions)Average Inventory Quantity is derived from the source table using the
inqty - outqtyand the value is applied using the current supplier cost.
Sales History
Definition: The quantity OR value of items invoiced within each month.
Value: By tracking sales performance over time, businesses can identify trends, assess market demand, and make informed decisions regarding inventory management and sales strategies. This chart enables businesses to optimize inventory levels, identify product trends, and capitalize on opportunities for growth and profitability.
Data Sources:
P21: Tables
p21_invoice_line&p21_invoice_hdr.SAPB1: Tables
inv1 (ar invoice rows)&oinv (ar invoices).
Backorder History
Note: This chart exists only for P21 customers.
Definition: Depicts the trend of backorders over time, utilizing the quantity backordered and the historical average cost. This chart provides insights into the fluctuations and patterns of unfulfilled orders, aiding in inventory management and resource allocation.
Value: By analyzing the quantity backordered and the historical average cost, businesses can identify patterns, assess the impact on customer satisfaction, and optimize inventory management processes. This chart helps businesses proactively address supply chain challenges, minimize backorder occurrences, and improve overall operational efficiency.
Data Sources:
P21: Tables
p21_inv_tran.
Annualized Turns
Definition: Turns are calculated by dividing the total cost of goods sold by the average inventory value over the month, annualized for each month.
Value: It enables businesses to assess the efficiency of their inventory management processes, identify slow-moving items, and optimize purchasing and stocking strategies. This chart enables businesses to improve cash flow, reduce carrying costs, and maximize profitability through effective inventory turnover management.
Formula:
Cost of Goods Sold: Total expenses incurred for items invoiced within each month.
Average Inventory Value: See Inventory History above.
Data Sources:
P21: Tables
p21_inv_tran,p21_invoice_line&p21_invoice_hdr.SAPB1: Tables
oinm (inventory transactions),inv1 (ar invoice rows)&oinv (ar invoices).
Annualized GMROI
Definition: Gross Margin Return on Inventory Investment (GMROI) measures the profitability (return) of inventory investments over each month, calculated by analyzing the gross margin history and the corresponding inventory value during that period. Each month is annualized for the value over that window.
Value: By tracking GMROI over time, businesses can continuously evaluate and improve their inventory management strategies to drive long-term financial success.
Formula:
Sales: The total sales for items invoiced over each month.
Cost of Goods Sold: Total expenses incurred for items invoiced within each month.
Average Inventory Value: See Inventory History above.
Data Sources:
P21: Tables
p21_inv_tran,p21_invoice_line&p21_invoice_hdr.
Fill Rate
Definition: Percentage of all orders placed that are shipped on time and complete. Cancelled orders are excluded.
Value: By analyzing fill rates over time, businesses can assess their order fulfillment efficiency, identify bottlenecks in the supply chain, and improve customer satisfaction. It enables businesses to identify areas for improvement and implement strategies to meet customer demands effectively.
Formula:
Orders Shipped Complete: All all orders fulfilled within each month for previous 1 month where order is complete and shipped on time.
We calculate on time and complete based on the following data points:
Amount Requested
Amount Shipped
Requested by Date
Shipped Date
If an item was completed and shipped within three weeks of the expected ship date it is considered on-time and complete
Total Orders: All orders within each month for previous 1 months
Time Granularity: Month
Data Sources:
P21: Tables
p21_oe_hdr_vw,p21_invoice_hdr_vw,p21_oe_line_vw&p21_invoice_line_vw.SAPB1: Tables
ordr_orders_vw,rdr1_order_rows_vw&inv1_ar_invoice_rows_vw.
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.
Average Inventory Age
Average Inventory Age shows total days of inventory value over time, with color-coded indicators to help you quickly assess whether your inventory coverage is healthy.
🟢 Healthy — within your configured target range
🟡 Low — below the minimum threshold
🔴 High — above the maximum threshold
Only stockable items are included in this calculation.
💡 Note: Admins can configure the thresholds for Healthy, Low, and High from the Settings page, defining the number of days that correspond to each status band.