/Joe

SUM(line.quantity) as quantity

with

SUM(IF(line.debtor_trans_type = ".ST_CUSTCREDIT.", -line.quantity, line.quantity)) as quantity

However the bug is still there. Earlier it was not subtracting the credited quantity and now it is adding back. Means now the result in Item sales Summary report is like below

102 17inch VGA Monitor 8 (instead of 2)         
103 32MB VGA Card       6       
104 52x CD Drive          10

Line 53 in the new file:

        AND (line.debtor_trans_type = ".ST_SALESINVOICE." OR line.debtor_trans_type = ".ST_CUSTCREDIT.")";

may also be

        AND (line.debtor_trans_type IN (".ST_SALESINVOICE.", ".ST_CUSTCREDIT."))";

This way, when more transaction types needs to be added, it would be easily readable.

Please commit it.

You are absolutely right. There was a bug in the Item Sales Summary Report.

Please try the attached file and tell me if this is ok now. Rename it to rep309.php. Thanks for finding this.

/Joe

/Joe

id: demouser
pass: 123456

Check the Item Sales Summary Report of September 2016. It will show something belo

102 17inch VGA Monitor 5         
103 32MB VGA Card       6       
104 52x CD Drive          10

While If you check the Inventory Sales Report of September 2016. It will show something like below

102 17inch VGA Monitor 2         
103 32MB VGA Card       6       
104 52x CD Drive          10

The 3 Quantity of VGA Monitor was Credited (Returned) but it is not reflecting in Item Sales Summary REport