details: https://code.openbravo.com/erp/devel/pi/rev/1527de35db72
changeset: 22652:1527de35db72
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri Mar 07 14:09:53 2014 +0100
summary: Fixes issue 25097: Payment in Void status
should not appear in report, as "post" button is disabled for them
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diffs (19 lines):
diff -r 39e474a762db -r 1527de35db72
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql Fri Mar
07 07:49:14 2014 +0100
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql Fri Mar
07 14:09:53 2014 +0100
@@ -192,6 +192,7 @@
where processed = 'Y'
and posted not in ('Y','D')
and isreceipt='Y'
+ and status <> 'RPVOID'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='D1A97202E832470285C9B1EB026D54E2' and ad_client_id=?)
union all
select ad_client_id, TO_CHAR(documentno) AS DOCUMENTNO, paymentdate ,
'C_Bpartner', c_bpartner_id as id, amount as GRANDTOTAL,
@@ -208,6 +209,7 @@
where processed = 'Y'
and posted not in ('Y','D')
and isreceipt='N'
+ and status <> 'RPVOID'
and 'Y'=(select max(isactive) from c_acctschema_table where
ad_table_id='D1A97202E832470285C9B1EB026D54E2' and ad_client_id=?)
union all
select ad_client_id, 'Line: ' || to_char(line) AS DOCUMENTNO,
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
