The reconciled flow of goods at each location is available.
Select F12:Configure while in the Godown/Location Summary Screen
The Godown Summary statement displays the flow of stock: Opening Stock, Goods Inwards, Goods Outward and Closing Stock, at each location.
The statement is quantitatively reconciled, not monetarily, i.e., Opening quantity + Inward Quantity – Outward Quantity = Closing Stock Quantity.
However, this is not true of values because values do not add up in this manner. The Outwards value displays Sale Values, not Cost. The Closing Stock Value is, however, based on Cost and the Cost Method adopted for each item.
Value reconciliation is possible using Consumption figures, instead of Outward Values.
Press F:7 Show Profits to expand the Outwards Column for Consumption and Profit figures. Value Reconciliation is now possible using: Opening Value + Inward Value – Consumption Value = Closing Stock Value.
Columns
Use Columns to view stock balances of the Godowns/Locations on different dates/periods or other options listed in the Auto Columns options.
Even though you have selected a specific Godown/Location for display, you can still bring up information of the other godown(s)/location(s) in columns.
Select New Column or Auto-Column for such a display.
The above report is obtained by selecting:
New Column
Various reports are available from the Stock Item Monthly Summary, including different periodicity and Average stocks. Drill-down an item in the Stock or Godown/Location Summary level to the Item Monthly Summary and use F12: Configure options.
Refer F12: Configure for Material Consumption Summary Report in Job Costing