Problem with Query Report in Accounting Module. Need Help

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.




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/oJmyFavmPYMJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 



On Saturday, April 6, 2013 5:37:31 PM UTC+5:30, Aditya Duggal wrote:

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.




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@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.

 

 

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

Regards,
Nabin Hait

On 06-Apr-2013, at 5:40 PM, Aditya Duggal wrote:



On Saturday, April 6, 2013 5:37:31 PM UTC+5:30, Aditya Duggal wrote:
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.





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-forum+un…@googlegroups.com.

To post to this group, send email to er…@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>




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.