details: https://code.openbravo.com/erp/devel/pi/rev/f6907c2d08fb
changeset: 19805:f6907c2d08fb
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Tue Feb 26 23:13:02 2013 +0100
summary: issue 22881: Wrong definition of the alert
'Wrong Matched Invoice posting. Wrong currency conversion.'
diffstat:
src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccountingData.class
| 0
src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting_data.xsql
| 4 +++-
2 files changed, 3 insertions(+), 1 deletions(-)
diffs (16 lines):
diff -r 4ee9d8640045 -r f6907c2d08fb
src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccountingData.class
Binary file
src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccountingData.class
has changed
diff -r 4ee9d8640045 -r f6907c2d08fb
src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting_data.xsql
---
a/src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting_data.xsql
Tue Feb 26 22:58:05 2013 +0100
+++
b/src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting_data.xsql
Tue Feb 26 23:13:02 2013 +0100
@@ -50,7 +50,9 @@
JOIN c_invoiceline il ON mi.c_invoiceline_id = il.c_invoiceline_id
LEFT JOIN fact_acct far ON far.line_id = iol.m_inoutline_id AND
far.account_id = fa.account_id
LEFT JOIN fact_acct fi ON fi.line_id = il.c_invoiceline_id AND
fi.account_id = fa.account_id AND fi.ad_table_id = '318'
- WHERE fa.ad_table_id = '472'
+ WHERE (round((select movementqty from m_inoutline where
m_inoutline_id=mi.m_inoutline_id),2) =
+ round((select qtyinvoiced from c_invoiceline where
c_invoiceline_id=mi.c_invoiceline_id),2))
+ AND fa.ad_table_id = '472'
AND (COALESCE(far.amtacctcr + far.amtacctdr, fa.amtacctdr +
fa.amtacctcr) <> (fa.amtacctdr + fa.amtacctcr)
OR COALESCE(fi.amtacctcr + fi.amtacctdr, fa.amtacctdr +
fa.amtacctcr) <> (fa.amtacctdr + fa.amtacctcr))
AND fa.ad_client_id = ?
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
