{
 "add_total_row": 1, 
 "apply_user_permissions": 1, 
 "creation": "2013-05-03 14:55:53", 
 "disabled": 0, 
 "docstatus": 0, 
 "doctype": "Report", 
 "idx": 3, 
 "is_standard": "Yes", 
 "modified": "2017-02-24 20:08:57.446613", 
 "modified_by": "Administrator", 
 "module": "Buying", 
 "name": "Item-wise Purchase History", 
 "owner": "Administrator", 
 "query": "select\n    po_item.item_code as \"Item Code:Link/Item:120\",\n\tpo_item.item_name as \"Item Name::120\",\n        po_item.item_group as \"Item Group:Link/Item Group:120\",\n\tpo_item.description as \"Description::150\",\n\tpo_item.qty as \"Qty:Float:100\",\n\tpo_item.uom as \"UOM:Link/UOM:80\",\n\tpo_item.base_rate as \"Rate:Currency:120\",\n\tpo_item.base_amount as \"Amount:Currency:120\",\n\tpo.name as \"Purchase Order:Link/Purchase Order:120\",\n\tpo.transaction_date as \"Transaction Date:Date:140\",\n\tpo.supplier as \"Supplier:Link/Supplier:130\",\n        sup.supplier_name as \"Supplier Name::150\",\n\tpo_item.project as \"Project:Link/Project:130\",\n\tifnull(po_item.received_qty, 0) as \"Received Qty:Float:120\",\n\tpo.company as \"Company:Link/Company:\"\nfrom\n\t`tabPurchase Order` po, `tabPurchase Order Item` po_item, `tabSupplier` sup\nwhere\n\tpo.name = po_item.parent and po.supplier = sup.name and po.docstatus = 1\norder by po.name desc", 
 "ref_doctype": "Purchase Order", 
 "report_name": "Item-wise Purchase History", 
 "report_type": "Query Report", 
 "roles": [
  {
   "role": "Stock User"
  }, 
  {
   "role": "Purchase Manager"
  }, 
  {
   "role": "Purchase User"
  }
 ]
}