Inventory Metrics

This document provides documentation for inventory measures, including their names, business descriptions, and references to online sources for further explanation.

Inventory metrics only involve items of type inventory (Service and Non-Inventory items are excluded).

1. Financial KPIs

1.1. GMROI Monthly (EOM)

Gross Margin Return on Investment using monthly end-of-month average stock, measuring inventory profitability.

1.2. GMROI Weekly (EOW)

GMROI using weekly end-of-week average stock.

1.3. Sell-Through Rate

Ratio of sales quantity to purchase quantity for inventory items, indicating sales efficiency.

1.4. Stock Turnover Days

Average days to turn over stock, based on average value and cost.

2. General

2.1. Beginning Inventory Stock Quantity

Inventory quantity accumulated before the first date in the current posting-date selection.

2.2. Beginning Inventory Stock Value

Inventory value accumulated before the first date in the current posting-date selection, using the last exchange rate.

2.3. Average Stock Value

Average value of inventory stock over posting dates.

2.4. Average Stock Value Monthly (EOM)

Average stock value at end of months.

2.5. Average Stock Value Weekly (EOW)

Average stock value at end of weeks.

2.6. Inventory Cost Amount

Net inventory cost change adjusted for sales costs and purchase costs.

2.7. Inventory Cost Amount Change

Cost amount posted to inventory in the selected period, converted using the transaction-date exchange rate.

2.8. Inventory Cost Amount (LER)

Net cost of inventory in the selected period using last exchange rate.

2.9. Inventory Cost Amount Decrease

Total decreases in inventory cost amounts.

2.10. Inventory Cost Amount Increase

Total increases in inventory cost amounts.

2.11. Inventory No. of Items

Count of distinct items with inventory changes in the selected period.

2.12. Inventory Quantity

Net inventory quantity change adjusted for sales and purchase quantities.

2.13. Inventory Quantity Change

Quantity posted to inventory in the selected period.

2.14. Inventory Stock Quantity

Cumulative stock quantity up to the current date.

2.15. Inventory Stock Value

Cumulative stock value up to the current date using last exchange rate.

3. Transfers & Adjustments

3.1. Adjustment Amount

Net inventory adjustment amount, calculated as positive adjustments minus negative adjustments.

3.2. Adjustment Quantity

Net inventory adjustment quantity, calculated as positive adjustments minus negative adjustments.

3.3. Negative Adjustment Amount

Cost amount of negative inventory adjustments, shown as a positive magnitude.

3.4. Negative Adjustment Quantity

Quantity of negative inventory adjustments, shown as a positive magnitude.

3.5. Positive Adjustment Amount

Cost amount of positive inventory adjustments.

3.6. Positive Adjustment Quantity

Quantity of positive inventory adjustments.

3.7. Transfer Amount

Inventory cost amount posted with the Transfer item ledger entry type.

3.8. Transfer Quantity

Net inventory quantity posted with the Transfer item ledger entry type.

3.9. Transfer Quantity In

Transfer quantity received into inventory.

3.10. Transfer Quantity Out

Transfer quantity shipped out of inventory, shown as a positive magnitude.

4. Aging

4.1. Aging Inventory Stock Value

The stock value up to the current date, using last exchange rate, and responds to filters/breakdowns on Inventory Aging Buckets.

4.2. Aging Inventory Stock Quantity

The stock quantity up to the current date, using last exchange rate, and responds to filters/breakdowns on Inventory Aging Buckets.

5. Inventory Out of Stock

5.1. Out of Stock 14d - No. of Items

Count of items out of stock for 14+ days.

5.2. Out of Stock 14d %

Percentage of items out of stock for 14+ days.

5.3. Out of Stock 1d - No. of Items

Count of items currently out of stock.

5.4. Out of Stock 1d %

Percentage of items currently out of stock.

5.5. Out of Stock 30d - No. of Items

Count of items out of stock for 30+ days.

5.6. Out of Stock 30d %

Percentage of items out of stock for 30+ days.

5.7. Out of Stock 7d - No. of Items

Count of items out of stock for 7+ days.

5.8. Out of Stock 7d %

Percentage of items out of stock for 7+ days.