Item Warehouse and Stock Balance REST API

Amir_Hakim · December 19, 2017, 8:56am

Hello,

I need to get the stock balance of items in each warehouse, Using REST Apis, is that available ?

Thanks in advance,

umair · December 19, 2017, 9:47am

ERPNext has REST API, and Stock BIN has the information you need.

https://frappe.github.io/frappe/user/en/guides/integration/rest_api.html

Check code of Stock Projected Qty report to trace a document based on which item’s stock balance is located.

Amir_Hakim · December 19, 2017, 10:31am

Stock Projected Qty is a report, Is there a way to access this report using REST API ?
What’s the DOC Type shall I use to get the item qty per warehouse ?

Thanks,

umair · December 19, 2017, 11:49am

Bin.

github.com

frappe/erpnext/blob/develop/erpnext/stock/report/stock_projected_qty/stock_projected_qty.py

# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: GNU General Public License v3. See license.txt


import frappe
from frappe import _
from frappe.utils import flt, today
from pypika.terms import ExistsCriterion

from erpnext.accounts.doctype.pos_invoice.pos_invoice import get_pos_reserved_qty
from erpnext.stock.utils import (
	is_reposting_item_valuation_in_progress,
	update_included_uom_in_report,
)


def execute(filters=None):
	is_reposting_item_valuation_in_progress()
	filters = frappe._dict(filters or {})
	include_uom = filters.get("include_uom")

This file has been truncated. show original

Amir_Hakim · December 19, 2017, 12:27pm

Yes got it, Thanks alot

umair · December 19, 2017, 5:52pm

Thanks.

If you used ERPNext and liked it, please refer us on these sites.

https://www.capterra.com/p/164441/ERPNext

http://alternativeto.net/software/erpnext/

https://www.getapp.com/operations-management-software/a/iwebnotes/