SF.net SVN: ledger-smb:[6436] trunk/sql/modules/Assets.sql

[..hidden..]

Revision: 6436
          http://sourceforge.net/p/ledger-smb/code/6436
Author:   einhverfr
Date:     2014-01-10 13:05:12 +0000 (Fri, 10 Jan 2014)
Log Message:
-----------
Fixes to fixed asset/asset class stored procs

Modified Paths:
--------------
    trunk/sql/modules/Assets.sql

Modified: trunk/sql/modules/Assets.sql
===================================================================
--- trunk/sql/modules/Assets.sql	2014-01-10 12:54:32 UTC (rev 6435)
+++ trunk/sql/modules/Assets.sql	2014-01-10 13:05:12 UTC (rev 6436)
@@ -272,7 +272,8 @@
 BEGIN
 	FOR out_var IN
 		SELECT ac.id, ac.asset_account_id, aa.accno, aa.description, 
-			ad.accno, ad.description, m.method, ac.method,
+			ac.dep_account_id, ad.accno, ad.description, 
+                        m.method, ac.method,
 			ac.label
 		FROM asset_class ac
 		JOIN account aa ON (aa.id = ac.asset_account_id)
@@ -374,7 +375,7 @@
 			or asset_class_id = in_asset_class)
 			AND (in_description is null or description 
 				LIKE '%' || in_description || '%')
-			and (in_tag is not null or tag like '%'||in_tag||'%')
+			and (in_tag is null or tag like '%'||in_tag||'%')
 			AND (in_purchase_date is null 
 				or purchase_date = in_purchase_date)
 			AND (in_purchase_value is null

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


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits