details: https://code.openbravo.com/erp/devel/pi/rev/ba1589a113f8 changeset: 18534:ba1589a113f8 user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> date: Wed Nov 07 16:26:27 2012 +0100 summary: Fixed issue 22221 Status value is showed with ** in Payment Details tab
details: https://code.openbravo.com/erp/devel/pi/rev/5e630e9025c7 changeset: 18535:5e630e9025c7 user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> date: Fri Nov 09 14:30:48 2012 +0100 summary: Fixes Issue 21977: Copy accounts from Product Category is not working properly details: https://code.openbravo.com/erp/devel/pi/rev/49a5033ab971 changeset: 18536:49a5033ab971 user: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com> date: Mon Nov 12 10:42:47 2012 +0100 summary: Fixes Issue 22260: Book button in the Sales Order should go first diffstat: src-db/database/model/functions/M_PRODUCT_CATEGORY_ACCT_COPY.xml | 9 ++++ src-db/database/sourcedata/AD_AUXILIARINPUT.xml | 22 ++++++++++ src-db/database/sourcedata/AD_FIELD.xml | 2 +- 3 files changed, 32 insertions(+), 1 deletions(-) diffs (91 lines): diff -r d88989e6c96e -r 49a5033ab971 src-db/database/model/functions/M_PRODUCT_CATEGORY_ACCT_COPY.xml --- a/src-db/database/model/functions/M_PRODUCT_CATEGORY_ACCT_COPY.xml Wed Oct 31 13:06:17 2012 +0100 +++ b/src-db/database/model/functions/M_PRODUCT_CATEGORY_ACCT_COPY.xml Mon Nov 12 10:42:47 2012 +0100 @@ -45,6 +45,7 @@ -- v_M_Product_Category_ID VARCHAR2(32); v_C_Acctschema_ID VARCHAR2(32); + v_AcctSchemaOrgId VARCHAR2(32); -- Product Category is unique to Client Cur_Acct RECORD; -- @@ -108,6 +109,12 @@ OR AD_IsOrgIncluded(M_Product_Category_Acct.AD_Org_ID, oa.AD_Org_ID, M_Product_Category_Acct.AD_Client_ID)<>-1)) ) LOOP + + SELECT Ad_Org_ID + INTO v_AcctSchemaOrgId + FROM C_AcctSchema + WHERE C_AcctSchema_ID = Cur_Acct.C_AcctSchema_ID; + -- Update existing Products UPDATE M_Product_Acct SET P_Revenue_Acct=Cur_Acct.P_Revenue_Acct, @@ -130,6 +137,7 @@ FROM M_Product p WHERE p.M_Product_ID=M_Product_Acct.M_Product_ID AND p.M_Product_Category_ID=Cur_Acct.M_Product_Category_ID + AND Ad_Org_IsInNaturalTree(p.Ad_Org_ID,v_AcctSchemaOrgId, p.AD_Client_ID) = 'Y' ) ; rowcount:=SQL%ROWCOUNT; @@ -151,6 +159,7 @@ Cur_Acct.P_PurchasePriceVariance_Acct, Cur_Acct.P_InvoicePriceVariance_Acct, Cur_Acct.P_TradeDiscountRec_Acct, Cur_Acct.P_TradeDiscountGrant_Acct FROM M_Product p WHERE p.M_Product_Category_ID=Cur_Acct.M_Product_Category_ID + AND Ad_Org_IsInNaturalTree(p.Ad_Org_ID,v_AcctSchemaOrgId, p.AD_Client_ID) = 'Y' AND NOT EXISTS (SELECT * FROM M_Product_Acct pa diff -r d88989e6c96e -r 49a5033ab971 src-db/database/sourcedata/AD_AUXILIARINPUT.xml --- a/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Wed Oct 31 13:06:17 2012 +0100 +++ b/src-db/database/sourcedata/AD_AUXILIARINPUT.xml Mon Nov 12 10:42:47 2012 +0100 @@ -1198,6 +1198,17 @@ <!--42599C834F074611AF7AF4B638D73342--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--42599C834F074611AF7AF4B638D73342--></AD_AUXILIARINPUT> +<!--47EA41253EA841C0BF2437B5677F0BDE--><AD_AUXILIARINPUT> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <AD_AUXILIARINPUT_ID><![CDATA[47EA41253EA841C0BF2437B5677F0BDE]]></AD_AUXILIARINPUT_ID> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <AD_TAB_ID><![CDATA[9817E22E2536417F8C9AEC8D5FA33E18]]></AD_TAB_ID> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <NAME><![CDATA[IsReceipt]]></NAME> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <CODE><![CDATA[N]]></CODE> +<!--47EA41253EA841C0BF2437B5677F0BDE--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--47EA41253EA841C0BF2437B5677F0BDE--></AD_AUXILIARINPUT> + <!--47F42EA77ACD4026AF7F41C2D90146C4--><AD_AUXILIARINPUT> <!--47F42EA77ACD4026AF7F41C2D90146C4--> <AD_AUXILIARINPUT_ID><![CDATA[47F42EA77ACD4026AF7F41C2D90146C4]]></AD_AUXILIARINPUT_ID> <!--47F42EA77ACD4026AF7F41C2D90146C4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -1904,6 +1915,17 @@ <!--B6286BA3CA2C46399621277A75BA7569--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--B6286BA3CA2C46399621277A75BA7569--></AD_AUXILIARINPUT> +<!--B87967F7CAA34EDE9E81E5737A4330F0--><AD_AUXILIARINPUT> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <AD_AUXILIARINPUT_ID><![CDATA[B87967F7CAA34EDE9E81E5737A4330F0]]></AD_AUXILIARINPUT_ID> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <AD_TAB_ID><![CDATA[F6C2283A21314407BBBB23FF14B85ED4]]></AD_TAB_ID> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <NAME><![CDATA[IsReceipt]]></NAME> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <CODE><![CDATA[Y]]></CODE> +<!--B87967F7CAA34EDE9E81E5737A4330F0--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--B87967F7CAA34EDE9E81E5737A4330F0--></AD_AUXILIARINPUT> + <!--BAE1E97A2AB34E92BEFF8BE84D82FAA1--><AD_AUXILIARINPUT> <!--BAE1E97A2AB34E92BEFF8BE84D82FAA1--> <AD_AUXILIARINPUT_ID><![CDATA[BAE1E97A2AB34E92BEFF8BE84D82FAA1]]></AD_AUXILIARINPUT_ID> <!--BAE1E97A2AB34E92BEFF8BE84D82FAA1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r d88989e6c96e -r 49a5033ab971 src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Wed Oct 31 13:06:17 2012 +0100 +++ b/src-db/database/sourcedata/AD_FIELD.xml Mon Nov 12 10:42:47 2012 +0100 @@ -14417,7 +14417,7 @@ <!--1083--> <DISPLAYLOGIC><![CDATA[@DocStatus@!'VO'&@DocStatus@!'CL']]></DISPLAYLOGIC> <!--1083--> <DISPLAYLENGTH><![CDATA[23]]></DISPLAYLENGTH> <!--1083--> <ISREADONLY><![CDATA[N]]></ISREADONLY> -<!--1083--> <SEQNO><![CDATA[346]]></SEQNO> +<!--1083--> <SEQNO><![CDATA[336]]></SEQNO> <!--1083--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--1083--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> <!--1083--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
