<![CDATA[FrontAccounting forum — Void Customer Credit Note]]> 2008-12-01T21:59:02Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=411 <![CDATA[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

]]> https://frontaccounting.com/punbb/profile.php?id=3 2008-12-01T21:59:02Z https://frontaccounting.com/punbb/viewtopic.php?pid=1467#p1467 <![CDATA[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.

]]> https://frontaccounting.com/punbb/profile.php?id=240 2008-12-01T15:36:22Z https://frontaccounting.com/punbb/viewtopic.php?pid=1466#p1466