<![CDATA[FrontAccounting forum — Check Module]]> https://frontaccounting.com/punbb/viewtopic.php?id=1926 Wed, 02 Mar 2011 22:29:23 +0000 PunBB <![CDATA[Re: Check Module]]> https://frontaccounting.com/punbb/viewtopic.php?pid=8435#p8435 The module you have downloaded is for an earlier release.
From release 2.3.0 you should be able to install it from our central repository instead.
First remove the old installation and then install from the central repository.

/Joe

]]> Wed, 02 Mar 2011 22:29:23 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=8435#p8435 <![CDATA[Check Module]]> https://frontaccounting.com/punbb/viewtopic.php?pid=8433#p8433 We downloaded the  Check Printing Report based on a model from Tom Hallman.  However when we try to print a check, we get the following error:

DATABASE ERROR : The remittance cannot be retrieved
error code : 1054
error message : Unknown column '0_suppliers.email' in 'field list'
sql that failed was : SELECT 0_supp_trans.*, (0_supp_trans.ov_amount+0_supp_trans.ov_gst+0_supp_trans.ov_discount) AS Total, 0_suppliers.supp_name, 0_suppliers.supp_account_no, 0_suppliers.curr_code, 0_suppliers.payment_terms, 0_suppliers.gst_no AS tax_id, 0_suppliers.email, 0_suppliers.address, 0_suppliers.contact FROM 0_supp_trans, 0_suppliers WHERE 0_supp_trans.supplier_id = 0_suppliers.supplier_id AND 0_supp_trans.type = '22' AND 0_supp_trans.trans_no = '4'

Can someone help?

]]> Wed, 02 Mar 2011 19:57:58 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=8433#p8433