Hi all; A bug has been found in 1.2.x where vendor invoices mistakenly throw errors with fractional quantities. The error appears to be related either to how PostgreSQL handles prepared queries or the DBD::Pg driver and is not related to the datatypes of the underlying fields.
Description: When entering a vendor invoice with a fractional quantity, you may get an error like: UPDATE invoice SET trans_id = ?, parts_id = ?, description = ?, qty = ? * -1, sellprice = ?, fxsellprice = ?, discount = ?, allocated = ?, unit = ?, deliverydate = ?, project_id = ?, serialnumber = ?, notes = ? WHERE id = ? ERROR: invalid input syntax for integer: "19.04" This is caused by the query parser handling the quantity input as an integer even though the underlying column is numeric(). This fix will be generally released in 1.2.4. However, if you are affected by it, you can either update to the latest svn in branches/1.2 or email me specifically for the patch. Best Wishes, Chris Travers ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
