Get stock balance

Quantity and stock value of one item in one warehouse on a date.

GET https://cotlet.dev/api/v1/erpnext/items/{item_code}/stock-balance

read

Returns the quantity and stock value for one item in one warehouse, the same two figures as Quick Stock Balance in ERPNext (Stock > Tools). Without a date it returns today. It reads one item and one warehouse per call; to check a whole order, call it once per line.

Parameters

Parameters: get_stock_balance
NameTypeDescription
item_code string required string Item code from list_items.
warehouse string required string Warehouse name from your site.
date string string YYYY-MM-DD. Default: today.

Request

cURL
curl "https://cotlet.dev/api/v1/erpnext/items/item%20code/stock-balance?warehouse=warehouse" \
  -H "Authorization: Bearer $COTLET_API_KEY"
Python
result = client.call("erpnext", "get_stock_balance", {"item_code":"item code","warehouse":"warehouse"})
Node.js
const result = await cotlet.call('erpnext', 'get_stock_balance', {"item_code":"item code","warehouse":"warehouse"});
CLI
cotlet call erpnext get_stock_balance --data '{"item_code":"item code","warehouse":"warehouse"}'

Example response

JSON

{
  "item_code": "WIDGET-100",
  "warehouse": "Main - AC",
  "date": "2026-10-14",
  "quantity": 42,
  "stock_value": 1260
}

Sign in once. Your agent does the rest.

Sign up and add the apps you need. Free 7-day trial with 2,000 credits, no card needed.