{
 "add_total_row": 0, 
 "apply_user_permissions": 1, 
 "creation": "2013-05-03 17:48:46", 
 "disabled": 0, 
 "docstatus": 0, 
 "doctype": "Report", 
 "idx": 3, 
 "is_standard": "Yes", 
 "modified": "2018-02-13 04:56:57.040163", 
 "modified_by": "Administrator", 
 "module": "Manufacturing", 
 "name": "Issued Items Against Work Order", 
 "owner": "Administrator", 
 "query": "select\n    ste.work_order as \"Work Order:Link/Work Order:120\",\n    ste.posting_date as \"Issue Date:Date:140\",\n    ste_item.item_code as \"Item Code:Link/Item:120\",\n\tste_item.description as \"Description::150\",\n\tste_item.transfer_qty as \"Qty:Float:100\",\n\tste_item.stock_uom as \"UOM:Link/UOM:80\",\n\tste_item.amount as \"Amount:Currency:120\",\n\tste_item.serial_no as \"Serial No:Link/Serial No:80\",\n\tste_item.s_warehouse as \"Source Warehouse:Link/Warehouse:120\",\n\tste_item.t_warehouse as \"Target Warehouse:Link/Warehouse:120\",\n\two.production_item as \"Finished Goods:Link/Item:120\", \n\tste.name as \"Stock Entry:Link/Stock Entry:120\",\n\tste.company as \"Company:Link/Company:\",\n\t(select bin.projected_qty from `tabBin` bin \n\t\t\twhere  bin.item_code= ste_item.item_code and bin.warehouse= ste_item.s_warehouse) as \"Projected Quantity as Source:Float:200\"\nfrom\t`tabStock Entry` ste, `tabStock Entry Detail` ste_item, `tabWork Order` wo\nwhere\n\tifnull(ste.work_order, '') != '' and ste.name = ste_item.parent \n\tand ste.work_order = wo.name and ste.docstatus = 1\n\tand ste.purpose = 'Material Transfer for Manufacture'\norder by ste.posting_date, ste.work_order, ste_item.item_code", 
 "ref_doctype": "Work Order", 
 "report_name": "Issued Items Against Work Order", 
 "report_type": "Query Report", 
 "roles": [
  {
   "role": "Manufacturing User"
  }, 
  {
   "role": "Stock User"
  }
 ]
}