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

Ok, maybe it isn't worth upgrading all the data...

I have a 1.2.19 that I am running in parallel with 1.3.7. On a relatively simple AP transaction I get an SQL 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)=(10103) is not present in table "account".

I've been trying to drag my data from 1997-present which was converted from QuickBooks to SQL-Ledger and then from SQL-Ledger to LedgerSMB. It is obvious by now that there are too many quirks to catch all of them when I do the 1.2 to 1.3 upgrade (which I have easily done more than 25 times).

Is there a procedure for a starting over with just the balances and inventory (these are rare books with acquisitions back to 1997).

I can keep 1.2 around for as long as I need to for the IRS.

QuirkBooks->Dieter->LedgerSMB is maybe just too ambitious.

Semi despairing and seeking ideas,