How to automatically fetch data in quotation item child table from item custom feilds?

[Anjalijangid]

I have three custom fields in item doc-type - size, material and finish
when i generated a quotation, i customized the item child table and added these three fields al well because i want them for each item in the quotation.

But unfortunately, the column can not fetch value from the item doc-type similarly as i enter item code name so it automatically fetches the item name, item rate and item description.
Kindly assist on the same that what changes i can do so that after adding item code, along with rate, name and description, it can fetch size, material and finish too.

This is the view after customization -

Now, after adding one item code, only name, rate and description has been
automatically filled, i want other three to filled in the same way -

[NCP]

Please check the video (Fetch From - Default Feature: start with 0:55)

Fetch Child table form one doctype to other doctype

I have given the reference of the video here, maybe it will help someone. [Fetch Data From One DocType To Another | Frappe | ERPNext]

[Anjalijangid]

Is this code fine?
because error in client script is showing!

[NCP]

size, material, and finish are set in the Item master then you can easily use with default feature of Fetch From without the code. default feature video starts with 55 seconds in youtube that i provided.

[Anjalijangid]

I cant see related doctype here

[NCP]

Select the Item (item_code) and then select your Size field from the Item master. you have to play with feature and how it works. Then you will know, otherwise nothing will be known

[Anjalijangid]

Thanks your so much.
It worked !!

[Anjalijangid]

Hello,
I tried this, the data is fetched successfully but when i am submitting it, the following error is showing.

[NCP]

Please check item has a size/material or not.

This is the only way to manage.

Otherwise, apply the “Fetch on Save if Empty”.

[Anjalijangid]

yes, the item has all there data but still not working.

[NCP]

Try it yourself and learn it. i provided the all references.

[Anjalijangid]

Thanks, its working now, I deleted the fields and recreated them.
The field now is data instead of LINK.

[Anjalijangid]

In this case, the material is a table multi-select field in item.

This is quotation<child-table customization material field (data type).

I cant see the ‘material’ option here in item_code.

Even when, material has value in item doctype.

In my previous quotation, it fetched all details but now in other new quotations, its not fetching material and finish.

Please help !!

[NCP]

Fetch from feature and multi-select feature are different, so they cannot be compared.

[Anjalijangid]

But in my previous quotation, they got fetched from the same method.
Now its not working.
Is there any other way, to fetch multiselect fields?

[NCP]

@Anjalijangid

s there any other way, to fetch multiselect fields?

maybe possible from the script (not sure about the script), not the UI side.

[Anjalijangid]

okay !