💁Agenda of the Video▶️: To share the Online Query's Answer.
🔰Question: How can I get a Report of List of Items which are differentiated by Consumable or Inventory?
📝Answer : Inventory Valuation Report. This is an inbuilt / standard report (and the... Report id is, 1001).
✅ GRN / Shipment (Received Not Invoiced / Shipped Not Invoiced)= Expected or Estimated Cost of Inventory.
➡️Related to Item Ledger Entries (in short; ILE, table).
✅ Invoice = Actual Values or Inventory Cost Posting to G/L (associated General Ledger of Items/Inventory/Stock).
➡️Related to Value Entries (table).
🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸
📍Hint: Closing Stock = Opening Stock / Inputs / GRN + Purchase (increase in the Year) + Positive Adjustment [Less (-) Dispatch + Sales (Decrease in the Year) + Negative Adjustment]. ✅
🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸🔸
