• From: Canada, Kitchener, Ontario
  • Registered: 02/03/2009
  • Posts: 24

Topic: 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.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Voiding Transactions

This issue was fixed in main CVS. You will find changed files attached to bug report 356 on mantis.
Janusz