[SOLVED] [QUESTION]: Automatic Reorder Levels

cpurbaugh · August 3, 2016, 4:53pm

Are automatic reorder points triggered by projected or actual quantity?

revant_one · August 4, 2016, 3:12pm

I guess, projected_qty

frappe/erpnext/blob/develop/erpnext/stock/reorder_item.py#L40


      
          		where disabled=0"""
          		)
          	)
          	default_company = (
          		erpnext.get_default_company() or frappe.db.sql("""select name from tabCompany limit 1""")[0][0]
          	)
          
          
	items_to_consider = frappe.db.sql_list(
          		"""select name from `tabItem` item
          		where is_stock_item=1 and has_variants=0
          			and disabled=0
          			and (end_of_life is null or end_of_life='0000-00-00' or end_of_life > %(today)s)
          			and (exists (select name from `tabItem Reorder` ir where ir.parent=item.name)
          				or (variant_of is not null and variant_of != ''
          				and exists (select name from `tabItem Reorder` ir where ir.parent=item.variant_of))
          			)""",
          		{"today": nowdate()},
          	)
          
          
	if not items_to_consider:
          		return