Warehouse wise Item Balance Age and Value

Warehouse wise Item Balance Age and Value combines two questions into one table: for each item, how many units sit in each warehouse and how much they are worth, plus how old that stock is on average. Quantity and value come from Stock Ledger Entries up to the To Date, while the age comes from the FIFO queue, the same method Stock Ageing uses, so the two reports agree. The layout has one column per warehouse, which makes it the easiest view for deciding which branch is holding stale goods and should transfer them to where they sell. It is a planning report; nothing in it posts.

Average age = sum over FIFO lots of (lot qty x days since receipt) / total qty, per item and warehouse

1. 01Go to Stock > Warehouse wise Item Balance Age and Value.
2. 02Set Company, From Date and To Date.
3. 03Filter by Item Group, Brand or a single Item if the table is wide.
4. 04Read the per warehouse quantity columns, then Average Age and Total Value.
5. 05Move old stock from a slow warehouse to a selling one with a Material Transfer.

Open to find which warehouse holds the oldest or most expensive stock.

Shows which of the 5 warehouses holds the oldest and most valuable part of the Rs 4,50,000 opening stock.