[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Posting Invoices failing
- Subject: Posting Invoices failing
- From: BeamEnds <..hidden..>
- Date: Thu, 29 Nov 2007 22:42:03 +0000
Hi All,
if I create a Sales Invoice and Post it I get this:
DBD::Pg::st execute failed: ERROR: insert or update on table "acc_trans"
violates foreign key constraint "acc_trans_chart_id_fkey"
DETAIL: Key (chart_id)=(4000) is not present in table "chart".
Error!
INSERT INTO acc_trans
(trans_id, chart_id, amount,
transdate, project_id, invoice_id)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: insert or update on table "acc_trans" violates foreign key
constraint "acc_trans_chart_id_fkey"
DETAIL: Key (chart_id)=(4000) is not present in table "chart".
1.2.8/1.2.9 the same.
Any ideas?
Cheers
Richard