fixes in sales order pending items report
diff --git a/erpnext/selling/search_criteria/sales_order_pending_items/sales_order_pending_items.txt b/erpnext/selling/search_criteria/sales_order_pending_items/sales_order_pending_items.txt
index 036d689..24f719b 100644
--- a/erpnext/selling/search_criteria/sales_order_pending_items/sales_order_pending_items.txt
+++ b/erpnext/selling/search_criteria/sales_order_pending_items/sales_order_pending_items.txt
@@ -1,37 +1,37 @@
+# Search Criteria, sales_order_pending_items
[
+
+ # These values are common in all dictionaries
{
- 'add_col': '(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.delivered_qty, 0)) AS "Qty To Deliver"\n(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.billed_qty, 0)) AS "Qty To Bill"\n(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.delivered_qty, 0))*`tabSales Order Item`.basic_rate AS "Amount To Deliver"\n(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.billed_qty, 0))*`tabSales Order Item`.basic_rate AS "Amount To Bill"',
- 'add_cond': '(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.delivered_qty, 0) > 0 or `tabSales Order Item`.qty - ifnull(`tabSales Order Item`.billed_qty, 0) > 0)\n`tabSales Order`.status != "Stopped"',
- 'add_tab': None,
- 'columns': 'Sales Order\x01ID,Sales Order\x01Sales Order Date,Sales Order\x01Customer,Sales Order\x01Customer Name,Sales Order Item\x01Item Code,Sales Order Item\x01Item Name,Sales Order Item\x01Description,Sales Order Item\x01Quantity,Sales Order Item\x01Delivered Qty,Sales Order Item\x01Billed Qty',
- 'creation': '2011-05-09 11:04:19',
- 'criteria_name': 'Sales Order Pending Items',
- 'custom_query': '',
- 'description': 'Sales Order Pending Items',
- 'dis_filters': None,
- 'disabled': None,
- 'doc_type': 'Sales Order Item',
+ 'creation': '2012-05-14 14:54:44',
'docstatus': 0,
+ 'modified': '2012-05-17 18:02:38',
+ 'modified_by': u'Administrator',
+ 'owner': u'Administrator'
+ },
+
+ # These values are common for all Search Criteria
+ {
+ 'add_col': u'(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.delivered_qty, 0)) AS "Qty To Deliver"\n(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.billed_qty, 0)) AS "Qty To Bill"\n(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.delivered_qty, 0))*`tabSales Order Item`.basic_rate AS "Amount To Deliver"\n(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.billed_qty, 0))*`tabSales Order Item`.basic_rate AS "Amount To Bill"',
+ 'add_cond': u'(`tabSales Order Item`.qty - ifnull(`tabSales Order Item`.delivered_qty, 0) > 0 or `tabSales Order Item`.qty - ifnull(`tabSales Order Item`.billed_qty, 0) > 0)\n`tabSales Order`.status != "Stopped"',
+ 'columns': u'Sales Order\x01ID,Sales Order\x01Sales Order Date,Sales Order\x01Customer,Sales Order\x01Customer Name,Sales Order Item\x01Item Code,Sales Order Item\x01Item Name,Sales Order Item\x01Description,Sales Order Item\x01Quantity,Sales Order Item\x01Delivered Qty,Sales Order Item\x01Billed Qty',
+ 'criteria_name': u'Sales Order Pending Items',
+ 'description': u'Sales Order Pending Items',
+ 'doc_type': u'Sales Order Item',
'doctype': 'Search Criteria',
- 'filters': "{'Sales Order\x01Submitted':1,'Sales Order\x01Status':'','Sales Order\x01Fiscal Year':''}",
- 'graph_series': None,
- 'graph_values': None,
- 'group_by': None,
- 'idx': None,
- 'modified': '2011-05-09 11:08:05',
- 'modified_by': 'Administrator',
- 'module': 'CRM',
- 'name': 'sales_order_pending_items',
- 'owner': 'Administrator',
+ 'filters': u"{'Sales Order\x01Submitted':1,'Sales Order\x01Status':'','Sales Order\x01Fiscal Year':''}",
+ 'module': u'Selling',
+ 'name': '__common__',
'page_len': 50,
- 'parent': None,
- 'parent_doc_type': 'Sales Order',
- 'parentfield': None,
- 'parenttype': None,
- 'report_script': None,
- 'server_script': None,
- 'sort_by': '`tabSales Order`.`name`',
- 'sort_order': 'DESC',
- 'standard': 'Yes'
+ 'parent_doc_type': u'Sales Order',
+ 'sort_by': u'`tabSales Order`.`name`',
+ 'sort_order': u'DESC',
+ 'standard': u'Yes'
+ },
+
+ # Search Criteria, sales_order_pending_items
+ {
+ 'doctype': 'Search Criteria',
+ 'name': u'sales_order_pending_items'
}
-]
+]
\ No newline at end of file