error posting POS Sale

[john <..hidden..>]

When i perform a POS Sale for either a service or product the following error comes up:


DBD::Pg::st execute failed: ERROR: null value in column "chart_id" violates not-null constraint

Error!

INSERT INTO acc_trans 
(trans_id, chart_id, amount, 
transdate, source, memo, cleared)
VALUES (?, (SELECT id FROM chart
WHERE accno = ?),
?, ?, ?, ?, ?)
ERROR: null value in column "chart_id" violates not-null constraint


Using the following setup:
- PostgreSQL 8.2
- Perl v5.8.8
- Apache 2.2.6
LedgerSMB 1.2.12 from source


Any help is most appreciated.  Thanks in advance.

john