Overview
The overall average landed cost for each product, computed daily using cumulative total stock value divided by cumulative total quantity on hand.
Useful for cost of goods sold calculations, profit margin analysis, and pricing decisions — e.g., comparing the average cost of a product against its selling price to determine profitability, or tracking how costs have changed over time.
Data Dictionary
Field | Type | Notes |
Average Landed Cost | Number | Computed daily using cumulative total stock value divided by cumulative total quantity on hand, Derived from dividing Calculated Stock Value and Calculated Quantity On Hand |
Calculated Unit Cost | Number | Derived from dividing Movement Value and Movement |
Created | Datetime | Created timestamp from source record |
Date | Date | |
Movement Date | Date | Date the stock movement occurred. Per source: assembly date for assemblies; dispatch date for shipments; received date for purchase orders; delivery date for transfers; adjustment/credit/return date for adjustments and returns |
Product Description | Text | Derived from cleaning Product Description |
Product GUID | Text | The Unique ID of a Product, API: Product.Guid |
Source | Text | The event that caused the stock movement. One of {Assembly Wastage, Component Product Assembly, Customer Return, Finished Product Assembly, Opening Position, Purchase Order, Shipment, Stock Adjustment, Supplier Return, Warehouse Transfer} |