Hello Everyone,
Can you recommend the best way to get Stock Balance via the API
Currently, am using Stock Ledger but I don’t want to get the entire list then sum i want to know if there is DocType in the API i can grab this information from.
Hello Everyone,
Can you recommend the best way to get Stock Balance via the API
Currently, am using Stock Ledger but I don’t want to get the entire list then sum i want to know if there is DocType in the API i can grab this information from.
you should make your custom python file and us below code you will get balance qty for particular item and warehouse.
def getStockBalance(item_code, warehouse):
balance_qty = frappe.db.sql("""select qty_after_transaction from `tabStock Ledger Entry`
where item_code=%s and warehouse=%s and is_cancelled='No'
order by posting_date desc, posting_time desc, name desc
limit 1""",(item_code,warehouse))
return balance_qty[0][0] if balance_qty else 0.0
Thanks you.