[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Bug/Patch: Allow fractional qty

We use fractional quantities all the time in invoices. In 1.3, the
column is set to type Integer, which truncates all of the fractions.

Patch for invoices attached -- might also need to be fixed in orders...

Cheers,
John Locke
http://freelock.com

diff --git sql/Pg-database.sql sql/Pg-database.sql
index c12657c..4bdb97e 100644
--- sql/Pg-database.sql
+++ sql/Pg-database.sql
@@ -885,7 +885,7 @@ CREATE TABLE invoice (
   trans_id int,
   parts_id int,
   description text,
-  qty integer,
+  qty NUMERIC,
   allocated integer,
   sellprice NUMERIC,
   precision int,