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
--
LINET Services
Linux im Intra- und InterNet
Rebenring 33 Tel.: 0531-280 191 71
38106 Braunschweig Fax: 0531-280 191 72
http://www.linet-services.de
mailto:[EMAIL PROTECTED]
-------------------------------------------------------
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]/
