How to get Supplier and Barcode Information in the Item List View?

Frappe Framework Customization
1

Hello,

I make it short!

What I want:

see in Item List View the supplier of the related item.

Supplier%20in%20Item%20List%20View
Supplier%20in%20Item%20List%20View971×251 52.2 KB

My situation:

The Data of the Supplier is in a field, wich is in the ChildDocType “Item Supplier”, what means, that it´s not possible to select the Option “In List View” in the Customization of the “Item” DocType.

Supplier_Item_Table
Supplier_Item_Table905×41 7.91 KB

and here the ChildDocType “Item Supplier”

childdoctype_supplier_item
childdoctype_supplier_item956×227 25.3 KB

Here you can see the field “supplier” is from Type “Link”.

I want the same effect for other Details. For example the barcode of an item.

Here the same case!

table_barcode
table_barcode945×53 9.45 KB

except that here is the field barcode from the Type “Data”.

childdoctype_barcode
childdoctype_barcode929×223 22 KB

can you find a uniform solution for both cases?

What I was thinking about or my approach:

Create a field in DocType “Item” .
Activate the function “Hidden” for this field.

Get data from the respective field of the respective ChildDoctype and drag it into the “newly created” field.

My question: how to program this, or what means does ERPNext offer here?

Finally, here you would activate the “In List View” function in the newly created field.

Anyone help?

Best regards

2

from item list view

  1. click upper left sidebar Reports drop down menu, click report builder
  2. click toolbar menu → pick columns
  3. in the popup window scroll down, tick supplier field, scroll up click submit
  4. click toolbar menu save or save as and input new report name

then you can have a custom report almost the same like the standard list view but with desired field from child table available.

you proposed approach to add one custom field and set show in list view for Item DocType and populate it with values from the relevant child doctype is doable via either javascript or python script. but it is not as easy as above suggested.

Try it yourself.

3

thx szufisher for the tip!

I tried to reprogram it for a few days. Although not exactly the function that you showed me but a similar, which turned out in the end as not so similar.

Thanks again for the tutorial and solution!

Greetings