[OpenbravoERP-commits] devel/pi: Fixes Issue 13999: invoice post does not work when exi...
details: /erp/devel/pi/rev/acce63739f67 changeset: 7929:acce63739f67 user: Sathiyan Sivaprakasam openbravo.com> date: Wed Jul 28 10:37:35 2010 +0530 summary: Fixes Issue 13999: invoice post does not work when exists debt payment diffstat: src-db/database/model/functions/C_INVOICE_POST.xml | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diffs (11 lines): diff -r d9f3f00f2774 -r acce63739f67 src-db/database/model/functions/C_INVOICE_POST.xml --- a/src-db/database/model/functions/C_INVOICE_POST.xmlTue Jul 27 22:09:07 2010 +0200 +++ b/src-db/database/model/functions/C_INVOICE_POST.xmlWed Jul 28 10:37:35 2010 +0530 @@ -1560,6 +1560,7 @@ AND C_SETTLEMENT_GENERATE_ID IS NOT NULL AND Ad_Isorgincluded(v_Org_id, dp.ad_org_id,v_Client_ID) != -1 AND ad_client_id = v_Client_ID +AND C_INVOICE_ID=v_Record_ID AND EXISTS (SELECT 1 FROM C_SETTLEMENT S WHERE DP.C_SETTLEMENT_GENERATE_ID = S.C_Settlement_ID -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/main: 7 new changesets
details: /erp/devel/main/rev/ff9d8e6fe070 changeset: 7972:ff9d8e6fe070 user: Harikrishnan Raja openbravo.com> date: Tue Jul 27 17:11:31 2010 +0530 summary: Fixes Issue 14016: It is not possible save a line with a price adjustment. details: /erp/devel/main/rev/3cbb2e1e1ce5 changeset: 7973:3cbb2e1e1ce5 user: Juan Pablo Aroztegi openbravo.com> date: Tue Jul 27 16:39:03 2010 +0200 summary: Fixes issue 13519: disallow running ant tasks as root To override this check, two options: 1) Add the -Dallow.root=true argument to the ant command. 2) Add allow.root=true to the config/Openbravo.properties file details: /erp/devel/main/rev/d91bd76b1bd0 changeset: 7974:d91bd76b1bd0 user: Antonio Moreno openbravo.com> date: Tue Jul 27 12:19:39 2010 +0200 summary: Fixed issue 14059. Added property to bypass build validations details: /erp/devel/main/rev/c1df94e38a27 changeset: 7975:c1df94e38a27 user: Antonio Moreno openbravo.com> date: Tue Jul 27 17:32:06 2010 +0200 summary: Fixed issue 14060. Changed handling of illegal datatypes Now, both update.database and update.database.mod will fail early if an illegal datatype is detected either in the database or in the XML files, therefore minimizing the risk of data loss. Before, the change was attempted, usually ending in failure, and in some cases, with loss of data, due to failed recreation of the table. details: /erp/devel/main/rev/73f4cd5e50ab changeset: 7976:73f4cd5e50ab user: Juan Pablo Aroztegi openbravo.com> date: Tue Jul 27 17:34:38 2010 +0200 summary: Related to issue 13519: document allow.root in Openbravo.properties details: /erp/devel/main/rev/2fd8dd5484c0 changeset: 7977:2fd8dd5484c0 user: RM packaging bot openbravo.com> date: Tue Jul 27 23:48:45 2010 +0200 summary: CI: promote changesets from pi to main details: /erp/devel/main/rev/5cf2bb15d5b1 changeset: 7978:5cf2bb15d5b1 user: RM packaging bot openbravo.com> date: Tue Jul 27 23:48:46 2010 +0200 summary: CI: update AD_MODULE - Core version and label diffstat: .hgsigs |1 + .hgtags |1 + build.xml | 24 +++- config/Openbravo.properties.template|8 ++ src-db/database/lib/dbsourcemanager.jar |0 src-db/database/model/triggers/C_ORDERLINE_TRG2.xml |2 +- src-db/database/sourcedata/AD_MODULE.xml|4 +- src-util/buildvalidation/build.xml |2 +- 8 files changed, 37 insertions(+), 5 deletions(-) diffs (140 lines): diff -r 6834c4694499 -r 5cf2bb15d5b1 .hgsigs --- a/.hgsigs Tue Jul 27 10:12:49 2010 +0200 +++ b/.hgsigs Tue Jul 27 23:48:46 2010 +0200 @@ -20,3 +20,4 @@ 9f343a616b2f998c3867661467de5dd9daeb7112 0 iEYEABECAAYFAkvq7PIACgkQCX/oGf+2qkMcHQCg3eHGql848ExhA5oOgtqfjIE3toUAn0GiWHkItn3YxPFitn8+e0IfOEaj 9b4bbe8362f54f7212653fddf5bd053183a7ffda 0 iEYEABECAAYFAkv8vDgACgkQCX/oGf+2qkPC3ACfURoh78/OY95XuFkAKNfaLQQzuCsAoNoNLdSqMVYuAJMAI2mimGZ5BXaw 7fe932c5c015da84a972d6945dd0451366bbf325 0 iEYEABECAAYFAkwodmcACgkQCX/oGf+2qkM4jQCgq2n4X0Tzi8EcGqNLhtzjOJ/1YcgAn3Fh9aZRpXmM2zYmMwuecn4UR5tt +618363224a381737439e0bd4461e2d36c4fd986e 0 iEYEABECAAYFAkxFkHoACgkQCX/oGf+2qkP7DQCeK9qCv3jETpO5iM89PV2bJYmpErMAoO/H2QyeKKZjublcgFmH7g1tEomB diff -r 6834c4694499 -r 5cf2bb15d5b1 .hgtags --- a/.hgtags Tue Jul 27 10:12:49 2010 +0200 +++ b/.hgtags Tue Jul 27 23:48:46 2010 +0200 @@ -30,3 +30,4 @@ 41915c2f5ec639dadab8e797a1e5f1e0922fa029 2.50MP17 f7b9678ebb10f1fb0963b7e3cc4724aa6aeca565 2.50MP18 34eed7b386965b19e191fbfe03195588cdc75254 2.50MP19 +99ff33f6588973f7e738b6afd47ad44f3ac08d20 2.50MP20 diff -r 6834c4694499 -r 5cf2bb15d5b1 build.xml --- a/build.xml Tue Jul 27 10:12:49 2010 +0200 +++ b/build.xml Tue Jul 27 23:48:46 2010 +0200 @@ -100,6 +100,7 @@ + @@ -177,6 +178,13 @@ + + + + + + + @@ -188,7 +196,17 @@ - + + + + + + + + + + + @@ -298,6 +316,7 @@ + @@ -389,6 +408,9 @@ + + + diff -r 6834c4694499 -r 5cf2bb15d5b1 config/Openbravo.properties.template --- a/config/Openbravo.properties.template Tue Jul 27 10:12:49 2010 +0200 +++ b/config/Openbravo.properties.template Tue Jul 27 23:48:46 2010 +0200 @@ -175,3 +175,11 @@ login.trial.delay.increment=0 login.trial.delay.max=0 login.trial.user.lock=0 + +## +# Others # +## + +# You are not allowed to run ant commands with the root user. +# Set allow.root to true to override this. +allow.root=false diff -r 6834c4694499 -r 5cf2bb15d5b1 src-db/database/lib/dbsourcemanager.jar Binary file src-db/database/lib/dbsourcemanager.jar has changed diff -r 6834c4694499 -r 5cf2bb15d5b1 src-db/database/model
[OpenbravoERP-commits] devel/pi: Related to issue 13519: document allow.root in Openbra...
details: /erp/devel/pi/rev/73f4cd5e50ab changeset: 7927:73f4cd5e50ab user: Juan Pablo Aroztegi openbravo.com> date: Tue Jul 27 17:34:38 2010 +0200 summary: Related to issue 13519: document allow.root in Openbravo.properties diffstat: config/Openbravo.properties.template | 8 1 files changed, 8 insertions(+), 0 deletions(-) diffs (15 lines): diff -r c1df94e38a27 -r 73f4cd5e50ab config/Openbravo.properties.template --- a/config/Openbravo.properties.template Tue Jul 27 17:32:06 2010 +0200 +++ b/config/Openbravo.properties.template Tue Jul 27 17:34:38 2010 +0200 @@ -175,3 +175,11 @@ login.trial.delay.increment=0 login.trial.delay.max=0 login.trial.user.lock=0 + +## +# Others # +## + +# You are not allowed to run ant commands with the root user. +# Set allow.root to true to override this. +allow.root=false -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/pi: 2 new changesets
details: /erp/devel/pi/rev/d91bd76b1bd0 changeset: 7925:d91bd76b1bd0 user: Antonio Moreno openbravo.com> date: Tue Jul 27 12:19:39 2010 +0200 summary: Fixed issue 14059. Added property to bypass build validations details: /erp/devel/pi/rev/c1df94e38a27 changeset: 7926:c1df94e38a27 user: Antonio Moreno openbravo.com> date: Tue Jul 27 17:32:06 2010 +0200 summary: Fixed issue 14060. Changed handling of illegal datatypes Now, both update.database and update.database.mod will fail early if an illegal datatype is detected either in the database or in the XML files, therefore minimizing the risk of data loss. Before, the change was attempted, usually ending in failure, and in some cases, with loss of data, due to failed recreation of the table. diffstat: build.xml |4 src-db/database/lib/dbsourcemanager.jar |0 src-util/buildvalidation/build.xml |2 +- 3 files changed, 5 insertions(+), 1 deletions(-) diffs (35 lines): diff -r 3cbb2e1e1ce5 -r c1df94e38a27 build.xml --- a/build.xml Tue Jul 27 16:39:03 2010 +0200 +++ b/build.xml Tue Jul 27 17:32:06 2010 +0200 @@ -100,6 +100,7 @@ + @@ -407,6 +408,9 @@ + + + diff -r 3cbb2e1e1ce5 -r c1df94e38a27 src-db/database/lib/dbsourcemanager.jar Binary file src-db/database/lib/dbsourcemanager.jar has changed diff -r 3cbb2e1e1ce5 -r c1df94e38a27 src-util/buildvalidation/build.xml --- a/src-util/buildvalidation/build.xmlTue Jul 27 16:39:03 2010 +0200 +++ b/src-util/buildvalidation/build.xmlTue Jul 27 17:32:06 2010 +0200 @@ -99,7 +99,7 @@ - + -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/pi: Fixes issue 13519: disallow running ant tasks as root
details: /erp/devel/pi/rev/3cbb2e1e1ce5 changeset: 7924:3cbb2e1e1ce5 user: Juan Pablo Aroztegi openbravo.com> date: Tue Jul 27 16:39:03 2010 +0200 summary: Fixes issue 13519: disallow running ant tasks as root To override this check, two options: 1) Add the -Dallow.root=true argument to the ant command. 2) Add allow.root=true to the config/Openbravo.properties file diffstat: build.xml | 20 +++- 1 files changed, 19 insertions(+), 1 deletions(-) diffs (44 lines): diff -r ff9d8e6fe070 -r 3cbb2e1e1ce5 build.xml --- a/build.xml Tue Jul 27 17:11:31 2010 +0530 +++ b/build.xml Tue Jul 27 16:39:03 2010 +0200 @@ -177,6 +177,13 @@ + + + + + + + @@ -188,7 +195,17 @@ - + + + + + + + + + + + @@ -298,6 +315,7 @@ + -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/main: 24 new changesets
details: /erp/devel/main/rev/220470337d06 changeset: 7948:220470337d06 user: Antonio Moreno openbravo.com> date: Wed Jul 21 13:13:07 2010 +0200 summary: Fixed issue 14020. oncreatedefaults which reference other columns should work now. > The main change basically has been not to execute the oncreatedefault on the > INSERT SELECT statement which is executed when a table is recreated. This > will allow oncreatedefaults which reference other tables and columns to work, > and the statements shouldn't be needed anyway, because the same > oncreatedefault is executed at the end of the update.database process, and > the NOT NULL constraints are not activated when the data is copied. details: /erp/devel/main/rev/6d562dba2dfa changeset: 7949:6d562dba2dfa user: Mikel Irurita openbravo.com> date: Wed Jul 21 16:42:52 2010 +0200 summary: Fixes issue 13742 and 13868: improve fields text. 13742: Column names are not rightly defined in Grid view for Payment method tab in financial account window. 13868: In purchase invoice, Payment plan tab, Field label Receive to be changed to Paid details: /erp/devel/main/rev/b788095e7704 changeset: 7950:b788095e7704 user: Juan Pablo Aroztegi openbravo.com> date: Wed Jul 21 18:07:54 2010 +0200 summary: Fixes issue 14029. ant setup: get the 32bit binary in 64bit Windows details: /erp/devel/main/rev/289974ed369e changeset: 7951:289974ed369e user: Sivaraman Rajagopal openbravo.com> date: Thu Jul 22 09:56:13 2010 +0530 summary: Fixes issue 13900: The Payment Tracker does not work with a big amount of data Pagination has been implemented for Payment Tracker report and also validation rule has been implemented for exporting PDF functionality. details: /erp/devel/main/rev/152032f5fa94 changeset: 7952:152032f5fa94 user: Harikrishnan Raja openbravo.com> date: Thu Jul 22 09:59:28 2010 +0530 summary: Fixes Issue 13870: warehouse/Storage bin for inactive organisation are selectable in screens details: /erp/devel/main/rev/5013a579164c changeset: 7953:5013a579164c user: Sivaraman Rajagopal openbravo.com> date: Thu Jul 22 10:02:25 2010 +0530 summary: Fixes issue 13732: The field where clause on the alert definition window does not work well if you want to refere to ad_user_id field Alias names of the tables have been removed from select queries in order to avoid ambiguity in defining where clause details: /erp/devel/main/rev/d24e1139ded8 changeset: 7954:d24e1139ded8 user: Adrián Romero openbravo.com> date: Thu Jul 22 18:22:49 2010 +0200 summary: Fixes issue 0013959: Error division by zero when processing Purchasing Plan It has been added a check that verifies when the capacity is zero and raises an error message explaining it details: /erp/devel/main/rev/a24b3384f853 changeset: 7955:a24b3384f853 user: Sathiyan Sivaprakasam openbravo.com> date: Fri Jul 23 10:49:14 2010 +0530 summary: Fixed issues 13979: setMessageResult should be public in AcctServer details: /erp/devel/main/rev/eace8ee261f0 changeset: 7956:eace8ee261f0 user: Balamurugan Ramadoss openbravo.com> date: Fri Jul 23 13:17:58 2010 +0530 summary: Fixed Issue 0014001: It isnt possible process a remittance. details: /erp/devel/main/rev/bba492491e7e changeset: 7957:bba492491e7e user: Balamurugan Ramadoss openbravo.com> date: Fri Jul 23 13:41:02 2010 +0530 summary: Fixed Issue 0013991: incorrect characters in Report Budget. details: /erp/devel/main/rev/965b96738de4 changeset: 7958:965b96738de4 user: Asier Lostalé openbravo.com> date: Fri Jul 23 10:51:43 2010 +0200 summary: fixed bug 13983: Add new table to core dataset not possible without core in dev The module checked to be in development was the one in parent AD_Dataset, not the one in the record itself. This has been fixed for AD_Dataset_Table and AD_Dataset_Column. details: /erp/devel/main/rev/303db86de507 changeset: 7959:303db86de507 user: Balamurugan Ramadoss openbravo.com> date: Fri Jul 23 14:30:28 2010 +0530 summary: Fixed Issue 0013992: It does not possible open a Report Budget with EXCEL details: /erp/devel/main/rev/fa203c41fbfd changeset: 7960:fa203c41fbfd user: Antonio Moreno openbravo.com> date: Fri Jul 23 13:03:10 2010 +0200 summary: Related to issue 13947. Cleaned update.database.mod changes a bit. Moved log messages inside the if() clause, so that if they will not be shown if there is no database model to update for that particular module. Also, moved the removeDeletedFKTriggers method call inside that if clause too, for basically the same reason. details: /erp/devel/main/rev/d7482229a1ec changeset: 7961:d7482229a1ec user: Stefan Hühner openbravo.com> date: Thu Jul 22 16:05:00 2010 +0200 summary: Fixed 14035: fact_acct_reset is too slow Speed up this pl-function by: - add missing index to c_periodcontrol table - move one function ca
[OpenbravoERP-commits] devel/pi: Fixes Issue 14016: It is not possible save a line with...
details: /erp/devel/pi/rev/ff9d8e6fe070 changeset: 7923:ff9d8e6fe070 user: Harikrishnan Raja openbravo.com> date: Tue Jul 27 17:11:31 2010 +0530 summary: Fixes Issue 14016: It is not possible save a line with a price adjustment. diffstat: src-db/database/model/triggers/C_ORDERLINE_TRG2.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r 6834c4694499 -r ff9d8e6fe070 src-db/database/model/triggers/C_ORDERLINE_TRG2.xml --- a/src-db/database/model/triggers/C_ORDERLINE_TRG2.xml Tue Jul 27 10:12:49 2010 +0200 +++ b/src-db/database/model/triggers/C_ORDERLINE_TRG2.xml Tue Jul 27 17:11:31 2010 +0530 @@ -184,7 +184,7 @@ VALUES (v_OrderLine_Offer_ID, :NEW.AD_Client_ID, :NEW.AD_Org_ID, :NEW.IsActive, now(),:NEW.CreatedBy, now(),:NEW.UpdatedBy, - :NEW.C_OrderLine_ID, v_lineno, Cur_Offer.M_Offer_Id, ROUND(v_Price,v_Precision), ROUND(v_Amt,v_Precision)); + :NEW.C_OrderLine_ID, v_lineno, Cur_Offer.M_Offer_Id, COALESCE(ROUND(v_Price,v_Precision),0), COALESCE(ROUND(v_Amt,v_Precision),0)); v_Price := v_PriceNew; END IF; END LOOP; -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
[OpenbravoERP-commits] devel/pi: Fixes issue 13604: payment method - financial account ...
details: /erp/devel/pi/rev/6834c4694499 changeset: 7922:6834c4694499 user: Mikel Irurita openbravo.com> date: Tue Jul 27 10:12:49 2010 +0200 summary: Fixes issue 13604: payment method - financial account assignment Changed name of the message (FIN_FINACC_PAYMETHOD_UN) More meaningful message is shown now when you try to assign the same method twice to the same financial account. diffstat: src-db/database/model/tables/FIN_FINACC_PAYMENTMETHOD.xml | 8 src-db/database/sourcedata/AD_MESSAGE.xml | 2 +- 2 files changed, 5 insertions(+), 5 deletions(-) diffs (30 lines): diff -r f1b53dfc9e0d -r 6834c4694499 src-db/database/model/tables/FIN_FINACC_PAYMENTMETHOD.xml --- a/src-db/database/model/tables/FIN_FINACC_PAYMENTMETHOD.xml Mon Jul 26 19:27:40 2010 +0200 +++ b/src-db/database/model/tables/FIN_FINACC_PAYMENTMETHOD.xml Tue Jul 27 10:12:49 2010 +0200 @@ -131,10 +131,10 @@ - - - - + + + + diff -r f1b53dfc9e0d -r 6834c4694499 src-db/database/sourcedata/AD_MESSAGE.xml --- a/src-db/database/sourcedata/AD_MESSAGE.xml Mon Jul 26 19:27:40 2010 +0200 +++ b/src-db/database/sourcedata/AD_MESSAGE.xml Tue Jul 27 10:12:49 2010 +0200 @@ -31932,7 +31932,7 @@ - + -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ ___ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits