BRAccount
Dashboard
Dashboard charts

Warehouse wise Stock Value

Custom chart: stock value per warehouse, from Bin.

In detail

This custom chart reads every Bin, sums the stock value per warehouse and draws one bar per warehouse, so you can compare godowns and branches. The demo shows five bars for Stores, Finished Goods, Work In Progress, Goods In Transit and Koteshwor Store, summing to Rs 4,50,000. It is a snapshot at valuation rate. Each warehouse can map to its own stock account, so these bars should agree with the Stock In Hand accounts in the Balance Sheet.

Formula

Each bar = Sum of stock_value on Bin for that warehouse, today

How to record it in BRAccount

  1. 01Go to Stock; the chart sits beside Stock Value by Item Group.
  2. 02Hover a bar to read the warehouse and its value.
  3. 03There is no timespan on this snapshot chart; press refresh after posting stock entries.
  4. 04Click the filter icon to limit it to one company.
  5. 05Open Stock > Warehouse Wise Stock Balance for the item level detail of any bar.

When to use it

Compare godowns and branches.

Example from the demo books

Five bars summing to Rs 4,50,000.