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

1.4.0-b3 Error Saving Purchase Transaction



I've hit a problem using 1.4.0-b3 and would appreciate any help or
guidance in resolving the issue:

Purchases->Add Transaction
Enter details and click 'Update' followed by 'Save'

Gives:
Error!


INSERT INTO ap (invnumber, person_id,
entity_credit_account)
VALUES (?, (select u.entity_id from users u
join entity e on(e.id = u.entity_id)
where u.username=? and u.entity_id in(select p.entity_id from person p) ), ?)
ERROR: duplicate key value violates unique constraint "transactions_pkey"
DETAIL: Key (id)=(4) already exists.
CONTEXT: SQL statement "INSERT INTO transactions (id, table_name, approved)
VALUES (new.id, TG_RELNAME, new.approved)"
PL/pgSQL function "track_global_sequence" line 4 at SQL statement

dbversion: 1.4.0, company: npbroadcast

Error!

Died at LedgerSMB/Form.pm line 493.

dbversion: 1.4.0, company: npbroadcast


Any help or suggestions gratefully received.

Many thanks and best wishes,

Nick