Inventory

Inventory - Inventory Aging (Preview)

The fact folder in this subject area shows the metrics details below.

Metric	Metric Definition
Inventory Age	This metric shows Inventory Age at Item-Org level is the weighted average. This metric is calculated as below sum(age_as_per_date_received multiplied by primary_onhand_quantity) divided by inventory onhand quantity
Days left for Lot Expiry	This metric is calculated as difference of Lot Expiration Date and Current Date measured in Days
Expired Lot Age	This metric is calculated as difference of Current Date and Lot Expiration Date measured in Days
Expired Lot Quantity	This metric is calculated as below; Expired Lot Quantity is equal to Sum of Current Onhand Quantity for Lot Item where Lot expiration date is less than current date
Inventory Age Quantity	Inventory Age Quantity is the Inventory Onhand Quantity grouped in Age buckets
Inventory Age - Under 30 Days	Inventory Onhand Quantity less than 30 Days of Inventory Age
Inventory Age - 31-60 Days	Inventory Onhand Quantity between 31 to 60 Days of Inventory Age
Inventory Age - 61-90 Days	Inventory Onhand Quantity between 61 to 90 Days of Inventory Age
Inventory Age - 91-180 Days	Inventory Onhand Quantity between 91 to 180 Days of Inventory Age
Inventory Age - 181-365 Days	Inventory Onhand Quantity between 181 to 365 Days of Inventory Age
Inventory Age - Under 7 Days	Inventory Onhand Quantity less than 7 Days of Inventory Age
Inventory Age - 8-14 Days	Inventory Onhand Quantity between 8 to 14 Days of Inventory Age
Inventory Age - 15-21 Days	Inventory Onhand Quantity between 15 to 21 Days of Inventory Age
Inventory Age - 22-28 Days	Inventory Onhand Quantity between 22 to 28 Days of Inventory Age
Inventory Age - 29-91 Days	Inventory Onhand Quantity between 29 to 91 Days of Inventory Age
Inventory Age - 92-365 Days	Inventory Onhand Quantity between 92 to 365 Days of Inventory Age
Inventory Age - 1+ Year	Inventory Onhand Quantity greater than or equal to 366 Days of Inventory Age
Inventory Age - 1-2 Years	Inventory Onhand Quantity between 366 to 730 Days of Inventory Age
Inventory Age - 2-3 Years	Inventory Onhand Quantity between 731 to 1095 Days of Inventory Age
Inventory Age - 3-5 Years	Inventory Onhand Quantity between 1096 to 1825 Days of Inventory Age
Inventory Age - 5+ Years	Inventory Onhand Quantity greater than or equal to 1826 Days of Inventory Age
Unit Cost	Unit cost in primary UOM
Inventory Age Value	Inventory Age Value is the Inventory Onhand Value grouped in different Inventory Age Buckets. This metric is calculated as below; Inventory Age Value is equal to Current Onhand Quantity multiplied by Unit Cost
Expired Lot Value	Expired Value is equal to Expired Quantity multiplied by Unit Cost
Inventory Age Value - Under 30 Days	Inventory Age Value less than 30 Days of Inventory Age
Inventory Age Value - 31-60 Days	Inventory Age Value between 31 to 60 Days of Inventory Age
Inventory Age Value - 61-90 Days	Inventory Age Value between 61 to 90 Days of Inventory Age
Inventory Age Value - 91-180 Days	Inventory Age Value between 91 to 180 Days of Inventory Age
Inventory Age Value - 181-365 Days	Inventory Age Value between 181 to 365 Days of Inventory Age
Inventory Age Value - Under 7 Days	Inventory Age Value less than 7 Days of Inventory Age
Inventory Age Value - 8-14 Days	Inventory Age Value between 8 to 14 Days of Inventory Age
Inventory Age Value - 15-21 Days	Inventory Age Value between 15 to 21 Days of Inventory Age
Inventory Age Value - 22-28 Days	Inventory Age Value between 22 to 28 Days of Inventory Age
Inventory Age Value - 29-91 Days	Inventory Age Value between 29 to 91 Days of Inventory Age
Inventory Age Value - 92-365 Days	Inventory Age Value between 92 to 365 Days of Inventory Age
Inventory Age Value - 1+ Year	Inventory Age Value greater than equal to 366 Days of Inventory Age
Inventory Age Value - 1-2 Years	Inventory Age Value between 366 to 730 Days of Inventory Age
Inventory Age Value - 2-3 Years	Inventory Age Value between 731 to 1095 Days of Inventory Age
Inventory Age Value - 3-5 Years	Inventory Age Value between 1096 to 1825 Days of Inventory Age
Inventory Age Value - 5+ Years	Inventory Age Value greater than or equal to 1826 Days of Inventory Age

