details: https://code.openbravo.com/erp/devel/pi/rev/7b20cf4da8ef
changeset: 20481:7b20cf4da8ef
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Fri May 17 12:04:47 2013 +0200
summary: Fixed bug 23617 changed ALERT_RULE_SQL2 in
Issue21640WrongMatchInvAccounting
diffstat:
src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.class
| 0
src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.java
| 2 +-
2 files changed, 1 insertions(+), 1 deletions(-)
diffs (14 lines):
diff -r a569477afae5 -r 7b20cf4da8ef
src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.class
Binary file
src-util/modulescript/build/classes/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.class
has changed
diff -r a569477afae5 -r 7b20cf4da8ef
src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.java
---
a/src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.java
Tue May 28 12:46:06 2013 +0200
+++
b/src-util/modulescript/src/org/openbravo/modulescript/Issue21640WrongMatchInvAccounting.java
Fri May 17 12:04:47 2013 +0200
@@ -25,7 +25,7 @@
public class Issue21640WrongMatchInvAccounting extends ModuleScript {
final static private String ALERT_RULE_SQL1 = "SELECT DISTINCT
ad_column_identifier('m_matchinv', fa.record_id, 'en_US') as record_id,
fa.record_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This
Matched Invoice need to be posted again due to wrong accounting.' as
description, 'Y' as isactive, mi.ad_org_id, mi.ad_client_id, now() as created,
0 as createdBy, now() as updated, 0 as updatedBy FROM fact_acct fa JOIN
m_matchinv mi ON fa.record_id = mi.m_matchinv_id WHERE fa.ad_table_id = '472'
GROUP BY fa.fact_acct_group_id, mi.m_matchinv_id, mi.ad_org_id, fa.record_id,
mi.ad_client_id HAVING count(*) > 3";
- final static private String ALERT_RULE_SQL2 = "SELECT DISTINCT
ad_column_identifier('m_matchinv', fa.record_id, 'en_US') as record_id,
fa.record_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This
Matched Invoice need to be posted again due to wrong accounting.' as
description, 'Y' as isactive, mi.ad_org_id, mi.ad_client_id, now() as created,
0 as createdBy, now() as updated, 0 as updatedBy FROM fact_acct fa JOIN
m_matchinv mi ON fa.record_id = mi.m_matchinv_id LEFT JOIN fact_acct far ON
far.line_id = mi.m_inoutline_id AND far.account_id = fa.account_id LEFT JOIN
fact_acct fi ON fi.line_id = mi.c_invoiceline_id AND fi.account_id =
fa.account_id AND fi.ad_table_id = '318' WHERE 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))";
+ final static private String ALERT_RULE_SQL2 = "SELECT DISTINCT
ad_column_identifier('m_matchinv', fa.record_id, 'en_US') as record_id,
fa.record_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This
Matched Invoice need to be posted again due to wrong accounting.' as
description, 'Y' as isactive, mi.ad_org_id, mi.ad_client_id, now() as created,
0 as createdBy, now() as updated, 0 as updatedBy FROM fact_acct fa JOIN
m_matchinv mi ON fa.record_id = mi.m_matchinv_id LEFT JOIN fact_acct far ON
far.line_id = mi.m_inoutline_id AND far.account_id = fa.account_id LEFT JOIN
fact_acct fi ON fi.line_id = mi.c_invoiceline_id AND fi.account_id =
fa.account_id AND fi.ad_table_id = '318' 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.amtac
ctdr + fa.amtacctcr) OR COALESCE(fi.amtacctcr + fi.amtacctdr, fa.amtacctdr +
fa.amtacctcr) <> (fa.amtacctdr + fa.amtacctcr))";
final static private String ALERT_RULE1 = "Wrong Matched Invoice posting.
Wrong account.";
final static private String ALERT_RULE2 = "Wrong Matched Invoice posting.
Wrong currency conversion.";
final static private String ALERT_NAME = "This Matched Invoice need to be
posted again due to wrong accounting.";
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
