Problem with Query Report in Accounting Module. Need Help

[Aditya Duggal]

Hi,

I have recently written a query report in erpnext which is a report based on sales invoice, basically this report shows the list of all the invoices pending for payments. Now I have added a column which shows the total amount of invoices pending with respect to a customer and the report works fine, but for certain customers this total column is not calculating the amounts properly.

The link for the report code is here.

The problem being faced with the report is enclosed in the screenshots, if you see that the total pending column is taking the total of someone else as well, can some one please help me debug this issue as it is only happening with a very few accounts only in the whole list.

[Aditya Duggal]

[Nabin Hait]

Please check my comments in gist, you did not specify where clause for inner join query

Regards,

Nabin Hait

www.erpnext.com

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/1GI-ZdLCgNoJ.
For more options, visit https://groups.google.com/groups/opt_out.
 
 
<Capture.PNG>