Hello, I want to create a new doctype where I have put a field for erpnext to fetch sales order list but I only want to see those sales orders which are not yet completed. Can someone please help me out with this?
Something like this?
frappe.db.get_all('Sales Order', {'status': ('NOT IN', ['Completed'])}, '*')
Oh okay got it. Thanks for the super fast reply!