Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001949Openbravo ERP07. Sales managementpublic2007-09-13 07:392008-06-12 09:43
Reporteruser71 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0001949: Various reports don't filter product category by client
DescriptionFirst notice this in Invoice Customer Report, also occurs in Sales Order Invoice Report, Sales Order Provided and several others.

The product categories in the report filter show all product categories from all clients in the system. It should only show the product categories for the appropriate client/org.

Attached patch modifies SubCategoryProduct_data.xsqlc to add a client/org filter to the select queries. It also modifies all the report servlets that call those methods to pass in the client/org.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005538)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1793684 [^]
(0002097)
psarobe   
2007-09-18 09:04   
(edited on: 2008-06-12 09:21)
Logged In: YES
user_id=1500703
Originator: NO

Again, please is very important for us to describe the environment on you are working
(0002098)
user71   
2007-09-18 09:12   
(edited on: 2008-06-12 09:21)
Logged In: YES
user_id=1737231
Originator: YES

Environment

OS: Linux - Centos 4 (test/prod) & Windows XP (dev)
DB: Postgres 8.1.9 (test/prod) & 8.2.4 (dev)
Release: 2.33
Browser: Firefox 2.0.0.6, IE 7
(0002099)
rafaroda   
2007-10-23 14:44   
(edited on: 2008-06-12 09:21)
Logged In: YES
user_id=1892190
Originator: NO

Verification assigned to rafaroda.
(0002100)
rafaroda   
2007-10-23 15:18   
(edited on: 2008-06-12 09:21)
Logged In: YES
user_id=1892190
Originator: NO

A part of this bug can be found in http://sourceforge.net/tracker/index.php?func=detail&aid=1818544&group_id=162271&atid=823129. [^]