{
 "add_total_row": 0, 
 "apply_user_permissions": 1, 
 "creation": "2013-08-20 13:43:30", 
 "disabled": 0, 
 "docstatus": 0, 
 "doctype": "Report", 
 "idx": 3, 
 "is_standard": "Yes", 
 "json": "{\"add_total_row\": 0, \"sort_by\": \"Bin.projected_qty\", \"sort_order\": \"asc\", \"sort_by_next\": \"\", \"filters\": [[\"Bin\", \"projected_qty\", \"<\", \"0\"]], \"sort_order_next\": \"desc\", \"columns\": [[\"warehouse\", \"Bin\"], [\"item_code\", \"Bin\"], [\"actual_qty\", \"Bin\"], [\"ordered_qty\", \"Bin\"], [\"planned_qty\", \"Bin\"], [\"reserved_qty\", \"Bin\"], [\"projected_qty\", \"Bin\"]]}", 
 "modified": "2017-02-24 20:00:46.439935", 
 "modified_by": "Administrator", 
 "module": "Stock", 
 "name": "Item Shortage Report", 
 "owner": "Administrator", 
 "query": "SELECT  bin.warehouse as \"Warehouse:Link/Warehouse:150\",\n\tbin.item_code as \"Item Code:Link/Item:100\",\n\tbin.actual_qty as \"Actual Quantity:Float:120\",\n\tbin.ordered_qty as \"Ordered Quantity:Float:120\",\n\tbin.planned_qty as \"Planned Quantity:Float:120\",\n\tbin.reserved_qty as \"Reserved Quantity:Float:120\",\n\tbin.projected_qty as \"Project Quantity:Float:120\",\n\titem.item_name as \"Item Name:Data:150\",\n\titem.description as \"Description::200\"\nFROM tabBin as bin\nINNER JOIN tabItem as item\nON bin.item_code=item.name\nWHERE bin.projected_qty<0\nORDER BY bin.projected_qty;", 
 "ref_doctype": "Bin", 
 "report_name": "Item Shortage Report", 
 "report_type": "Query Report", 
 "roles": [
  {
   "role": "Sales User"
  }, 
  {
   "role": "Purchase User"
  }, 
  {
   "role": "Stock User"
  }
 ]
}