Include item name in list view of sales order

[rahul2]

Hi everyone,

Is there a way to include item name in sales order list view. PFA image for ref.

With 100s of order it can create problem if item name is not visible. Also farfetched but can we include item image in list view also if possible.

List view has been the most disappointing part of ERPNext, as if it is made to hide as much details as possible.

Regards

[gtapias]

Keep in mind, list view is meant for documents (records). With each document (sales order) being able to contain 100s of items in its child table.

So, which one of those 100 items would you like to display on your documents list?

Perhaps list view is not meant to display sales orders items, but general information for the sales order.

Perhaps you are looking for Report View, where you will be able to see all the detail you mentioned, all items for each of all your sales orders in a single view.

[rahul2]

There should be option to customize, I tried creating a custom field to add item name separately in sales but it not even showing up in linked doc type.

[NCP]

Hi @rahul2,

Not possible to show the item in Listview.

But an alternative solution is , if you don’t want to open and check the item then you can also apply the listview client script according to the logic.

Please check it.

Thank You!

[rahul2]

I think it is time learn some some javascript… .

[NCP]

@rahul2

learn some some javascript… .

Reference:

Client Side scripting

Hi @Tap, Without a link reference how to get the doctype_2 amount. I think you should learn about client scripts then please check it post. Please check the @buildwithhussain Video: Reference: I hope this helps. Thank You!

[rahul2]

It is better to use report view than list view. Was able to include item name in report view and and column width can be adjusted.

[NCP]

You can also develop a simple query report according to the scenario and you can fix the column width.

Reference:

Adding Filters in Query Report

Hi @DME_Apaulsoftware, Please check this. [image] Output: When you select MR ID then will be show data. [image] Sample code: SELECT `tabMaterial Request`.`name` as `MR:Link/Material Request:180`, `tabMaterial Request`.`transaction_date` as `Transaction Date:Date:120`, `tabMaterial Request`.`status` as `Status:Data:100` FROM `tabMaterial Request` WHERE `tabMaterial Request`.`name` = %(name)s AND `tabMaterial Request`.docstatus = 1 T…

Create scripts report error

Hi @Zeeshan_Naeem, I think You should check the documentation of the server script report and also check the video. Query Report for please check it. [Reports II - Query Report] Script Report for please check it. [Reports III - Script Report] I hope this helps. Thank You!

[rahul2]

Will go through it.