SF.net SVN: ledger-smb:[6005] addons/1.3/b_units/trunk

[..hidden..]

Revision: 6005
          http://sourceforge.net/p/ledger-smb/code/6005
Author:   einhverfr
Date:     2013-09-12 14:48:30 +0000 (Thu, 12 Sep 2013)
Log Message:
-----------
Adding routine to pull in non-existant customers and vendors into reporting dimensions

Modified Paths:
--------------
    addons/1.3/b_units/trunk/patches/b_units.patch
    addons/1.3/b_units/trunk/sql/modules/Business_Unit.sql

Modified: addons/1.3/b_units/trunk/patches/b_units.patch
===================================================================
--- addons/1.3/b_units/trunk/patches/b_units.patch	2013-09-12 14:17:13 UTC (rev 6004)
+++ addons/1.3/b_units/trunk/patches/b_units.patch	2013-09-12 14:48:30 UTC (rev 6005)
@@ -458,7 +458,7 @@
 +                              burow = "${bucid}_$INDEX";
 +                       form.b_units.${clsid}.unshift({});
 +                       INCLUDE select element_data = {
-+                              text_attr = "control_code"
++                              text_attr = "description"
 +                             value_attr = "id"
 +                         default_values = [displayrow.${bucid}]
 +                                   name = "$burow"

Modified: addons/1.3/b_units/trunk/sql/modules/Business_Unit.sql
===================================================================
--- addons/1.3/b_units/trunk/sql/modules/Business_Unit.sql	2013-09-12 14:17:13 UTC (rev 6004)
+++ addons/1.3/b_units/trunk/sql/modules/Business_Unit.sql	2013-09-12 14:48:30 UTC (rev 6005)
@@ -215,4 +215,11 @@
        ON entity_credit_account
        FOR EACH ROW EXECUTE PROCEDURE eca_bu_trigger();
 
+INSERT INTO business_unit (class_id, control_code, description)
+select 7 - c.entity_class, c.meta_number, e.name
+  FROM entity e
+  JOIN entity_credit_account c ON c.entity_id = e.id
+ WHERE c.id NOT IN (select credit_id from business_unit 
+                     where class_id in (5, 6));
+
 COMMIT;

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


------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits