[minor edits] BOM Stock Report (#11012)
* HTML for BOM Stock Report to show filters in PDF
* Added BOM Stock Report in Manufacturing Config under Report
diff --git a/erpnext/config/manufacturing.py b/erpnext/config/manufacturing.py
index 11711ad..086d61b 100644
--- a/erpnext/config/manufacturing.py
+++ b/erpnext/config/manufacturing.py
@@ -123,6 +123,12 @@
"is_query_report": True,
"name": "BOM Search",
"doctype": "BOM"
+ },
+ {
+ "type": "report",
+ "is_query_report": True,
+ "name": "BOM Stock Report",
+ "doctype": "BOM"
}
]
},
diff --git a/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.html b/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.html
new file mode 100644
index 0000000..119a4fc
--- /dev/null
+++ b/erpnext/manufacturing/report/bom_stock_report/bom_stock_report.html
@@ -0,0 +1,27 @@
+<h1 class="text-left"><b>{%= __("BOM Stock Report") %}</b></h1>
+<h5 class="text-left">{%= filters.bom %}</h5>
+<h5 class="text-left">{%= filters.warehouse %}</h5>
+<hr>
+
+<table class="table table-bordered">
+ <thead>
+ <tr>
+ <th style="width: 15%">{%= __("Item") %}</th>
+ <th style="width: 35%">{%= __("Description") %}</th>
+ <th style="width: 14%">{%= __("Required Qty") %}</th>
+ <th style="width: 13%">{%= __("In Stock Qty") %}</th>
+ <th style="width: 23%">{%= __("Enough Parts to Build") %}</th>
+ </tr>
+ </thead>
+ <tbody>
+ {% for(var i=0, l=data.length; i<l; i++) { %}
+ <tr>
+ <td>{%= data[i][ __("Item")] %}</td>
+ <td>{%= data[i][ __("Description")] %} </td>
+ <td align="right">{%= data[i][ __("Required Qty")] %} </td>
+ <td align="right">{%= data[i][ __("In Stock Qty")] %} </td>
+ <td align="right">{%= data[i][ __("Enough Parts to Build")] %} </td>
+ </tr>
+ {% } %}
+ </tbody>
+</table>
\ No newline at end of file