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

[..hidden..]

Revision: 6960
          http://sourceforge.net/p/ledger-smb/code/6960
Author:   einhverfr
Date:     2014-03-31 04:26:19 +0000 (Mon, 31 Mar 2014)
Log Message:
-----------
1.3 changes for changelog

Modified Paths:
--------------
    trunk/Changelog
    trunk/LedgerSMB/Upgrade_Tests.pm
    trunk/sql/upgrade/sl2.8-1.4.sql

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2014-03-31 03:06:03 UTC (rev 6959)
+++ trunk/Changelog	2014-03-31 04:26:19 UTC (rev 6960)
@@ -107,6 +107,10 @@
 Initial Release:  Monday, Oct 12 2011
 Supported Presently
 
+Changelog for 1.3.40
+* Updated nginx configuration (Pongracz I)
+* GL account search now will search within descriptions for matches (Chris T)
+
 Changelog for 1.3.39
 * Fixed Internal Server Error clicking through ar/ap report (Chris T, 1022)
 * Fixed internal server error deleting part (Chris T, 1027)

Modified: trunk/LedgerSMB/Upgrade_Tests.pm
===================================================================
--- trunk/LedgerSMB/Upgrade_Tests.pm	2014-03-31 03:06:03 UTC (rev 6959)
+++ trunk/LedgerSMB/Upgrade_Tests.pm	2014-03-31 04:26:19 UTC (rev 6960)
@@ -437,8 +437,7 @@
 push @tests, __PACKAGE__->new(
     test_query => "select *
                      from partscustomer
-                    where pricegroup_id is not null and
-                          not exists (select 1
+                    where not exists (select 1
                                         from pricegroup
                                        where id = pricegroup_id)",
     display_name => $LedgerSMB::App_State::Locale->text('Non-existing customer pricegroups in partscustomer'),

Modified: trunk/sql/upgrade/sl2.8-1.4.sql
===================================================================
--- trunk/sql/upgrade/sl2.8-1.4.sql	2014-03-31 03:06:03 UTC (rev 6959)
+++ trunk/sql/upgrade/sl2.8-1.4.sql	2014-03-31 04:26:19 UTC (rev 6960)
@@ -442,7 +442,7 @@
 -- ### Move those to business_units
 -- ### TODO: Reconciled disappeared from the source table...
 
---ALTER TABLE sl28.acc_trans ADD COLUMN entry_id integer;
+ALTER TABLE sl28.acc_trans ADD COLUMN entry_id integer;
 
 update sl28.acc_trans
   set entry_id = nextval('acc_trans_entry_id_seq');
@@ -625,10 +625,10 @@
 
 INSERT INTO jcitems(id, parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            person_id, notes, business_unit_id, total)
+            person_id, notes, business_unit_id)
      SELECT j.id,  parts_id, description, qty, allocated,
             sellprice, fxsellprice, serialnumber, checkedin, checkedout,
-            p.id, j.notes, j.project_id+1000, qty * sellprice
+            p.id, j.notes, j.project_id+1000
        FROM sl28.jcitems j
        JOIN sl28.employee e ON j.employee_id = e.id
        JOIN person p ON e.entity_id = p.entity_id;

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


------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits