I don't remember the specifics, but I saw some errors like this in 1.8.2 that went away after upgrading to 1.8.4.
Cheers, -- Rod http://www.sunsetsystems.com/ On Tuesday 23 July 2002 06:55 am, Philip Reetz wrote: > Hello everyone, > > I have a little problem. When looking through our invoices from the > beginning of the year we found a few minor error in the SL entries. Usually > we just correct the entry and post the invoice again. > > We have the following case: > We got an invoice from one of our vendors an January 28. > The payment was accidently entered for January 5 instead of February 5 > Therefore the liabilities where not decreased by the invoice amount. > > I hoped to just change the payment date and everything would be fine, but > when I did this I got the following error and don't know what to make of > it: > > -snip- > Error! > > INSERT INTO acc_trans (trans_id, chart_id, amount, > transdate) > VALUES (10445, 10995, > +0.00, '03.02.2002') > ERROR: Unable to identify a left operator '+' for type 'float8' > You may need to add parentheses or an explicit cast > -snip- > > Thanks for the help. > > Ciao, > Philip ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