Inventory - Inventory Balances

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Onhand Quantity	This metric shows inventory quantity for a given period in primary unit of measure.
Secondary Onhand Quantity	This metric shows inventory quantity for a given period in secondary unit of measure.
Reservable Onhand Quantity	This metric shows reservable Onhand inventory quantity calculated as difference between total reservable Onhand Quantity from all reservable subinventories and Reserved Quantity in primary unit of measure.
Current Onhand Quantity	This metric shows current inventory quantity in primary unit of measure.
Receiving Quantity	This metric shows the quantity received in the receiving Inventory organization but not putaway to the storage location.
Inbound Quantity	This metric shows Inbound quantities which includes Approved Purchase Orders, Advance Shipment Notice, Intransit shipment via Transfer Order, Intransit shipment via Interorganization Transfers, and Internal Requisitions.
In-Transit Quantity	This metric shows In-transit quantities which includes In-transit shipment via Transfer Orders and In-transit shipment via Inter-organization Transfers.
Consigned Quantity	This metric shows Consigned Inventory quantity which are received against consigned purchase orders or transfered to consigned explicitly.
Current Secondary Onhand Quantity	This metric shows current inventory quantity in secondary unit of measure.
Secondary Receiving Quantity	This metric shows the quantity received in secondary unit of measure in the receiving Inventory organization but not putaway to the storage location.
Secondary Consigned Quantity	This metric shows Consigned Inventory quantity in secondary unit of measure which are received against consigned purchase orders or transfered to consigned explicitly.
Historic Onhand Quantity	This metric shows Historic Inventory Balances for a given period in Primary Unit of Measure.
Historic Secondary Onhand Quantity	This metric shows Historic Inventory Balances for a given period in Secondary Unit of Measure.

Inventory - Inventory Receipts

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Receipt Headers Count	This metric is calculated as the count of distinct receipt headers.
Receipt Lines Count	This metric is calculated as the count of distinct receipt lines.
Order Count	This metric is calculated as the count of distinct orders.
Order Line Count	This metric is calculated as the count of distinct order lines.
Received Lines On Time %	This metric is calculated as the count of lines received on time divided by the count of receipt lines.
Received Lines Late %	This metric is calculated as the count of lines received late divided by the count of receipt lines.
Received Lines Early %	This metric is calculated as the count of lines received early divided by the count of receipt lines.
Receipt Lines with Correction Count	This metric is calculated as the count of receipt lines with at least one correction transaction.
Receipt Lines with Correction %	This metric is calculated as the corrected receipt count divided by the receipt line count.
Receipt Lines Rejected Count	This metric is calculated as the count of receipt lines with the rejected quantity greater than zero.
Receipt Lines Rejected %	This metric is calculated as the rejected receipt count divided by the receipt lines count.
Receipt Lines Accepted Count	This metric is calculated as the count of receipt lines with the accepted quantity greater than zero.
Receipt Lines Accepted %	This metric is calculated as the accepted receipt count divided by the receipt lines count.
Receipt Lines Returned Count	This metric is calculated as the count of receipt lines with the returned quantity greater than zero.
Receipt Lines Returned %	This metric is calculated as the receipt returned count divided by the receipt lines count.
Received Quantity	This metric is calculated as the sum of received quantity in primary, secondary, and transaction UOM.
Accepted Quantity	This metric is calculated as the sum of accepted quantity in primary, secondary, and transaction UOM.
Delivered Quantity	This metric is calculated as the sum of delivered quantity in primary, secondary, and transaction UOM.
Rejected Quantity	This metric is calculated as the sum of rejected quantity in primary, secondary, and transaction UOM.
Returned Quantity	This metric is calculated as the sum of retuned quantity in primary, secondary, and transaction UOM.
Shipped Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Received Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Accepted Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Delivered Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Rejected Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Returned Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Shipped Quantity	This metric is calculated as the sum of shipped quantity in primary, secondary, and transaction UOM.
Receipt Headers Count	This metric is calculated as the count of distinct receipt headers.
Receipt Lines Count	This metric is calculated as the count of distinct receipt lines.
Order Count	This metric is calculated as the count of distinct orders.
Order Line Count	This metric is calculated as the count of distinct order lines.
Received Lines On Time %	This metric is calculated as the count of lines received on time divided by the count of receipt lines.
Received Lines Late %	This metric is calculated as the count of lines received late divided by the count of receipt lines.
Received Lines Early %	This metric is calculated as the count of lines received early divided by the count of receipt lines.
Receipt Lines with Correction %	This metric is calculated as corrected receipt count divided by receipt line count.
Receipt Lines Rejected %	This metric is calculated as rejected receipt count divided by receipt lines count.
Receipt Lines Accepted %	This metric is calculated as accepted receipt count divided by receipt lines count.
Receipt Lines Returned %	This metric is calculated as receipt returned count divided by receipt lines count.
Receipt Lines with Correction Count	This metric is calculated as count of receipt lines with at least one correction transaction.
Receipt Lines Rejected Count	This metric is calculated as count of receipt lines with rejected quantity greater than zero.
Receipt Lines Accepted Count	This metric is calculated as count of receipt lines with accepted quantity greater than zero.
Receipt Lines Returned Count	This metric is calculated as count of receipt lines with returned quantity greater than zero.
Post Processing Time	This metric is calculated as average difference between deliver date and receipt date.
Processing Time	This metric is calculated as average difference between receipt date and Transfer Order creation date or PO approval date
Transportation Days	This metric is calculated as average difference between receipt header creation date and shipment date for advance shipment notice based receipts Applicable for ASN based shipment only.
ASN Receipts %	This metric is calculated as count of advanced shipment notice based receipts divided by count of receipt headers.
Receivng Efficiency	This metric helps to measure the receiving warehouse operator productivity.
Receiving Cycle Time	This metric is calculated as average difference between deliver date and receipt date
Consumed Quantity	This metric is calculated as sum of consumed quantity.
Purchase Order Schedule Count	Count of distinct purchase order schedule.
Received Amount for Fixed Services	This metric is the received amount for fixed services in analytics and document currency.
Received Amount for Fixed Services	This metric is the received amount for fixed services in document currency.
Returned Quantity Percentage	This metric is computed as Returned Quantity by Received Quantity in percentage.

Inventory - Inventory Transactions

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Issue Quantity	This metric is calculated as sum of issue quantity based on primary unit of measure.
Receipt Quantity	This metric is calculated as sum of receipt quantity based on primary unit of measure.
Primary Quantity	This metric is calculated as sum of primary quantity.
Secondary Quantity	This metric is calculated as sum of secondary quantity.
Transaction Quantity	This metric is calculated as sum of transaction quantity.
Consignment Received Quantity	This metric is calculated as sum of consignment received quantity.
Consignment Transferred Quantity	This metric is calculated as sum of consignment transferred quantity.

Inventory - Inventory Turns (Preview)

The fact folder in this subject area shows the metrics details below.

Metric	Metric Definition
Inventory Onhand Quantity	This metric shows current inventory quantity in primary unit of measure.
Inventory Turns	This metric is calculated as below Inventory Turns is equal to Total COGS for the year or Time Period divided by ((Cumulative Average Cost i.e Sum Onhand Value for the Time Period divided by Sum Onhand Quantities for the Time Period) multiplied by Onhand Quantity At the End of Time Period)
Inventory Turns - Period End Cost	This metric is calculated as below Inventory Turns - Period End Cost is equal to Total COGS for the Time Period divided by Inventory Value at the end of Time Period
Inventory Turns - Average Cost	This metric is calculated as below Inventory Turns - Average Cost is equal to Total COGS for the Time Period divided by(Average Cost of Beginning and End Of Time Period multiplied by Onhand Quantity At the End of Time Period)
Days in Inventory	This metric is calculated as below Days in Inventory is equal to [(Average Cost of Beginning and End Of Time Period multiplied by Onhand Quantity At the End of Time Period) divided by Total Cost of Goods Sold] multiplied by Number of Days for the selected time period
Sales Quantity	This metric is Sales Quantity in primary UOM.
Fast Moving Quantity	Items are classified as 'Fast Moving' based on the 'Cumulative Annual Usage % ' Reporting configuration parameter. Example: If Cumulative annual usage value(%) is between 0 to 90% , classify the item as Fast (F).
Slow Moving Quantity	Items are classified as 'Slow Moving' based on the 'Cumulative Annual Usage % ' Reporting configuration parameter. Example: If Cumulative annual usage value(%) is between 90 to 97% , classify the item as Slow (S)
Non Moving Quantity	Items are classified as 'Non Moving' based on the 'Cumulative Annual Usage % ' Reporting configuration parameter. Example: If Cumulative annual usage value(%) is between 97 to 100% , classify the item as Non-moving (N).
Excess Quantity	Excess Quantity is the difference between Current Onhand Quantity and Sales Quantity for an year (or given period)
Obsolete Quantity	Obsolete inventory is the excess/dead inventory which could have reached the end of its life cycle. Obsolete Quantity shows the Current Onhand Quantity for items where the Sales Quantity for an year (or given period) is equal to 0
Unit Cost	Unit cost in primary UOM.
Fast Moving Value	This metric is calculated as below Fast Moving Value is equal to Fast Moving Quantity multiplied by Unit Cost
Slow Moving Value	This metric is calculated as below Slow Moving Value is equal to Slow Moving Quantity multiplied by Unit Cost
Non Moving Value	This metric is calculated as below Non Moving Value is equal to Non Moving Quantity multiplied by Unit Cost
Excess Value	This metric is calculated as below Excess Value is equal to Excess Quantity multiplied by Unit Cost
Obsolete Value	This metric is calculated as below Obsolete Value is equal to Obsolete Quantity multiplied by Unit Cost
Cost of Goods Sold	Aggregated value of Cost of Goods Sold.
Sales Value	Sales value in global currency and primary UOM.
Annual Usage %	This metric is calculated as below Annual Usage % is equal to Sales value of the Item divided by Total Sales Value multiplied by 100
Cumulative Annual Usage %	Cumulative Annual Usage Percentage.
Current Inventory Onhand Value	This metric is calculated as Current Onhand Quantity multiplied by latest Unit Cost for an Item.

