• From: Morocco
  • Registered: 11/04/2008
  • Posts: 1

Topic: Void Customer Credit Note

I have no success  to Void Customer Credit Note:

DATABASE ERROR : The parent document detail record could not be updated
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 '' at line 3
sql that failed was : UPDATE 1_debtor_trans_details SET qty_done = qty_done + -2 WHERE id=

I use FA 2.0.5

Can void other transactions - Just Customer Credit give this problems.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Void Customer Credit Note

Strange, I can not reproduce this error. There seems to be no id value. I have tried and tried but cannot reproduce this. Maybe there are some inconsistencies in the database. If you have access to phpMyAdmin, look at the table 1_debtor_trans_details. The debtor_trans_type should be 11 and the debtor_trans_no should be the same as the credit note #. Check if there are records with no id values.

/Joe