Delivery note custom report

ERPNext
1

Hello,

I would like to make a custom report showing that all delivery note has no attachments, is it possible?

2

Hi @Sbabaker,

That for, please apply the query report for the Delivery Note.

SELECT
    `tabDelivery Note`.`name` AS `Delivery Note:Link/Delivery Note:200`,
    IFNULL(GROUP_CONCAT(`tabFile`.`file_name` SEPARATOR ', '), ' - ') AS `Attachments:Data:500`
FROM
    `tabDelivery Note`
LEFT JOIN
    `tabFile`
ON
    `tabDelivery Note`.`name` = `tabFile`.`attached_to_name`
GROUP BY
    `tabDelivery Note`.`name`

If no attachments then will show (-) and if multiple attachments and then will show to file name.

Output:

image
image1841×608 57.2 KB

Thank You!

3

Hi @NCP

thanks a lot for your collaboration it worked!