Hi Guys,
I want to build this report
this report is should be from GL Entry and Sales Invoice Item
how I can implement this, I do it in SQL Query as following
select
gl.posting_date,
gl.party_type,
gl.party,
round(gl.debit,2) as Debit,
round(gl.credit,2) as Credit,
round((gl.debit - gl.credit), 2) as Balance,
gl.voucher_type,
gl.voucher_no,
it.item_name,
Round(it.qty,2) as QTY,
Round(it.rate,2) as Rate,
Round((it.qty*it.rate),2) as `Amount`
from `tabGL Entry` as gl
left join `tabSales Invoice Item` as it on it.parent=gl.voucher_no
where gl.party_type='Customer' and gl.company='SBC' and gl.posting_date between '2022-5-1' and '2022-5-10'
limit 60;
this is output of above Query
