Query report for filters

ERPNext
6

Hi @Rajkumudu_Rk,

Please check it.

SELECT
    si.item_code AS 'Item Code',
    si.item_name AS 'Item Name',
    si.qty AS 'Quantity',
    si.net_amount AS 'Net Value',
    s.customer AS 'Customer',
    s.company AS 'Company'
FROM 
    `tabSales Invoice` s, 
    `tabSales Invoice Item` si
WHERE
    si.parent = s.name
    AND s.posting_date BETWEEN %(from_date)s AND %(to_date)s
    AND s.company = %(company)s;

Thank You!

1 Like