Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006783Openbravo ERP07. Sales managementpublic2009-01-07 12:392009-01-14 15:05
Reporternetworkb 
Assigned Torafaroda 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006783: Although a business partner is deactivated, is showed in some Sales reports
DescriptionIf a business partner is deactivated, still appears in some Sales reports and it must not.

This happens in : Invoiced Sales Order Report, Orders Awaiting Invoice Report, Delivered Sales Order Report, Invoice Detail, Shipment Report.
Steps To Reproduce1.Go to Sales Management>Analysis Tools>Invoiced Sales Order Report.
2.Select "From Date" and "To Date". Press "html format" button.
3.In the report will appear diferent business partners. Select one of them.
4.Go to Master Data>Business Partner and find the previous one.
5.Deactivate it.
6.Go back to the report, and fill the same dates.
7.The report will show the same information for the deactivated business partner.
And it must not.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006786 closed rafaroda Although a business partner is deactivated, is showed in some Sales reports 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-07 12:39networkbNew Issue
2009-01-07 12:39networkbAssigned To => rafaroda
2009-01-07 12:39networkbsf_bug_id0 => 2491967
2009-01-07 12:39networkbOBNetwork customer => Yes
2009-01-07 12:39networkbRegression testing => No
2009-01-07 13:35rafarodaStatusnew => scheduled
2009-01-07 13:35rafarodafix_in_branch => trunk
2009-01-08 08:17svnbotCheckin
2009-01-08 08:17svnbotNote Added: 0011970
2009-01-08 08:17svnbotStatusscheduled => resolved
2009-01-08 08:17svnbotResolutionopen => fixed
2009-01-08 08:17svnbotsvn_revision => 11699
2009-01-08 08:27rafarodaRelationship addedrelated to 0006791
2009-01-14 15:03svnbotCheckin
2009-01-14 15:03svnbotNote Added: 0012171
2009-01-14 15:03svnbotsvn_revision11699 => 11875
2009-01-14 15:05rafarodaStatusresolved => new
2009-01-14 15:05rafarodaResolutionfixed => open
2009-01-14 15:05rafarodaStatusnew => closed
2009-01-14 15:05rafarodaNote Added: 0012172
2009-01-14 15:05rafarodaResolutionopen => no change required

Notes
(0011970)
svnbot   
2009-01-08 08:17   
Repository: openbravo
Revision: 11699
Author: rafaroda
Date: 2009-01-08 08:17:18 +0100 (Thu, 08 Jan 2009)

Fixes bug 0006783 Now Invoiced Sales Order Report, Orders Awaiting Invoice Report, Delivered Sales Order Report, Invoice Detail and Shipment Report only show data from active partners.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11699&sc=1 [^]
(0012171)
svnbot   
2009-01-14 15:03   
Repository: openbravo
Revision: 11875
Author: rafaroda
Date: 2009-01-14 15:03:19 +0100 (Wed, 14 Jan 2009)

Bug 0006783 Reverted commit 11699.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11875&sc=1 [^]
(0012172)
rafaroda   
2009-01-14 15:05   
This bug was finally closed as not a bug and commits were reverted.

Business partners de-activated should not be shown in transactional windows but their activity, even if they are de-activated, has to be displayed in all the reports. Otherwise, one could report a wrong historical of sales from the past year because he de-activated some business partners.