[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
AP Invoice Entry Error
- Subject: AP Invoice Entry Error
- From: "Lana Brummett" <..hidden..>
- Date: Thu, 7 Jun 2007 20:24:54 -0500
We just switched over from sql-ledger 2.6.12 and we installed ledgersmb 1.2.5 and I am trying to enter a vendor
invoice for the first time.  I get this error: 
DBD::Pg::st execute failed: ERROR:  column "customer_id" does not exist at character 189
Error!
 
		SELECT ct.name AS vendor, ct.curr AS currency, ct.id AS vendor_id,
			current_date + ct.terms AS duedate, 
			ct.notes
, 
			ct.curr AS currency
		FROM vendor ct
		WHERE ct.id = (select customer_id from ap where 1 = 1 AND vendor_id IS NOT NULL order by id DESC limit 1)
ERROR:  column "customer_id" does not exist at character 189
It looks to me like it should be saying "select vendor_id" and not "select customer_id" but I can't see where this needs to be changed.  Any help would be appreciated!
Thanks,
Lana
-- 
Start your own business for $10, ask me how today!!!
www.youravon.com/lanabrummett
Having a party? Need a cake?  Look no further,  ask for details!!!!
www.creativecakecreations.com
Call Today (847)687-5794
Proud mom to Samantha www.yetanotherdomain.org/samantha