[Fmsystem-commits] [12757] property: alter transfer rule for invoice

[Sigurd Nes]

Revision: 12757
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=12757
Author:   sigurdne
Date:     2015-02-17 18:16:11 +0000 (Tue, 17 Feb 2015)
Log Message:
-----------
property: alter transfer rule for invoice

Modified Paths:
--------------
    trunk/property/inc/export/default/Agresso_X114

Modified: trunk/property/inc/export/default/Agresso_X114
===================================================================
--- trunk/property/inc/export/default/Agresso_X114      2015-02-17 13:55:49 UTC 
(rev 12756)
+++ trunk/property/inc/export/default/Agresso_X114      2015-02-17 18:16:11 UTC 
(rev 12757)
@@ -151,7 +151,8 @@
                        }
                        else
                        {
-                               $sql= "SELECT DISTINCT fm_ecobilag.bilagsnr 
FROM fm_ecobilag {$this->join} fm_ecobilag_sum_view ON fm_ecobilag.bilagsnr = 
fm_ecobilag_sum_view.bilagsnr WHERE  approved_amount = '0.00' OR ( 
budsjettsigndato IS NOT NULL AND (saksigndato IS NOT NULL OR oppsynsigndato IS 
NOT NULL) ) ORDER BY bilagsnr ASC";
+                               $sql= "SELECT DISTINCT fm_ecobilag.bilagsnr 
FROM fm_ecobilag {$this->join} fm_ecobilag_sum_view ON fm_ecobilag.bilagsnr = 
fm_ecobilag_sum_view.bilagsnr"
+                                       . " WHERE  approved_amount = '0.00' OR 
( budsjettsigndato IS NOT NULL AND saksigndato IS NOT NULL) ORDER BY bilagsnr 
ASC";
                        }
                        $this->db->query($sql,__LINE__,__FILE__);
                        $vouchers_step1 = array();