[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Ok, maybe it isn't worth upgrading all the data...
- Subject: Ok, maybe it isn't worth upgrading all the data...
- From: ..hidden..
- Date: Sat, 3 Dec 2011 20:10:39 -0700 (MST)
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
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,