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