[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Posting Invoices failing



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