{
 "apply_user_permissions": 1,
 "creation": "2013-05-06 12:28:23",
 "docstatus": 0,
 "doctype": "Report",
 "idx": 1,
 "is_standard": "Yes",
 "modified": "2015-02-12 07:18:17.302063",
 "modified_by": "Administrator",
 "module": "Accounts",
 "name": "Sales Partners Commission",
 "owner": "Administrator",
 "query": "SELECT\n    sales_partner as \"Sales Partner:Link/Sales Partner:150\",\n\tsum(base_net_total) as \"Invoiced Amount (Exculsive Tax):Currency:210\",\n\tsum(total_commission) as \"Total Commission:Currency:150\",\n\tsum(total_commission)*100/sum(base_net_total) as \"Average Commission Rate:Currency:170\"\nFROM\n\t`tabSales Invoice`\nWHERE\n\tdocstatus = 1 and ifnull(base_net_total, 0) > 0 and ifnull(total_commission, 0) > 0\nGROUP BY\n\tsales_partner\nORDER BY\n\t\"Total Commission:Currency:120\"",
 "ref_doctype": "Sales Invoice",
 "report_name": "Sales Partners Commission",
 "report_type": "Query Report"
}
