Various actions can lead to changes in product stock. Some actions such as purchase orders and retail returns result in stock inflow. Other actions such as retail sales and consumption result in stock outflow. This data source brings in all the actions that result in a change of stock for both retail and consumable products. It is organized in a ledger format, calling out both inflows and outflows. Cost of goods sold and Cost of inventory on hand are also calculated. Two methods of costing are supported:
First-In First-Out: Assumes that any sale or consumption of a product is from the oldest batch on hand.
Weighted Average: Maintains a pool of cost for all units of a particular product. Any purchase is added to the pool of cost, and the pool of cost is divided by all units on hand to arrive at an average cost per unit.
Important: The Inventory data source in Analytics is only visible if the setting to restrict edits of past financial and inventory transactions is enabled. After the setting is enabled, it takes a few days for the data to be synced into the analytics data source. For information on how to enable this setting, refer Restrict Edits to Financial and Inventory Data: Overview.
This data source is organized in a ledger format calling out both inflows and outflows. With every inflow and outflow, the available stock is calculated. Due to this model, edits to past financial and inventory transactions cause all the data post that date to get updated.
Stock on hand of a particular product over time
Stock changes of a particular product in a given interval of time
Cost of goods sold as per 2 methods of costing: First-In First-Out and Weighted Average methods
Cost of goods on hand as per 2 methods of costing: First-In First-Out and Weighted Average methods
Value lost or gained during audits