I need to clearify my Inventory Quantity

nabinhait · January 23, 2017, 6:59am

You can use get_stock_balance function, to get stock qty on any date for a specific warehouse and item.

frappe/erpnext/blob/develop/erpnext/stock/utils.py#L49


      
          
          
	if item_code:
          		conditions += " and `tabBin`.item_code = %(item_code)s"
          
          
		values["item_code"] = item_code
          
          
	query = (
          		"""select sum(stock_value) from `tabBin`, `tabItem` where 1 = 1
          		and `tabItem`.name = `tabBin`.item_code and ifnull(`tabItem`.disabled, 0) = 0 %s"""
          		% conditions
          	)
          
          
	stock_value = frappe.db.sql(query, values)
          
          
	return stock_value
          
          

          
def get_stock_value_on(warehouse=None, posting_date=None, item_code=None):
          	if not posting_date:
          		posting_date = nowdate()