<![CDATA[FrontAccounting forum — Error encountered]]> https://frontaccounting.com/punbb/viewtopic.php?id=348 Thu, 25 Sep 2008 08:23:40 +0000 PunBB <![CDATA[Re: Error encountered]]> https://frontaccounting.com/punbb/viewtopic.php?pid=1197#p1197 Thank You Itronics, it's worked

]]> Thu, 25 Sep 2008 08:23:40 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=1197#p1197 <![CDATA[Re: Error encountered]]> https://frontaccounting.com/punbb/viewtopic.php?pid=1195#p1195 You should change field name you just have added to debtors_master to avoid the name conflict.
Janusz

]]> Thu, 25 Sep 2008 08:02:46 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=1195#p1195 <![CDATA[Error encountered]]> https://frontaccounting.com/punbb/viewtopic.php?pid=1190#p1190 i encountered another error on opening Customer Allocations

DATABASE ERROR : Cannot retreive debtor transactions
error code : 1052
error message : Column 'type' in where clause is ambiguous
sql that failed was : SELECT 0_debtor_trans.*, ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total, 0_debtors_master.name AS DebtorName, 0_debtors_master.address, 0_debtors_master.curr_code, 0_debtor_trans.version , round(ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount-alloc,6) <= 0 AS settled FROM 0_debtor_trans, 0_debtors_master WHERE 0_debtor_trans.debtor_no=0_debtors_master.debtor_no AND (type=12 OR type=11 OR type=2) AND (0_debtor_trans.ov_amount > 0) AND (round(ov_amount+ov_gst+ov_freight+ov_freight_tax-ov_discount-alloc,6) > 0) AND 0_debtor_trans.debtor_no = 8 ORDER BY trans_no

]]> Thu, 25 Sep 2008 07:18:40 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=1190#p1190