details: https://code.openbravo.com/erp/devel/pi/rev/0bd36b5d697b changeset: 35699:0bd36b5d697b user: Nono Carballo <nonofce <at> gmail.com> date: Wed Apr 24 10:21:28 2019 +0200 summary: Fixes issue 40517: Prevents show receipts of parent organization
In Landed Cost/Receipt tab, only receipts from organization the user role has access will be shown. diffstat: src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r b71414db01be -r 0bd36b5d697b src-db/database/sourcedata/OBUISEL_SELECTOR.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Tue Apr 23 14:43:15 2019 +0200 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Wed Apr 24 10:21:28 2019 +0200 @@ -1299,7 +1299,7 @@ <!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <NAME><![CDATA[Receipts]]></NAME> <!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <AD_REFERENCE_ID><![CDATA[E68CCF4495A34ED7902293A930386B93]]></AD_REFERENCE_ID> <!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <AD_TABLE_ID><![CDATA[319]]></AD_TABLE_ID> -<!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <WHERECLAUSE><![CDATA[e.salesTransaction = false and e.documentStatus = 'CO' and exists (select 1 from MaterialMgmtMaterialTransaction t join t.goodsShipmentLine iol where iol.shipmentReceipt.id = e.id and iol.movementQuantity >= 0 and exists (select 1 from CostingRule r where r.validated = 'Y' and ad_org_isinnaturaltree(r.organization.id, t.organization.id, t.client.id) = 'Y' and r.endingDate is null and (r.startingDate is null or r.startingDate <= t.transactionProcessDate)))]]></WHERECLAUSE> +<!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <WHERECLAUSE><![CDATA[e.salesTransaction = false and e.documentStatus = 'CO' and exists (select 1 from MaterialMgmtMaterialTransaction t join t.goodsShipmentLine iol where iol.shipmentReceipt.id = e.id and iol.movementQuantity >= 0 and exists (select 1 from CostingRule r where r.validated = 'Y' and r.endingDate is null and (r.startingDate is null or r.startingDate <= t.transactionProcessDate)) and t.organization.id in (select ro.organization.id from ADRoleOrganization ro where ro.role.id = @#AD_Role_ID@))]]></WHERECLAUSE> <!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID> <!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> <!--F3CDEE79343F4746A2FEE8C60EBEC0BF--> <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE> _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
