details: https://code.openbravo.com/erp/devel/pi/rev/653ed78431dc changeset: 28147:653ed78431dc user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Dec 15 14:54:22 2015 +0100 summary: Fixed bug 31695: Return to vendor shipments can be selected in return to vendor
The HQL query in charge of getting the shipment lines was wrongly including all the shipment documents. Instead it should be taking only the lines belonging to a non-return shipment document. This feature was lost during the refactor to a manual datasource P&E diffstat: src-db/database/sourcedata/AD_TABLE.xml | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diffs (13 lines): diff -r ba5c3ba713b0 -r 653ed78431dc src-db/database/sourcedata/AD_TABLE.xml --- a/src-db/database/sourcedata/AD_TABLE.xml Wed Dec 16 11:13:35 2015 +0100 +++ b/src-db/database/sourcedata/AD_TABLE.xml Tue Dec 15 14:54:22 2015 +0100 @@ -11899,7 +11899,9 @@ MAINFROM MaterialMgmtShipmentInOutLine as iol left join iol.attributeSetValue as attributeSetValue join iol.shipmentReceipt as io +join io.documentType as dt where io.businessPartner.id = :businessPartnerId +and dt.return = false and io.processed = true and io.documentStatus <> 'VO' and io.salesTransaction = @isSalesTransaction@ and (iol.movementQuantity+(@returnedOthersLeftClause@) <> 0) ------------------------------------------------------------------------------ _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits