How to fetch Item Field Values to Sales Invoice Item

[progShubham]

Hi,

I created a “Text Form” field in the doctype “item.” I’ve added this field to the Sales Invoice Item doctype.

How Can I get the values to sales invoice item which are already updated in item list.

__
Rgds…
Parag Kapoor

[vivek_ilexSquare]

Keep Name of Field Same in both doctype.

[shraddha]

Hi,

Check with this,

Fetching value from Item master to Sales invoice Item

I need to fetch item type from item master to sales invoice item table…Type of item_type in item master is Select and sales invoice item is data… I have tried below code but not working…Please help cur_frm.cscript.custom_item_code = function(doc, cdt, cdn){ var child = locals[cdt][cdn]; cur_frm.call({ “method”: “frappe.client.get_value”, “args”: { “doctype”: “Item”, “filters”: { “name”: child.item_code } }, “child”: child, “fieldname”: “item_type” }) }

[vivek_ilexSquare]

@shraddha

just more information to your solution

---

add_fetch(link_fieldname, source_fieldname, target_fieldname)

[progShubham]

@vivek_ilexSquare @shraddha

Thanks for your solution but I’m little bit confused that where to write these codes.

cur_frm.add_fetch("item_code", "item_type", "item_type")

If you will provide me some detailed explanation as per my problem with Sales Invoice Item doctype, it would be really helpful for me.

Thanks!

[vivek]

@progShubham try this
Put this in a new Custom Script - > with doctype Sales Invoice
cur_frm.add_fetch(“item_code”, “text_form”, “text_form”)

[progShubham]

@vivek

Thanks a lot sir. That works really great.