Hi All,
I had changed Customer group into Property i had created a query report for sales invoice in that i need main property filter but already subproperty i added mainly i need is group property
SELECT
si.name AS “ID:Link/Sales Invoice:120”,
si.custom_select_property AS “Select Property:Data:120”,
si.customer_name AS “Customer Name:Data:120”,
si.status AS “Status:Select:100”,
si.due_date AS “Payment Due Date:Date:120”,
si.outstanding_amount AS “Outstanding Amount:Currency:120”,
si.grand_total AS “Grand Total:Currency:120”,
IFNULL(sia.advance_amount, 0) AS “Advance Amount:Currency:120”,
IFNULL(sia.allocated_amount, 0) AS “Allocated Amount:Currency:120”,
si.currency AS “Currency:Data:100”,
si.party_account_currency AS “Party Account Currency:Data:100”
FROM
tabSales Invoice
siLEFT JOIN
tabSales Invoice Advance
sia ON sia.parent = si.nameWHERE
si.docstatus = 1
ORDER BY
si.posting_date DESC, si.name DESC;
this is my code
Thanks in Advance