Re: Invoice Creation Failing

[BeamEnds <..hidden..>]

On Wed, 2007-12-05 at 12:38 -0800, Chris Travers wrote:
> 
> 

> 
> Ok, try taking a look at the actual tables.  The fields are ints so it
> is probably 1001, 4000, and 5000.
> 
> In that case, the thing to do is UPDATE parts SET inventory_accno_id =
> (select id from chart where accno = '1001') where inventory_accno_id =
> '1001'; 
> 
> I would test on a copy of oyur db (either back up first or actually
> copy the db into a new db, as in createdb -T ....)
> 
> You can do the same for income_accno_id and expense_accno_id.
> 
> Best Wishes,
> Chris Travers 
> 

Hi Chris,
thanks for that - all ok now! Upwards and onwards...

Cheers
Richard


> 
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users