SF.net SVN: ledger-smb:[2943] addons/1.3/assets/trunk/sql/modules/Assets. sql

[..hidden..]

Revision: 2943
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2943&view=rev
Author:   einhverfr
Date:     2010-03-03 17:02:45 +0000 (Wed, 03 Mar 2010)

Log Message:
-----------
Corrected syntax error in sql

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-03-03 16:57:41 UTC (rev 2942)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-03-03 17:02:45 UTC (rev 2943)
@@ -636,7 +636,7 @@
  GROUP BY ai.id, ai.tag, ai.description, ai.purchase_value, ai.usable_life,
           ai.purchase_date, ai.location_id, ai.invoice_id, ai.asset_account_id,
           ai.dep_account_id, ai.asset_class_id, ai.start_depreciation,
-          ai.salvage_value, ai.department_id
+          ai.salvage_value, ai.department_id, ai.exp_account_id
    HAVING coalesce(max(ar.report_class), 1) = 1
           AND (ai.purchase_value - coalesce(sum(arl.amount), 0) 
                > ai.salvage_value


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