details: https://code.openbravo.com/erp/devel/pi/rev/31583e78ae29 changeset: 32550:31583e78ae29 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Wed Aug 09 11:02:37 2017 +0530 summary: Fixes issue 36619: Process Generate Invoices is not working with high volumes
* Defined and used OBUI Selector Reference based reference for Sales Order parameter in Generate Invoice process. * Implemented HQL where clause in the selector based on the validation C_Order SO to be invoiced. diffstat: src-db/database/sourcedata/AD_PROCESS_PARA.xml | 4 ++-- src-db/database/sourcedata/AD_REFERENCE.xml | 12 ++++++++++++ src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 16 ++++++++++++++++ 3 files changed, 30 insertions(+), 2 deletions(-) diffs (62 lines): diff -r f4ead81d1b88 -r 31583e78ae29 src-db/database/sourcedata/AD_PROCESS_PARA.xml --- a/src-db/database/sourcedata/AD_PROCESS_PARA.xml Wed Aug 09 12:45:21 2017 +0200 +++ b/src-db/database/sourcedata/AD_PROCESS_PARA.xml Wed Aug 09 11:02:37 2017 +0530 @@ -248,8 +248,8 @@ <!--143--> <HELP><![CDATA[Unique identifier and a reference to a Sales Order originating from the document sequence defined for this document type.]]></HELP> <!--143--> <AD_PROCESS_ID><![CDATA[119]]></AD_PROCESS_ID> <!--143--> <SEQNO><![CDATA[20]]></SEQNO> -<!--143--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> -<!--143--> <AD_VAL_RULE_ID><![CDATA[134]]></AD_VAL_RULE_ID> +<!--143--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID> +<!--143--> <AD_REFERENCE_VALUE_ID><![CDATA[6DA294D48BF14CF691A301ADE4938411]]></AD_REFERENCE_VALUE_ID> <!--143--> <COLUMNNAME><![CDATA[C_Order_ID]]></COLUMNNAME> <!--143--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> <!--143--> <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH> diff -r f4ead81d1b88 -r 31583e78ae29 src-db/database/sourcedata/AD_REFERENCE.xml --- a/src-db/database/sourcedata/AD_REFERENCE.xml Wed Aug 09 12:45:21 2017 +0200 +++ b/src-db/database/sourcedata/AD_REFERENCE.xml Wed Aug 09 11:02:37 2017 +0530 @@ -5516,6 +5516,18 @@ <!--6C11958E975D4DF8A38E7F4A119A3077--> <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> <!--6C11958E975D4DF8A38E7F4A119A3077--></AD_REFERENCE> +<!--6DA294D48BF14CF691A301ADE4938411--><AD_REFERENCE> +<!--6DA294D48BF14CF691A301ADE4938411--> <AD_REFERENCE_ID><![CDATA[6DA294D48BF14CF691A301ADE4938411]]></AD_REFERENCE_ID> +<!--6DA294D48BF14CF691A301ADE4938411--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--6DA294D48BF14CF691A301ADE4938411--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--6DA294D48BF14CF691A301ADE4938411--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--6DA294D48BF14CF691A301ADE4938411--> <NAME><![CDATA[Order for invoicing]]></NAME> +<!--6DA294D48BF14CF691A301ADE4938411--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--6DA294D48BF14CF691A301ADE4938411--> <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE> +<!--6DA294D48BF14CF691A301ADE4938411--> <PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID> +<!--6DA294D48BF14CF691A301ADE4938411--> <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> +<!--6DA294D48BF14CF691A301ADE4938411--></AD_REFERENCE> + <!--7039147A5B49457DA3D13F807EC8E01F--><AD_REFERENCE> <!--7039147A5B49457DA3D13F807EC8E01F--> <AD_REFERENCE_ID><![CDATA[7039147A5B49457DA3D13F807EC8E01F]]></AD_REFERENCE_ID> <!--7039147A5B49457DA3D13F807EC8E01F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r f4ead81d1b88 -r 31583e78ae29 src-db/database/sourcedata/OBUISEL_SELECTOR.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Wed Aug 09 12:45:21 2017 +0200 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Wed Aug 09 11:02:37 2017 +0530 @@ -525,6 +525,22 @@ <!--784A05D3FE67483A85C8CB77AAEC5910--> <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY> <!--784A05D3FE67483A85C8CB77AAEC5910--></OBUISEL_SELECTOR> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--><OBUISEL_SELECTOR> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <OBUISEL_SELECTOR_ID><![CDATA[7875FD8CEC604CB3AF3ABDF9D9024CA3]]></OBUISEL_SELECTOR_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <NAME><![CDATA[Order for invoicing]]></NAME> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <AD_REFERENCE_ID><![CDATA[6DA294D48BF14CF691A301ADE4938411]]></AD_REFERENCE_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <AD_TABLE_ID><![CDATA[259]]></AD_TABLE_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <WHERECLAUSE><![CDATA[e.salesTransaction = true and e.documentStatus NOT IN ('DR','IP') AND ((e.invoiceTerms = 'O' AND NOT EXISTS (select 1 from OrderLine where salesOrder.id = e.id and orderedQuantity <> deliveredQuantity) AND EXISTS (select 1 from OrderLine where salesOrder.id = e.id and orderedQuantity <> invoicedQuantity)) OR (e.invoiceTerms = 'D' AND EXISTS (select 1 from OrderLine where salesOrder.id = e.id and orderedQuantity <> invoicedQuantity and invoicedQuantity <> deliveredQuantity)) OR (e.invoiceTerms = 'I' AND EXISTS (select 1 from OrderLine where salesOrder.id = e.id and orderedQuantity <> invoicedQuantity)))]]></WHERECLAUSE> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--> <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY> +<!--7875FD8CEC604CB3AF3ABDF9D9024CA3--></OBUISEL_SELECTOR> + <!--7B07F521E4804C89B7956E584989CC16--><OBUISEL_SELECTOR> <!--7B07F521E4804C89B7956E584989CC16--> <OBUISEL_SELECTOR_ID><![CDATA[7B07F521E4804C89B7956E584989CC16]]></OBUISEL_SELECTOR_ID> <!--7B07F521E4804C89B7956E584989CC16--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits