SF.net SVN: ledger-smb: [1253] trunk

[..hidden..]

Revision: 1253
          http://svn.sourceforge.net/ledger-smb/?rev=1253&view=rev
Author:   einhverfr
Date:     2007-06-04 15:02:41 -0700 (Mon, 04 Jun 2007)

Log Message:
-----------
More trunk fixes

Modified Paths:
--------------
    trunk/LedgerSMB/CA.pm
    trunk/sql/Pg-database.sql

Modified: trunk/LedgerSMB/CA.pm
===================================================================
--- trunk/LedgerSMB/CA.pm	2007-06-04 21:29:12 UTC (rev 1252)
+++ trunk/LedgerSMB/CA.pm	2007-06-04 22:02:41 UTC (rev 1253)
@@ -370,7 +370,7 @@
 			       ac.source, a.till, ac.chart_id
 			  FROM ar a
 			  JOIN acc_trans ac ON (ac.trans_id = a.id)
-			  JOIN customer c ON (a.customer_id = c.id)
+			  JOIN customer c USING (entity_id)
 			$dpt_join
 			 WHERE ac.chart_id = ?
 			$fromdate_where

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-04 21:29:12 UTC (rev 1252)
+++ trunk/sql/Pg-database.sql	2007-06-04 22:02:41 UTC (rev 1253)
@@ -297,7 +297,7 @@
   cc text,
   bcc text,
   business_id int,
-  taxnumber varchar(32),
+  invoice_notes text,
   sic_code varchar(6),
   iban varchar(34),
   bic varchar(11),


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.