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:
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, Louis ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
