Bug Tracker Incident #15671

 


Summary
Project
INCDT - xTuple ERP
Incident Category
Bugs
Incident Number
15671
Visibility
public


Product Version
3.8.0Alpha
Fixed In Version
3.7.4


Summary
*‘Sales Representative’ filter in Summarized Sales history is not functional


Description

Incorrect results are being displayed on selecting the ‘Sales Rep.’ filter in consolidated summarized sales history screen

######Screenshot attached####3

Steps to Reproduce:
1. Sales->Analysis->Summarized Sales History
2. Check the option ‘Group by Sales Rep.’ and click on Query
3. Click on 'More' button and enter Invoice Start Date as ‘-100’
4. Select the ‘Sales Rep.’ filter from the drop down list and select a Sales Representative
5. Click on Query and observe that the sales history of all the Sales Representatives is being displayed


Details
Reporter
vinaysingu
CRM Account
ZenQ
Status
Closed
Assigned
reddog


Priority
Normal
Severity
Minor
Updated
06-05-13 15:11
Resolution
Fixed



Comments

DateUsernameComment
09/26/11 00:58vinaysingu

Closing the issue based on feedback.

09/23/11 13:47reddog

please close this bug and submit a new bug for the print report (this bug is for the screen display) which will be fixed in 3.8.

09/23/11 01:49vinaysingu

Tested in xTuple version 3.7.4.
Observed that Print report of the Summarized Sales History screen doesn't honour the 'Sales Rep.' filter selected.

09/21/11 14:11reddog

backport to 3.7.4

09/14/11 11:10reddog

change metasql summarizedSalesHistory and add salesrep_id parameter filter

09/14/11 11:07svn

Revision: 12447
http://postbooks.svn.sourceforge.net/postbooks/?rev=12447&view=rev
Author: sunsetsolutions
Date: 2011-09-14 15:07:06 +0000 (Wed, 14 Sep 2011)
Log Message:
-----------
Issue #15671:add salesrep_id parameter

Modified Paths:
--------------
xtupleserver/trunk/dbscripts/metasql/summarizedSalesHistory-detail.mql

09/14/11 08:57vinaysingu

Incorrect results are being displayed on selecting the ‘Sales Rep.’ filter in consolidated summarized sales history screen

######Screenshot attached####3

Steps to Reproduce:
1. Sales->Analysis->Summarized Sales History
2. Check the option ‘Group by Sales Rep.’ and click on Query
3. Click on 'More' button and enter Invoice Start Date as ‘-100’
4. Select the ‘Sales Rep.’ filter from the drop down list and select a Sales Representative
5. Click on Query and observe that the sales history of all the Sales Representatives is being displayed



Characteristics

Backport
No
CodeReview
Needed
Operating System
all
Doc Flag
False
Copyright Assigned
Yes
HaxTuple
No
Points
None

Files

Filename
salesrep..png


Related Documents

TypeNumberDescriptionRelationshipRemove
Incident13693.5 packlist reprintRelated tox
ProjectXTUPLEAPPSPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
09/14/11 08:57vinaysinguNewIncident Added
09/14/11 08:57vinaysinguCharacteristic Backport Added: "No"
09/14/11 08:57vinaysinguCharacteristic CodeReview Added: ""
09/14/11 08:57vinaysinguCharacteristic Operating System Added: "all"
09/14/11 08:57vinaysinguCharacteristic haxTuple Added: "No"
09/14/11 08:57vinaysinguCharacteristic Estimated Hours Added: ""
09/14/11 08:57vinaysinguCharacteristic Doc Flag Added: "False"
09/14/11 08:57vinaysinguCharacteristic Copyright Assigned Added: "Yes"
09/14/11 08:57acdrupalFound In: -> 3.8.0Alpha
09/14/11 11:10reddogCharacteristic CodeReview Changed: "" -> "Needed"
09/14/11 11:10reddogDescription Updated: "Incorrect results ar..." -> "Incorrect results ar..."
09/14/11 11:10reddogStatusStatus Changed: New -> Resolved
09/14/11 11:10reddogAssignedAssigned to: "" -> "reddog"
09/14/11 11:10reddogResolutionResolution Changed: -> Fixed
09/14/11 11:10reddogFixed In: -> 3.8.0
09/21/11 10:50reddogCharacteristic Backport Changed: "No" -> "Yes"
09/21/11 14:10reddogCharacteristic Backport Changed: "Yes" -> "No"
09/21/11 14:11reddogFixed In: 3.8.0Beta -> 3.7.4
09/23/11 01:49vinaysinguDescription Updated: "Incorrect results ar..." -> "Incorrect results ar..."
09/23/11 01:49vinaysinguStatusStatus Changed: Resolved -> Assigned
09/23/11 13:47reddogDescription Updated: "Incorrect results ar..." -> "Incorrect results ar..."
09/23/11 13:47reddogStatusStatus Changed: Assigned -> Feedback
09/26/11 00:58vinaysinguDescription Updated: "Incorrect results ar..." -> "Incorrect results ar..."
09/26/11 00:58vinaysinguStatusStatus Changed: Feedback -> Closed