"Download Required Materials" in Production Plan

prasad_naik · May 28, 2024, 11:54am

Hello All,

When i click "“Download Required Materials” in Production Plan, Excel Sheet is getting downloaded , but following “pick columns” are not coming in the downloaded sheet

From Warehouse
Type

So please suggest that, how to get above options in the excel report, any customization required?

thanks in advance.
Prasad

NCP · May 28, 2024, 2:26pm

If Version 15, then check the method and add you columns according to the scenario.

github.com

frappe/erpnext/blob/version-15/erpnext/manufacturing/doctype/production_plan/production_plan.py#L1028-L1094


      
          @frappe.whitelist()
          def download_raw_materials(doc, warehouses=None):
          	if isinstance(doc, str):
          		doc = frappe._dict(json.loads(doc))
          
          	item_list = [
          		[
          			"Item Code",
          			"Item Name",
          			"Description",
          			"Stock UOM",
          			"Warehouse",
          			"Required Qty as per BOM",
          			"Projected Qty",
          			"Available Qty In Hand",
          			"Ordered Qty",
          			"Planned Qty",
          			"Reserved Qty for Production",
          			"Safety Stock",
          			"Required Qty",

This file has been truncated. show original

You can easily override that in your custom app.

prasad_naik · May 28, 2024, 2:44pm

Hi,

we are still in below version, anything can be done for this?

prasad_naik · May 28, 2024, 2:54pm

Shall we use the same above code for Version 13 as well?

NCP · May 28, 2024, 4:47pm

You have to find the code in v13, maybe the path is the same that I provided the reference.

prasad_naik · May 29, 2024, 4:31am

thank you. let me check on this.