added description in stock level and balance report
diff --git a/startup/report_data_map.py b/startup/report_data_map.py
index 912246c..c7a8ab7 100644
--- a/startup/report_data_map.py
+++ b/startup/report_data_map.py
@@ -60,7 +60,7 @@
# Stock
"Item": {
- "columns": ["name", "if(item_name=name, '', item_name) as item_name",
+ "columns": ["name", "if(item_name=name, '', item_name) as item_name", "description",
"item_group as parent_item_group", "stock_uom", "brand", "valuation_method"],
# "conditions": ["docstatus < 2"],
"order_by": "name",
diff --git a/stock/page/stock_balance/stock_balance.js b/stock/page/stock_balance/stock_balance.js
index b25d150..da6b831 100644
--- a/stock/page/stock_balance/stock_balance.js
+++ b/stock/page/stock_balance/stock_balance.js
@@ -42,15 +42,18 @@
this.columns = [
{id: "name", name: "Item", field: "name", width: 300,
formatter: this.tree_formatter},
+ {id: "opening", name: "Opening", field: "opening", width: 100,
+ formatter: this.currency_formatter},
+ {id: "inflow", name: "In", field: "inflow", width: 100,
+ formatter: this.currency_formatter},
+ {id: "outflow", name: "Out", field: "outflow", width: 100,
+ formatter: this.currency_formatter},
+ {id: "closing", name: "Closing", field: "closing", width: 100,
+ formatter: this.currency_formatter},
{id: "brand", name: "Brand", field: "brand", width: 100},
- {id: "opening", name: "Opening", field: "opening",
- formatter: this.currency_formatter},
- {id: "inflow", name: "In", field: "inflow",
- formatter: this.currency_formatter},
- {id: "outflow", name: "Out", field: "outflow",
- formatter: this.currency_formatter},
- {id: "closing", name: "Closing", field: "closing",
- formatter: this.currency_formatter},
+ {id: "item_name", name: "Item Name", field: "item_name", width: 100},
+ {id: "description", name: "Description", field: "description", width: 200,
+ formatter: this.text_formatter},
];
},
diff --git a/stock/page/stock_level/stock_level.js b/stock/page/stock_level/stock_level.js
index 87fce6a..356864f 100644
--- a/stock/page/stock_level/stock_level.js
+++ b/stock/page/stock_level/stock_level.js
@@ -84,10 +84,12 @@
{id: "projected_qty", name: "Projected Qty",
field: "projected_qty", width: 80, formatter: this.currency_formatter},
{id: "uom", name: "UOM", field: "uom", width: 60},
- {id: "item_name", name: "Item Name", field: "item_name", width: 100,
- formatter: this.text_formatter},
{id: "brand", name: "Brand", field: "brand", width: 100,
link_formatter: {filter_input: "brand"}},
+ {id: "item_name", name: "Item Name", field: "item_name", width: 100,
+ formatter: this.text_formatter},
+ {id: "description", name: "Description", field: "description", width: 200,
+ formatter: this.text_formatter},
];
},