FrontAccounting forum — A Bug in Item Sales Summary Report

Re: A Bug in Item Sales Summary Report

null@example.com (apmuthu) — Sun, 04 Dec 2016 16:03:30 +0000

Thanks @joe: Stands committed in FA 2.3 and FA 2.4.

Re: A Bug in Item Sales Summary Report

null@example.com (boxygen) — Sat, 03 Dec 2016 17:36:46 +0000

Its Perfect Now.
Thanks @Joe and @apmuthu
Regards.

Re: A Bug in Item Sales Summary Report

null@example.com (joe) — Sat, 03 Dec 2016 15:45:07 +0000

Oh yes, and please report back if this is ok. Then I will commit the change.

/Joe

Re: A Bug in Item Sales Summary Report

null@example.com (apmuthu) — Sat, 03 Dec 2016 15:12:33 +0000

Try to replace line 41 (in both FA 2.3 and 2.4):

SUM(line.quantity) as quantity

with

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

Re: A Bug in Item Sales Summary Report

null@example.com (boxygen) — Sat, 03 Dec 2016 14:18:37 +0000

Thanks @Joe for your action.

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

Re: A Bug in Item Sales Summary Report

null@example.com (apmuthu) — Tue, 29 Nov 2016 08:29:04 +0000

Quickfix @joe. Thanks.

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.

Re: A Bug in Item Sales Summary Report

null@example.com (joe) — Mon, 28 Nov 2016 22:47:44 +0000

@boxygen

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

Re: A Bug in Item Sales Summary Report

null@example.com (apmuthu) — Mon, 28 Nov 2016 16:35:56 +0000

@joe: Boxygen's claim needs to be checked for reporting consistency.

Re: A Bug in Item Sales Summary Report

null@example.com (boxygen) — Mon, 28 Nov 2016 09:04:26 +0000

*Hello

Re: A Bug in Item Sales Summary Report

null@example.com (boxygen) — Mon, 28 Nov 2016 09:03:13 +0000

Hell @joe could you check it further?

Re: A Bug in Item Sales Summary Report

null@example.com (boxygen) — Tue, 01 Nov 2016 16:41:55 +0000

No, I choose the Item returned to inventory location.

Re: A Bug in Item Sales Summary Report

null@example.com (joe) — Tue, 01 Nov 2016 10:00:34 +0000

When crediting did you choose Write off the items? Or?

/Joe

A Bug in Item Sales Summary Report

null@example.com (boxygen) — Tue, 01 Nov 2016 07:10:01 +0000

In order to veiw this bug login at fa.boxygen.biz/fa2325

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