Add Item name on Material Request

Hi,

This is my question,
I am trying to customize my material request document by adding item_name in the material request doctype, so that every time i select item_code and Item_name from the Material request item doctype (child doctype) it would automatically pulled to the item_name field in the Material request doctype(master doctype).

I tried using the cur_frm.add_fetch(‘item_code’,‘item_name’,‘item_name’) on custom script but its not doing any effect.

can you helped me and thanks for your help

The Material Request can have more than one Material Request Item. How are you planning on handling more than one item?

I think something like this should work:

   frappe.ui.form.on('Material Request Item', 'item_code', function(doc,cdt,cdn)
    {
    //Get the local variables of the child table (cdt) with the corresponding child name (cdn)
    var d=locals[cdt][cdn]
    
    frappe.call({
                "method": "frappe.client.get_value",
                args: {
                    'doctype': 'Item',
                    'filters': [['Item', 'item_code', '=', d.item_code]],
                    'fieldname': 'item_name'
                },
                callback: function (data) {
    frappe.model.set_value(doc.doctype,doc.docname,"item_name",  data.message.item_name);
                }});
    
    //Refresh the table
    refresh_field("items");
    }

Hi Ben,

I tried your code in the custom script-material request but its still not
sucessfull

i am sorry as i am still new in frappe,

could you give me more detailed instructions of what should i do

attached are print screen of what do i want to make the customization look
alike

thanks again for your patience

i hope i can learn fast

Thanks

Anton

Ps: i am using the production planning tool often, so the material request
generated are always 1 item 1 document. the idea was to put item name in
front of the material request form
so i can filter based on the item name/item code. so that the material guy
would have better understanding when he choose the material form with name
on it.

Thanks

This seems like a very bad way of solving your problem. Why don’t you just use the report function, include the Item Name and Item code from each item as a column (Using the Menu > Pick Columns) and then sort by that column?

Hi Ben

Sure I can do that,

Its just i am curious now, as this problem looks easy but i cant solve it

As i am still learning on frappe, i hope i can get the solution to fetch
value from child doctype to master doctype using custom script.

as i will encounter this problem again i think in future.

can you help me with this
thanks again and sorry to bother

Anton

Can you let me know what is happening when you try to run the script I provided? What error do you get? Look at the Developer Console on your browser and it should show an error when you load the doc.

@ Ben_Cornwell,

Dear Sir,

Thanks for your help, finally i am able to run your script and it works,
There is just some misunderstanding on how the script works as i tried to fetch the item code
on the child doctype and to show it on the master doctype.

the script work when i fetch the item_code on the child doctype and to show it on the child table.

Thanks and best regards sir

Anton