Repost Stock Values

mehta_akshay · February 3, 2017, 2:57pm

Is it possible to re-calculate and re-post each and every stock ledger entry (including valuation rate, incoming rate, etc) for a particular item, through server side code?

If yes can anybody point out the code.

rohit_w · February 4, 2017, 8:37am

Hi @mehta_akshay

Check below code

github.com

frappe/erpnext/blob/develop/erpnext/controllers/stock_controller.py#L304-L325


      
          
          
		return list(items), list(warehouses)
          
          
	def get_stock_ledger_details(self):
          		stock_ledger = {}
          		stock_ledger_entries = frappe.db.sql(
          			"""
          			select
          				name, warehouse, stock_value_difference, valuation_rate,
          				voucher_detail_no, item_code, posting_date, posting_time,
          				actual_qty, qty_after_transaction
          			from
          				`tabStock Ledger Entry`
          			where
          				voucher_type=%s and voucher_no=%s and is_cancelled = 0
          		""",
          			(self.doctype, self.name),
          			as_dict=True,
          		)

This file has been truncated. show original

mehta_akshay · February 4, 2017, 12:42pm

@rohit_w Thanks

Will this re-post GLE & SLE both or just the GLE?