<![CDATA[FrontAccounting forum — Voiding Transactions]]> https://frontaccounting.com/punbb/viewtopic.php?id=1774 Mon, 27 Dec 2010 14:25:14 +0000 PunBB <![CDATA[Re: Voiding Transactions]]> https://frontaccounting.com/punbb/viewtopic.php?pid=7833#p7833 This issue was fixed in main CVS. You will find changed files attached to bug report 356 on mantis.
Janusz

]]> Mon, 27 Dec 2010 14:25:14 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=7833#p7833 <![CDATA[Voiding Transactions]]> https://frontaccounting.com/punbb/viewtopic.php?pid=7827#p7827 I am currently running FA 2.3.0a the newest version from sourceforge. However I am getting following error when I click Void Transactions -> Purchase Order.


DATABASE ERROR : Error reading record set
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' t.order_no) FROM 0_purch_orders t LEFT JOIN 0_voided v ON t.order_no=v.id AND v' at line 1
sql that failed was : SELECT COUNT(DISTINCT t., t.order_no) FROM 0_purch_orders t LEFT JOIN 0_voided v ON t.order_no=v.id AND v.type=18 WHERE (ISNULL(v.`memo_`))


Can someone please help. Thanks.

]]> Mon, 27 Dec 2010 12:32:49 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=7827#p7827