Inventory - Picking and Shipping

The fact folders in this subject area show the metrics details described in the table.

Metric	Metric Definition
Requested Quantity	This metric is calculated as the sum of Requested Quantity for picking in transaction, primary and secondary UOM.
Picked Quantity	This metric is calculated as the sum of Picked Quantity in transaction, primary and secondary UOM.
On Time Picked Lines	This metric is the count of Shipment Lines which are Picked on time and is calculated with below logic: 1. If Scheduled Ship Date is lesser than Movement Request Creation Date, then Picked Date minus Movement Request Creation Date should be less than one day. 2. If Scheduled Ship Date is greater than or equal to Movement Request Creation Date, then Picked Date minus Scheduled Ship Date should be less than one day.
Late Picked Lines	This metric is the count of Shipment Lines which are Picked Late and is calculated with below logic: 1. If Scheduled Ship Date is lesser than Movement Request Creation Date, then Picked Date minus Movement Request Creation Date should be greater than or equal to one day. 2. If Scheduled Ship Date is greater than or equal to Movement Request Creation Date, then Picked Date minus Scheduled Ship Date should be greater than or equal to one day.
Staged Quantity	This metric is calculated as the sum of Staged Quantity for all the Shipment Lines where Line Status is equal to Staged in transaction, primary, and secondary UOM.
Shipped Quantity	This metric is calculated as the sum of Shipped quantity for all the Shipment Lines where Line Status is equal to Interfaced and Shipped in transaction, primary, and secondary UOM.
Shipped Early Quantity	This metric is calculated as the sum of Shipped Quantity for all the Shipment Lines where Actual Ship Date is less than Scheduled Ship Date in transaction, primary, and secondary UOM.
Shipped Late Quantity	This metric is calculated as the sum of Shipped Quantity for all the Shipment Lines where Actual Ship Date is greater than Scheduled Ship Date in transaction, primary, and secondary UOM.
Back Ordered Quantity	This metric is calculated as the sum of Requested Quantity for all the Shipment Lines where Line Status is equal to Backordered in transaction, primary, and secondary UOM.
Canceled Quantity	This metric is calculated as the sum of Canceled Quantity in transaction, primary, and secondary UOM.
Release to Ship Cycle Days	This metric is calculated as Actual Ship Date minus Movement Request Creation Date.
Orders Picked Not Shipped	This metric is calculated as the count of all the Orders where the Shipment Line status is equal to Staged (even if one Shipment Line in an Order is in Staged status).
Shipment Lines Picked Not Shipped	This metric is calculated as the count of Shipment Lines where the Shipment Line status is equal to Staged.
Volume	This metric shows Volume of the Shipment.
Gross Weight	This metric shows Gross Weight of the Shipment.
Net Weight	This metric shows Net Weight of the Shipment.
Closed Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Interfaced and Shipped.
Open Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Not Shipped.
Number of Shipments Ready-to-Ship	This metric is calculated as the count of Shipment Lines with Line Status is equal to Staged and Shipment Number is not NULL.
On Time Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Interfaced, Shipped and Actual Ship Date is less than or equal to Schedule Ship Date.
Late Shipments	This metric is calculated as the count of Shipment Lines with Line Status is equal to Interfaced, Shipped and Actual Ship Date is greater than Schedule Ship Date.
Shipments Past Due	This metric is calculated as the count of Shipment Lines with Line Status is equal to Staged and Schedule Ship Date is less than Current Date.
Shipment Due Today and Next Day	This metric is calculated as the count of Shipment Lines with Line Status is equal to Staged and Schedule Ship Date is equal to Current Date OR (Current Date + 1).
Lines Assigned to Shipment	This metric is calculated as the count of Shipment lines associated with a Shipment.
Total Shipments	This metric is computed as sum of Open Shipments and Closed Shipments.
Closed Shipments Percentage	This metric is computed as Closed Shipments by Total shipments expressed in percentage.
Open Shipments Percentage	This metric is computed as Open Shipments by Total shipments expressed in percentage.
On Time Shipments Percentage	This metric is computed as On Time Shipments by Closed Shipments expressed in percentage.
Late Shipments Percentage	This metric is computed as Late Shipments by Closed shipments expressed in percentage.
Shipments Past Due Percentage	This metric is computed as Shipments past due by Open Shipments expressed in percentage.
Picking Cycle Time	This metric is computed as average of Picked Date minus Pick Wave creation date.
Ship Cycle Time	This metric is computed as average of Actual Ship Date minus Picked date.
Total Picked Lines	This metric is computed as sum of On Time Picked Lines and Late Picked Lines.
On Time Picking Percentage	This metric is computed as On Time Picked Lines by Total Picked Lines expressed in percentage.
Shipping Cost	This metric shows Global shipping cost for each shipping cost type.
Total Shipping Cost	This metric shows Total Shipping Cost is the aggregated amount of all the User defined Shipping cost types of all categories.
Shipment Level Shipping Cost	This metric shows Global shipping cost for each shipping cost type at shipment level.
Shipment Level Total Shipping Cost	This metric shows Total Shipping Cost is the aggregated amount of all the User defined Shipping cost types of all categories at shipment level.
Packing Unit Level Shipping Cost	This metric shows Global shipping cost for each shipping cost type at Packing Unit level.
Packing Unit Level Total Shipping Cost	This metric shows Total Shipping Cost is the aggregated amount of all the User defined Shipping cost types of all categories at Packing Unit level.

