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.

Example use-cases

  • 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

Did this answer your question?