Re: Labor

["Chris Travers" <..hidden..>]

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 <..hidden..> 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
> > ..hidden..
> > 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users