How much stock do we have, and what did it cost? Read stock on hand with cost, by branch or for the whole company
“How much stock do we have, and what did it cost?” Open the Stock Availability applet, choose the locations you care about — one branch’s locations, or all of them — and read the quantity and cost columns side by side. When a figure looks wrong, the details screen shows which documents are holding stock back. Allow about ten minutes the first time.
This page is for the stock controller, the branch manager and whoever in accounts is asked “what is it worth?”.
Meet GadgetSphere
GadgetSphere’s Penang branches (GS-PEN-01 to GS-PEN-04) say they are short of wireless earbuds, while head office believes there are plenty. You want the earbuds’ quantity and cost at each Penang location, and the reason the branch sees fewer than head office expects.
Before you start
- You can open Stock Availability. The listing needs the applet’s stock-availability read permission (a login holding the tenant-wide owner or admin permission passes anyway).
- Know your locations. The listing works by location, not by branch: a branch’s stock is the stock in its locations. Know which locations belong to the branch you want.
- Cost columns may be hidden. The applet’s own settings can hide each cost column, and a permission can show it again to particular users. If you see quantities and no cost, ask your administrator; the data is not missing.
Step 1: Run the listing for the locations you want
Stock Availability → Stock Availability
The listing opens as the Stock Availability Report. Location is required and takes several values: pick every location of the branch, or all locations for the whole company. Narrow it further by Item Code, item type, status or category if you like, then run it.
Step 2: Read the quantity and cost columns
Each row is an item at a location. Read:
- Stock Balance — the physical balance recorded at that location.
- Adj Qty — the quantity on open documents: open sales orders lower what you can promise, goods received but not yet invoiced raise it. It is shown without its sign.
- Available Qty — Stock Balance plus that adjustment, less any stock reserved: what a new order can still take. When you want to know what you can sell, read Available Qty, not Stock Balance — and where an item has both an open sales order and an uninvoiced receipt at the same location, read it on the details screen (Step 3) with only the goods-received and sales-order balances shown, because the listing can show it too high (10 on the shelf, an order for 3 and a receipt for 5 can read 18 instead of 12).
- The cost columns — Company Avg Cost, Location Avg Cost, Last Purchase Cost, and FIFO and LIFO cost where shown.
In the example, the four Penang locations show the earbuds’ Stock Balance and Available Qty side by side — and the gap between them is your first clue.
Step 3: Find out what is holding stock back
Stock Availability → Stock Availability Details → the item
The details screen breaks an item’s figure down. Its Optional field starts with several options ticked that hide balances — goods received but not yet invoiced, open purchase and sales orders, delivery orders, and drafts. Untick them to see those quantities, and the difference usually explains itself. Each one you untick is added into the figure: open purchase orders and draft receipts too, so untick only the ones you are asking about. Open the item and use its Stock Movement tab for the item’s movement history.
For one serialised unit, use Trace Serial No to follow its movements, or Serial Number Balance to see where it is now.
Step 4: See stock in transit by location
Stock Report → Stock Summary Report By Location
When stock is moving between branches, the Stock Summary Report By Location has a Stock In Transit column. It counts what is still open on outbound transfers — goods sent that no inbound transfer has taken yet — against the sending location, plus the lines of inbound transfers still in draft.
Those goods are no longer in the sending location’s Stock Balance: finalising the outbound transfer moved them into your company’s stock-in-transit location. In Stock Availability, add that location (its code starts L-SIT) to the Location filter to see them.
What success looks like
You can say, for the item you care about: how many are at each location, how many of those you can actually sell, what they cost, and — if a figure surprised you — which open documents or transfers explain it. For GadgetSphere: the Penang earbuds are on open sales orders and one transfer still in transit from head office.
Common mistakes
- Reading Stock Balance when you mean Available Qty. Stock on an open sales order is still on the shelf and still in Stock Balance, but a new order cannot take it. And because uninvoiced receipts raise Available Qty, it can read higher than the shelf too.
- Looking for a branch filter. There is none; choose the branch’s locations.
- Taking a missing location as zero. The listing shows only balances above zero, so a location at zero or below simply has no row. To see a negative balance, use the details screen.
- Assuming hidden cost columns mean missing data. An applet setting hides them; ask your administrator.
- Expecting the Consignment filter to split your own stock from consignment stock. It filters by the consignment flag on the item, not by who owns the units on the shelf.
- Forgetting stock in transit. Goods on their way between branches sit in the stock-in-transit location, not in the sending or the receiving branch’s locations; the transit report counts them against the sending location.
If it still does not work
Contact BigLedger support with the item code, the locations, the figure you expect and why, a screenshot of the listing with its filters, and the date and time you ran it.
Related documentation
- Stock Availability applet — every menu, column and setting
- Stock transfer — moving stock between branches, and what in transit means
- Stock shows zero but there is stock — when the figure is plainly wrong