details: https://code.openbravo.com/erp/devel/pi/rev/14775af5b6a0
changeset: 26635:14775af5b6a0
user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date: Wed May 13 12:11:18 2015 +0200
summary: Fixes issue 29701 & Fixes issue 29861: Error in Price Correction
Background
IsCostCalculated will not be considered to set CheckPriceDifference flag, when
completing an invoice.
Instead, when running Price Correction Background, transactions will be
filtered by IsCostCalculated to avoid calculate price differences in
transactions where cost has not been calculated.
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 3 +--
src/org/openbravo/costing/PriceDifferenceProcess.java | 1 +
2 files changed, 2 insertions(+), 2 deletions(-)
diffs (24 lines):
diff -r 5a7da4d16d1d -r 14775af5b6a0
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Thu May 14
12:15:15 2015 +0200
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed May 13
12:11:18 2015 +0200
@@ -1504,8 +1504,7 @@
FROM C_INVOICELINE IL
JOIN M_MATCHINV MI ON IL.C_INVOICELINE_ID = MI.C_INVOICELINE_ID
JOIN M_TRANSACTION TRX ON MI.M_INOUTLINE_ID = TRX.M_INOUTLINE_ID
- WHERE TRX.ISCOSTCALCULATED = 'Y'
- AND IL.C_INVOICE_ID = v_record_id);
+ WHERE IL.C_INVOICE_ID = v_record_id);
v_ResultStr:='MatchInv-PO';
FOR Cur_ILines_PO IN
diff -r 5a7da4d16d1d -r 14775af5b6a0
src/org/openbravo/costing/PriceDifferenceProcess.java
--- a/src/org/openbravo/costing/PriceDifferenceProcess.java Thu May 14
12:15:15 2015 +0200
+++ b/src/org/openbravo/costing/PriceDifferenceProcess.java Wed May 13
12:11:18 2015 +0200
@@ -205,6 +205,7 @@
mTrxs.add(Restrictions.eq(MaterialTransaction.PROPERTY_PRODUCT,
product));
}
mTrxs.add(Restrictions.eq(MaterialTransaction.PROPERTY_CHECKPRICEDIFFERENCE,
true));
+ mTrxs.add(Restrictions.eq(MaterialTransaction.PROPERTY_ISCOSTCALCULATED,
true));
mTrxs.addOrderBy(MaterialTransaction.PROPERTY_MOVEMENTDATE, true);
mTrxs.addOrderBy(MaterialTransaction.PROPERTY_TRANSACTIONPROCESSDATE,
true);
ScrollableResults lines = mTrxs.scroll(ScrollMode.FORWARD_ONLY);
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
