This bug was corrected in an earlier version. However, it was caused by problems in the database creation script. If you are getting this error, please contact me for a hotfix sql script to fix your db.
Of if you are familiar with PostgreSQL, run the following commands against your db: ALTER TABLE invoice ALTER COLUMN qty TYPE numeric; ALTER TABLE invoice ALTER COLUMN allocated TYPE numeric; Best WIshes, Chris Travers On 5/17/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Michael Schultheiss wrote: > > What's the proper way to add labor to an invoice? In the past, I've > > used a Service but today while trying to post an invoice with fractional > > labor (10.5 hours), I got an error (10.5 is an invalid integer). > > Actually that sounds more like a bug. 10.5 should be perfectly > acceptable. I wonder why we are storing that as an integer. > > While > > drafting this message, I notices the "Add Labor/Overhead" section in > > "Goods & Services" but when I tried to add a newly created Labor item to > > an invoice I got an "item not found, is this a part or a service?" > > message. > > > > ------------------------------------------------------------------------- > > 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-users mailing list > > Ledger-smb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > > > > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > > > ------------------------------------------------------------------------- > 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-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- 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-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
