How to get stock balance of item

shahid_ecit · June 20, 2018, 10:20am

Is there any way to get stock balance of an item

hi,

i am trying to find remaining stock of item.

i don’t want to write any database fetch query

like in stock balance ledger

what i have been tired so far is this


from erpnext.stock.report.stock_ledger.stock_ledger import execute

  def get_stock_ledger():
        filters={"from_date":2018-06-09,"to_date":2018-06-12",item_group:" ",item_code:" "}
        columns, data = execute(filters)
        print data

Output = []
but when i go to stock ledger entry i can see items in my warehouse

nabinhait · June 21, 2018, 7:40am

github.com

frappe/erpnext/blob/master/erpnext/stock/utils.py#L12


      
          # License: GNU General Public License v3. See license.txt
          
          
from __future__ import unicode_literals
          import frappe, erpnext
          from frappe import _
          import json
          from frappe.utils import flt, cstr, nowdate, nowtime
          
          
from six import string_types
          
          
class InvalidWarehouseCompany(frappe.ValidationError): pass
          
          
def get_stock_value_from_bin(warehouse=None, item_code=None):
          	values = {}
          	conditions = ""
          	if warehouse:
          		conditions += """ and warehouse in (
          						select w2.name from `tabWarehouse` w1
          						join `tabWarehouse` w2 on
          						w1.name = %(warehouse)s
          						and w2.lft between w1.lft and w1.rgt

shahid_ecit · June 21, 2018, 7:42am

@nabinhait
thanks for the link

this will help me thanks