Inventory - Transfer Orders

These metrics will be used in the Analytics Currency (AC) and Document Currency (DC) fact folder for the Subject Area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Transfer Order Creation Date to convert to the analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric	Metric Definition
Transfer Order Amount	This metric is the calculated value of Transfer Order amount.
Total Tax	This metric is the calculated value of Total Tax on Transfer Orders.
Total Transfer Order Amount	This metric is the calculated value of Transfer Order amount inclusive of total tax.
Unit Price	This is the unit price on Transfer Order Lines.
Lines Amount	This metric is the calculated value of Transfer Order Lines amount.
Lines Tax	This metric is the calculated value of Transfer Orders Lines tax.
Total Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Requested Quantity.
Shipped Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Shipped Quantity.
Received Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Received Quantity.
Delivered Lines Amount	This metric is calculated as the total line amount inclusive of all tax for the Delivered Quantity.
Transfer Orders Count	This metric is calculated as the count of distinct Transfer Order Headers.
Transfer Order Lines Count	This metric is calculated as the count of distinct Transfer Order Lines.
Open Transfer Orders Count	This metric is calculated as the count of distinct Transfer Orders where the Transfer Order Status is Open.
Open Transfer Order Lines Count	This metric is calculated as the count of all Transfer Order Lines where the Transfer Order Line Status is Open.
Return Transfer Order Lines Count	This metric is calculated as the count of Return Transfer Order Lines where the Transfer Order Line Status is Open and the Transaction Origin type is Return.
Closed Transfer Order Lines Count	This metric is calculated as the count of all Transfer Order Lines where the Transfer Order Line Status is Closed.
Cancelled Transfer Order Lines Count	This metric is calculated as the count of all Transfer Order Lines where the Transfer Order Line Status is Cancelled.
Ordered Quantity	This metric is calculated as the sum of Requested Quantity in primary and secondary UOM.
Return Transfer Order Delivered Quantity	This metric is calculated as the sum of Delivered Quantity where Transaction Origin type is Return in primary and secondary UOM.
Cancelled Quantity	This metric is calculated as the sum of Cancelled Quantity in primary and secondary UOM.
Shipped Quantity	This metric is calculated as the sum of Shipped Quantity in primary and secondary UOM.
Received Quantity	This metric is calculated as the sum of Received Quantity in primary and secondary UOM.
Delivered Quantity	This metric is calculated as the sum of Delivered Quantity in primary and secondary UOM.