details: https://code.openbravo.com/erp/devel/pi/rev/231186969ee7 changeset: 34099:231186969ee7 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Fri May 25 04:22:07 2018 +0530 summary: Fixes Issue 38581: It should not be possible to process a Landed Cost Matching when the Landed Cost is in draft status
In where clause of HQL query for table used in loading Landed Costs in Match LC Costs process definition pop up window, add condition to check whether LC records are processed. diffstat: src-db/database/sourcedata/AD_TABLE.xml | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diffs (11 lines): diff -r b4f84955d338 -r 231186969ee7 src-db/database/sourcedata/AD_TABLE.xml --- a/src-db/database/sourcedata/AD_TABLE.xml Tue May 29 15:00:27 2018 +0000 +++ b/src-db/database/sourcedata/AD_TABLE.xml Fri May 25 04:22:07 2018 +0530 @@ -11971,6 +11971,7 @@ left join lcc.landedCostMatchedList as lcm with lcm.invoiceLine.id = :invlineid, InvoiceLine as il where (lcc.matched = false or lcm is not null) + and lc.processed = true and @additional_filters@ and @insertion_point_0@ group by coalesce(lcm.id, lcc.id), lcc, lct.name, lcc.amount, lcc.currency.iSOCode, lcm.amount, case when lcm is not null then true else false end, lc.referenceDate, lcc.matched, lcc.isMatchingAdjusted, lcm.id, lcc.id, il, lc.documentNo, lcc.lineNo, lcc.processed, lcm.amountInInvoiceCurrency]]></HQLQUERY> ------------------------------------------------------------------------------ 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
