• Registered: 01/28/2011
  • Posts: 14

Topic: Check Module

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?

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

Re: Check Module

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