[
 {
  "owner": "ashwini@webnotestech.com", 
  "docstatus": 0, 
  "creation": "2012-04-03 12:49:52", 
  "modified_by": "Administrator", 
  "modified": "2012-04-03 12:49:52"
 }, 
 {
  "add_col": "SUM(`tabSales Order Item`.`qty` - `tabSales Order Item`.`delivered_qty`) AS 'Pending Qty'\nSUM((`tabSales Order Item`.`qty` - `tabSales Order Item`.`delivered_qty`)* `tabSales Order Item`.basic_rate) AS 'Pending Amount'", 
  "parent_doc_type": "Sales Order", 
  "module": "Projects", 
  "standard": "Yes", 
  "sort_order": "DESC", 
  "filters": "{'Sales Order\u0001Submitted':1,'Sales Order\u0001Status':'Submitted','Sales Order\u0001Fiscal Year':''}", 
  "doc_type": "Sales Order Item", 
  "name": "__common__", 
  "add_cond": "`tabSales Order Item`.`qty` > `tabSales Order Item`.`delivered_qty`\nIFNULL(`tabSales Order`.`project_name`,\"\")!=\"\"\n`tabSales Order`.order_type = 'Sales'", 
  "doctype": "Search Criteria", 
  "sort_by": "`tabSales Order`.`name`", 
  "page_len": 50, 
  "criteria_name": "Projectwise Pending Qty and Costs", 
  "columns": "Sales Order\u0001ID,Sales Order\u0001Project Name,Sales Order\u0001Customer,Sales Order\u0001Customer Name,Sales Order Item\u0001Item Code,Sales Order Item\u0001Item Name,Sales Order\u0001%  Delivered,Sales Order\u0001% Billed,Sales Order\u0001Sales Order Date,Sales Order\u0001Expected Delivery Date"
 }, 
 {
  "name": "projectwise_pending_qty_and_costs", 
  "doctype": "Search Criteria"
 }
]