Billkro

Task #1054

Updated by Deeksha Singh about 2 months ago

**Task Description** 

 Validate how POS handles inventory items when the **same item is purchased multiple times at different prices** and ensure proper unit configuration for inventory consumption. 

 **Scenario** 
 * 

 1. First purchase: 

    * Item: Bottle 
    * Quantity: 10 bottles for 
    * Purchase Price: ₹100 → total 
    * Cost per bottle: ₹10 per bottle 
 * 

 2. Second purchase: 

    * Item: Bottle 
    * Quantity: 10 bottles for 
    * Purchase Price: ₹110 → total 
    * Cost per bottle: ₹11 per bottle 
 * Then create a 

 3. A sales order is created for the bottle. Bottle item. 

 **Requirements** **Unit Configuration** 

 * **Consumption Unit should be mandatory** for every inventory item. 
 * Add/display both: 

   * **Purchase Unit** 
   * **Consumption Unit** 
 * The system should support conversion between Purchase Unit and Consumption Unit where applicable. 
 * Inventory consumption and costing should be calculated based on the **Consumption Unit**. 
 * Validate that the user cannot save an inventory item without selecting a Consumption Unit. 

 ## Points to Verify how 

 * How does POS calculates calculate the item cost **cost per quantity** when the same inventory item is purchased at has different prices. 

 * Which purchase cost will POS pick during consumption/sale? prices? 
 * Does it follow FIFO, Weighted POS use: 

   * **FIFO** – ₹10 cost first, then ₹11 
   * **Weighted Average Cost, Latest Cost** – ₹10.50 per bottle 
   * **Latest Purchase Cost, or Cost** – ₹11 
   * Or another configured inventory costing method? 
 * How will the cost per quantity be calculated? When stock is sold/consumed, which purchase batch/cost is consumed? 
 * How will COGS and is **COGS / profit margin be margin** calculated? 
 * Verify the Stock **Stock Ledger / Movement History History** after the sale. 
 * Verify that the remaining correct **Purchase Unit → Consumption Unit conversion** is applied. 
 * Confirm whether the system maintains separate purchase batches or combines them into a single inventory value quantity. 

 **Acceptance Criteria** 

 * Consumption Unit is **mandatory** while creating/editing an inventory item. 
 * Both **Purchase Unit** and **Consumption Unit** are available for configuration. 
 * Correct unit conversion is applied during inventory consumption. 
 * Cost per consumption unit is calculated correctly. 
 * Different purchase prices are handled according to the configured costing method. 
 * Stock quantity, inventory value, COGS, and profit margin are updated correctly after consumption. sales/consumption. 
 * Stock Ledger / Movement History reflects the correct quantity, unit, and cost. 

Back