<![CDATA[FrontAccounting forum — Voiding Transactions]]> 2010-12-27T14:25:14Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=1774 <![CDATA[Re: Voiding Transactions]]> This issue was fixed in main CVS. You will find changed files attached to bug report 356 on mantis.
Janusz

]]> https://frontaccounting.com/punbb/profile.php?id=89 2010-12-27T14:25:14Z https://frontaccounting.com/punbb/viewtopic.php?pid=7833#p7833 <![CDATA[Voiding Transactions]]> 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.

]]> https://frontaccounting.com/punbb/profile.php?id=301 2010-12-27T12:32:49Z https://frontaccounting.com/punbb/viewtopic.php?pid=7827#p7827