details: https://code.openbravo.com/erp/stable/2.50/rev/b6a534784974 changeset: 9807:b6a534784974 user: David Alsasua <david.alsasua <at> openbravo.com> date: Mon Jan 23 13:18:01 2012 +0100 summary: Fixes issue 19542. Rolls-back fix for issue 18837
details: https://code.openbravo.com/erp/stable/2.50/rev/60a41907da32 changeset: 9808:60a41907da32 user: David Alsasua <david.alsasua <at> openbravo.com> date: Tue Jan 31 11:51:27 2012 +0100 summary: Fixes issue 19542. Module-script updates incorrect invoices. In case the invoice created in complete status has been reactivated by the user, or APR module is not installed, then the module script will not modify it details: https://code.openbravo.com/erp/stable/2.50/rev/447910131369 changeset: 9809:447910131369 user: RM packaging bot <staff.rm <at> openbravo.com> date: Sat Feb 04 02:05:32 2012 +0000 summary: Update AD_MODULE version to 2.50MP38.1 details: https://code.openbravo.com/erp/stable/2.50/rev/8a33b8af0a10 changeset: 9810:8a33b8af0a10 user: RM packaging bot <staff.rm <at> openbravo.com> date: Sat Feb 04 02:05:33 2012 +0000 summary: Added tag 2.50MP38.1 for changeset 447910131369 details: https://code.openbravo.com/erp/stable/2.50/rev/c6fc6e5e0ab7 changeset: 9811:c6fc6e5e0ab7 user: RM packaging bot <staff.rm <at> openbravo.com> date: Sat Feb 04 02:05:34 2012 +0000 summary: Added signature for changeset 8a33b8af0a10 details: https://code.openbravo.com/erp/stable/2.50/rev/611b141d4335 changeset: 9812:611b141d4335 user: RM packaging bot <staff.rm <at> openbravo.com> date: Tue Feb 07 04:50:07 2012 +0000 summary: Merge temporary head for 2.50MP38.1 diffstat: .hgsigs | 3 + .hgtags | 3 + src-db/database/model/functions/AD_TABLE_IMPORT.xml | 28 +- src-db/database/model/functions/C_INVOICE_POST.xml | 2 +- src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml | 16 +- src-db/database/model/triggers/C_PROJECT_TRG.xml | 16 +- src-db/database/model/triggers/M_PRODUCT_TRG.xml | 10 + src-db/database/model/triggers/M_WAREHOUSE_TRG.xml | 11 + src-db/database/sourcedata/AD_FIELD.xml | 2 +- src-db/database/sourcedata/AD_MESSAGE.xml | 11 + src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReversalDocumentTypes.class | 0 src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReversalDocumentTypesData.class | 0 src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes.java | 1 + src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes_Data.xsql | 15 +- src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql | 1 + src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 8 +- src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction.java | 163 +++++---- src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction_data.xsql | 32 + src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java | 33 +- src/org/openbravo/erpCommon/ad_forms/DocFINPayment_data.xsql | 32 + src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java | 48 ++- src/org/openbravo/erpReports/RptM_InOut.jrxml | 151 +++++--- src/org/openbravo/erpReports/Rptm_InOut_Lines.jrxml | 8 +- 23 files changed, 436 insertions(+), 158 deletions(-) diffs (truncated from 1099 to 300 lines): diff -r fc702a4e4b8a -r 611b141d4335 .hgsigs --- a/.hgsigs Mon Jan 16 22:20:34 2012 +0000 +++ b/.hgsigs Tue Feb 07 04:50:07 2012 +0000 @@ -42,4 +42,7 @@ aab70e668acc448bc11c0bebcd7b3a35ec1a08da 0 iEYEABECAAYFAk6MJpcACgkQCX/oGf+2qkMrwACfW5iJ8sojcqnTqq/d7W8RN6A4Ei0AmwQsocf59tdPzrq7+kbeXwhMCFQz 15816c2b355a2fd77fc4f00e00170b0aaa627db6 0 iEYEABECAAYFAk6djncACgkQCX/oGf+2qkNezwCgrymU9w1xXS7t8lRe0vD1FjwUqQcAoNHdBXEqOuCA3aORWtbRqZ7N+hLY d302db790bbcf1f989ecd100069aa6257a4b9397 0 iEYEABECAAYFAk7KkgAACgkQCX/oGf+2qkPi3gCg0FBSy6AP4txrHTAptAVF+4sVQ+cAniJdy/2qR2qrVTtX0MIyHsB4ikhL +7977cc6f04317e1d0a0f47d364c1735801393f66 0 iEYEABECAAYFAk8rpMEACgkQCX/oGf+2qkMtxQCffYTUcFfT6ob8wmt5kwsfCSFoidUAoLSpbQXlcGXqpWL6fuGXIkRCBsG1 dc04cdebcc7f42c2b3b5f7644199a3c465874897 0 iEYEABECAAYFAk7p1hAACgkQCX/oGf+2qkPDNgCgrIAzQua3CPAtXC58DxjXScTvjC8AoOcMAP3eKVBu8iZAFAtkXdXD3ok0 +8a33b8af0a10fe4ab4beaee014b8dd8a23e938b1 0 iEYEABECAAYFAk8skm0ACgkQCX/oGf+2qkMV1wCfY8k0VHokC0Gc9YDB4WDJLDjT9dAAniFcJO2Eeu56b1cwOAsIt/v5BITN +625ade533d9b76e381557340e6055e8caa97607a 0 iEYEABECAAYFAk8UorMACgkQCX/oGf+2qkNHBACfT3s5sW683Fiz2KFpE4Hdoqu5ckoAoJ+vQD9L2Yfxu6qkK6dVsSlNgpno diff -r fc702a4e4b8a -r 611b141d4335 .hgtags --- a/.hgtags Mon Jan 16 22:20:34 2012 +0000 +++ b/.hgtags Tue Feb 07 04:50:07 2012 +0000 @@ -54,3 +54,6 @@ 726e45a0334b6d1e9b54b136bb1fe7ebf1da9065 2.50MP35 53fdc19c0c7b105319fbf660ad5dfb0a78b125ec 2.50MP36 5949c24c17a81ab866982e88c9c5715fdc43daeb 2.50MP37 +f846a181ff43faa405c05c69fe7533b314f4db95 2.50MP37.1 +fc702a4e4b8af0876c157ff51342f8bbb0bfeb07 2.50MP38 +447910131369188bc3f9cb73d09dc66a5944920a 2.50MP38.1 diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/model/functions/AD_TABLE_IMPORT.xml --- a/src-db/database/model/functions/AD_TABLE_IMPORT.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/model/functions/AD_TABLE_IMPORT.xml Tue Feb 07 04:50:07 2012 +0000 @@ -63,6 +63,7 @@ v_IsUpdateable CHAR(1):='Y'; v_DefaultValue NVARCHAR2(2000):=''; v_SeqNo NUMBER(10) ; + v_columnNameOrg VARCHAR2(40) ; v_columnName VARCHAR2(40) ; v_TableName VARCHAR2(40) ; v_LastColumnName VARCHAR2(40) ; @@ -236,7 +237,30 @@ IF(v_columnName LIKE '%_Id') THEN v_columnName:=SUBSTR(v_columnName, 1, LENGTH(v_columnName) -3) ||'_ID'; END IF; - + -- Some columns need to have specific names for DAL to work correctly: + v_columnNameOrg:=v_columnName; + IF(v_columnName = 'AD_Org_ID') THEN + v_columnName:='Organization'; + END IF; + IF(v_columnName = 'AD_Client_ID') THEN + v_columnName:='Client'; + END IF; + IF(v_columnName = 'Created') THEN + v_columnName:='Creation Date'; + END IF; + IF(v_columnName = 'Createdby') THEN + v_columnName:='Created By'; + END IF; + IF(v_columnName = 'Updated') THEN + v_columnName:='Updated'; + END IF; + IF(v_columnName = 'Updatedby') THEN + v_columnName:='Updated By'; + END IF; + IF(v_columnName = 'Isactive') THEN + v_columnName:='Active'; + END IF; + --Check if it is necessary to recalculate positions SELECT count(*) INTO v_Aux @@ -287,7 +311,7 @@ VALUES (v_NextNo, '0', '0', 'Y', now(), '0', now(), '0', - v_columnName, v_columnName, Cur_Column.AD_Table_ID, + v_columnName,v_columnNameOrg, Cur_Column.AD_Table_ID, v_AD_Reference_ID, v_FieldLength, v_IsKey, v_IsParent, (CASE Cur_Column.Nullable WHEN 'Y' THEN 'N' ELSE 'Y' END), v_IsIdentifier, v_SeqNo, 'N', 'N', v_IsUpdateable, v_AD_Reference_Value_ID, diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/model/functions/C_INVOICE_POST.xml --- a/src-db/database/model/functions/C_INVOICE_POST.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/model/functions/C_INVOICE_POST.xml Tue Feb 07 04:50:07 2012 +0000 @@ -608,7 +608,7 @@ C_INVOICE_POST(NULL, v_RInvoice_ID) ; -- Reversal Transaction is closed UPDATE C_INVOICE - SET DocStatus='CO', -- the reversal transaction (issue 18837) + SET DocStatus='VO', -- the reversal transaction (issue 18837) (rolledback in issue 19542) DocAction='--', Processed='Y' WHERE C_Invoice_ID=v_RInvoice_ID; diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml --- a/src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml Tue Feb 07 04:50:07 2012 +0000 @@ -56,6 +56,7 @@ v_UpdateSequence CHAR; tmp_Subaccout_no VARCHAR(32) :=null; --OBTG:varchar2-- v_C_ElementValue_ID VARCHAR(32) :=null; --OBTG:varchar2-- + v_Exist NUMBER; BEGIN IF (p_orginal_validcombination IS NULL) THEN @@ -85,15 +86,24 @@ FROM C_ValidCombination, C_ElementValue WHERE C_ValidCombination.Account_ID = C_ElementValue.C_ElementValue_ID AND C_ValidCombination_ID =p_Orginal_Validcombination; - + -- Logic for generating the New Sub account number from Original Accounts. v_Acct_No_For_SubAccount:=SUBSTR(v_Default_Account_No,1,p_Acct_Length); tmp_Subaccout_no := p_Subacct_Length - p_Acct_Length; v_Seq_No_For_Subaccount_No:= lpad(p_SequenceNo,cast(tmp_Subaccout_no as integer),'0'); v_New_Subaccount_No:= v_Acct_No_For_SubAccount || v_Seq_No_For_Subaccount_No; - /* + + --Checking if the new account already exists + SELECT count(*) + INTO v_Exist + FROM C_ElementValue WHERE VALUE =v_New_Subaccount_No; + IF (v_Exist > 0) THEN + RAISE_APPLICATION_ERROR(-20000, '@DuplicateAccount@'); + END IF; + /* Inserting the new element value for new account for Business Partner Or Product. */ + INSERT INTO C_ElementValue ( C_ElementValue_ID, @@ -183,7 +193,7 @@ FROM ad_treenode WHERE AD_TREE_ID = v_AD_TREE_ID AND NODE_ID = v_Node_ID ), SEQNO = v_SEQNO WHERE NODE_ID = V_C_ElementValue_ID; - + /* Function call to Retrieve the new account NUMBER for Business Partner or Product. */ C_ValidCombination_Insert(p_Result, v_Default_Account_Client_ID, v_Org_ID, v_C_AcctSchema_ID, v_C_ElementValue_ID, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/model/triggers/C_PROJECT_TRG.xml --- a/src-db/database/model/triggers/C_PROJECT_TRG.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/model/triggers/C_PROJECT_TRG.xml Tue Feb 07 04:50:07 2012 +0000 @@ -31,6 +31,7 @@ ************************************************************************/ v_Tree_ID VARCHAR2(32); v_Parent_ID VARCHAR2(32); + v_count NUMBER; -- TYPE RECORD IS REF CURSOR; Cur_Defaults RECORD; @@ -110,8 +111,19 @@ ) ; ELSIF (UPDATING) THEN - UPDATE C_PROJECT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID - WHERE C_PROJECT_ID = :new.C_PROJECT_ID; + + IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN + SELECT COUNT(*) INTO V_COUNT FROM C_PROJECTLINE WHERE C_PROJECT_ID = :NEW.C_PROJECT_ID; + IF(V_COUNT > 0) THEN + SELECT COUNT(*) INTO V_COUNT FROM C_PROJECTLINE WHERE C_PROJECT_ID = :NEW.C_PROJECT_ID AND AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1; + IF(V_COUNT = 0) THEN + RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ; + END IF; + END IF; + END IF; + + UPDATE C_PROJECT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID + WHERE C_PROJECT_ID = :new.C_PROJECT_ID; END IF; -- Summary Nodes first EXCEPTION diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/model/triggers/M_PRODUCT_TRG.xml --- a/src-db/database/model/triggers/M_PRODUCT_TRG.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/model/triggers/M_PRODUCT_TRG.xml Tue Feb 07 04:50:07 2012 +0000 @@ -48,6 +48,16 @@ END IF; IF (UPDATING) THEN + IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN + SELECT COUNT(*) INTO V_COUNT FROM M_PRODUCTPRICE WHERE M_PRODUCT_ID = :NEW.M_PRODUCT_ID; + IF(V_COUNT > 0) THEN + SELECT COUNT(*) INTO V_COUNT FROM M_PRODUCTPRICE WHERE M_PRODUCT_ID = :NEW.M_PRODUCT_ID AND AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1; + IF(V_COUNT = 0) THEN + RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ; + END IF; + END IF; + END IF; + UPDATE M_PRODUCT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID WHERE M_PRODUCT_ID = :new.M_PRODUCT_ID; diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/model/triggers/M_WAREHOUSE_TRG.xml --- a/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml Tue Feb 07 04:50:07 2012 +0000 @@ -28,6 +28,7 @@ TYPE RECORD IS REF CURSOR; Cur_Defaults RECORD; + v_count NUMBER; BEGIN @@ -71,6 +72,16 @@ ; END LOOP; ELSIF (UPDATING) THEN + IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN + SELECT COUNT(*) INTO V_COUNT FROM M_LOCATOR WHERE M_WAREHOUSE_ID = :NEW.M_WAREHOUSE_ID; + IF(V_COUNT > 0) THEN + SELECT COUNT(*) INTO V_COUNT FROM M_LOCATOR WHERE M_WAREHOUSE_ID = :NEW.M_WAREHOUSE_ID AND AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1; + IF(V_COUNT = 0) THEN + RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ; + END IF; + END IF; + END IF; + UPDATE M_WAREHOUSE_ACCT SET AD_ORG_ID = :new.AD_ORG_ID WHERE M_WAREHOUSE_ID = :new.M_WAREHOUSE_ID; END IF; diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/sourcedata/AD_FIELD.xml Tue Feb 07 04:50:07 2012 +0000 @@ -10027,7 +10027,7 @@ <!--727--> <AD_COLUMN_ID><![CDATA[1678]]></AD_COLUMN_ID> <!--727--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> <!--727--> <DISPLAYLENGTH><![CDATA[44]]></DISPLAYLENGTH> -<!--727--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--727--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--727--> <SEQNO><![CDATA[80]]></SEQNO> <!--727--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> <!--727--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> diff -r fc702a4e4b8a -r 611b141d4335 src-db/database/sourcedata/AD_MESSAGE.xml --- a/src-db/database/sourcedata/AD_MESSAGE.xml Mon Jan 16 22:20:34 2012 +0000 +++ b/src-db/database/sourcedata/AD_MESSAGE.xml Tue Feb 07 04:50:07 2012 +0000 @@ -34408,6 +34408,17 @@ <!--ED94DA7D967E401B93DDFFE86C9715A9--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--ED94DA7D967E401B93DDFFE86C9715A9--></AD_MESSAGE> +<!--EDF01D2A44964901BD465666A655A54B--><AD_MESSAGE> +<!--EDF01D2A44964901BD465666A655A54B--> <AD_MESSAGE_ID><![CDATA[EDF01D2A44964901BD465666A655A54B]]></AD_MESSAGE_ID> +<!--EDF01D2A44964901BD465666A655A54B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--EDF01D2A44964901BD465666A655A54B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--EDF01D2A44964901BD465666A655A54B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--EDF01D2A44964901BD465666A655A54B--> <VALUE><![CDATA[DuplicateAccount]]></VALUE> +<!--EDF01D2A44964901BD465666A655A54B--> <MSGTEXT><![CDATA[Duplicated account has been created, the length of accounts or subaccounts in organization window is wrong defined]]></MSGTEXT> +<!--EDF01D2A44964901BD465666A655A54B--> <MSGTYPE><![CDATA[E]]></MSGTYPE> +<!--EDF01D2A44964901BD465666A655A54B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--EDF01D2A44964901BD465666A655A54B--></AD_MESSAGE> + <!--EE31DD389E3B48E58D1E6E4CA5DA992D--><AD_MESSAGE> <!--EE31DD389E3B48E58D1E6E4CA5DA992D--> <AD_MESSAGE_ID><![CDATA[EE31DD389E3B48E58D1E6E4CA5DA992D]]></AD_MESSAGE_ID> <!--EE31DD389E3B48E58D1E6E4CA5DA992D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r fc702a4e4b8a -r 611b141d4335 src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReversalDocumentTypes.class Binary file src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReversalDocumentTypes.class has changed diff -r fc702a4e4b8a -r 611b141d4335 src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReversalDocumentTypesData.class Binary file src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateReversalDocumentTypesData.class has changed diff -r fc702a4e4b8a -r 611b141d4335 src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes.java --- a/src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes.java Mon Jan 16 22:20:34 2012 +0000 +++ b/src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes.java Tue Feb 07 04:50:07 2012 +0000 @@ -34,6 +34,7 @@ try { ConnectionProvider cp = getConnectionProvider(); UpdateReversalDocumentTypesData.update(cp); + UpdateReversalDocumentTypesData.updateIssue19541(cp); } catch (Exception e) { handleError(e); diff -r fc702a4e4b8a -r 611b141d4335 src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes_Data.xsql --- a/src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes_Data.xsql Mon Jan 16 22:20:34 2012 +0000 +++ b/src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes_Data.xsql Tue Feb 07 04:50:07 2012 +0000 @@ -35,4 +35,17 @@ ]]> </Sql> </SqlMethod> -</SqlClass> \ No newline at end of file + <SqlMethod name="updateIssue19541" type="preparedStatement" return="rowCount"> + <SqlMethodComment></SqlMethodComment> + <Sql> + <![CDATA[ + update c_invoice i set docstatus='VO' + where docstatus = 'CO' + and c_doctype_id in (select coalesce(c_doctype_reversed_id, c_doctype_id) from c_doctype where docbasetype in ('API','ARI','APC','ARC')) + and exists (select 1 from c_invoice_reverse r where r.c_invoice_id=i.c_invoice_id) + and not exists (select 1 from c_debt_payment dp where dp.c_invoice_id=i.c_invoice_id) + and not exists (select 1 from fin_payment_schedule ps where ps.c_invoice_id=i.c_invoice_id) + ]]> + </Sql> + </SqlMethod> +</SqlClass> diff -r fc702a4e4b8a -r 611b141d4335 src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql --- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql Mon Jan 16 22:20:34 2012 +0000 +++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFile_data.xsql Tue Feb 07 04:50:07 2012 +0000 @@ -69,6 +69,7 @@ AND DP.C_BPARTNER_ID = BP.C_BPARTNER_ID AND BP_L.C_BPARTNER_LOCATION_ID = C_GETBPLOCATIONID(BP.C_BPARTNER_ID, 'B') AND BP_L.C_LOCATION_ID = L.C_LOCATION_ID + AND BP_L.C_BPARTNER_ID = BP.C_BPARTNER_ID AND BA.IsActive = 'Y' and s.C_Remittance_ID = ? ]]> diff -r fc702a4e4b8a -r 611b141d4335 src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql --- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql Mon Jan 16 22:20:34 2012 +0000 +++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql Tue Feb 07 04:50:07 2012 +0000 @@ -372,7 +372,13 @@ AND NOT EXISTS (SELECT 1 FROM C_INVOICE_CANDIDATE_V ic, C_ORDER o ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
