<![CDATA[FrontAccounting forum — Void Customer Credit Note]]> https://frontaccounting.com/punbb/viewtopic.php?id=411 Mon, 01 Dec 2008 21:59:02 +0000 PunBB <![CDATA[Re: Void Customer Credit Note]]> https://frontaccounting.com/punbb/viewtopic.php?pid=1467#p1467 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

]]> Mon, 01 Dec 2008 21:59:02 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=1467#p1467 <![CDATA[Void Customer Credit Note]]> https://frontaccounting.com/punbb/viewtopic.php?pid=1466#p1466 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.

]]> Mon, 01 Dec 2008 15:36:22 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=1466#p1466