0021336: Voided invoices appear in report, under some circumstances

Description

Voided invoices appear in report, under some circumstances

Steps To Reproduce

1. Create sales invoice for any bp and any amount
2. Create payment associated to that invoice, paying total invoice
3. Void previous sales invoice. Reversed Sales Invoice will be automatically created. Both Invoices will have "Voided" status
4. Run Aging report and realize that Reversed Sales Invoice appear

Tags

No tags attached.

Attached Files

voidedInvoices.diff [^] (643 bytes) 2012-08-10 09:05 [Show Content] [Hide Content]

diff --git a/src/org/openbravo/agingbalance/ad_reports/AgingDao.java b/src/org/openbravo/agingbalance/ad_reports/AgingDao.java
--- a/src/org/openbravo/agingbalance/ad_reports/AgingDao.java
+++ b/src/org/openbravo/agingbalance/ad_reports/AgingDao.java
@@ -480,6 +480,7 @@
     hsqlScript.append("   left outer join i.businessPartner as bp");
     // orig_paym_schedule belongs to an invoice
     hsqlScript.append(" where opsv.invoice is not null");
+    hsqlScript.append("   and i.documentStatus <> 'VO'");
     hsqlScript.append("   and opsv.organization in :organizations");
     // Business Partner filter
     if (bPartners.size() > 0) {

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0028302

closed

fsoto82

Include preference to configure if VOID invoices should be included in report or not

Notes
(0051231) dmiguelez (developer) 2012-08-10 09:06	This issue is solved in later versions of the module. This patch applies to version 3.1.10

(0051232) maite (developer) 2012-08-10 09:08	verified

Issue History
Date Modified	Username	Field	Change
2012-08-09 13:02	maite	New Issue
2012-08-09 13:02	maite	Assigned To	=> dmiguelez
2012-08-09 13:03	maite	Issue Monitored: networkb
2012-08-10 09:05	dmiguelez	Status	new => scheduled
2012-08-10 09:05	dmiguelez	fix_in_branch	=> pi
2012-08-10 09:05	dmiguelez	File Added: voidedInvoices.diff
2012-08-10 09:06	dmiguelez	Note Added: 0051231
2012-08-10 09:07	dmiguelez	Status	scheduled => resolved
2012-08-10 09:07	dmiguelez	Resolution	open => fixed
2012-08-10 09:08	maite	Note Added: 0051232
2012-08-10 09:08	maite	Status	resolved => closed
2014-11-27 12:57	maite	Relationship added	related to 0028302