Issue Tracker Incident #15670

 


Summary
Incident Category
Bugs
Incident Number
15670
Visibility
public


Product Version
3.8.0Alpha
Fixed In Version
3.8.0Beta


Summary
*Selecting to query the ‘Time-Phased Sales History’ screen without selecting any period generates a DB log error


Description

Querying without selecting any period generates a DB log error in ‘Time-Phased Sales History’ screen

Steps to Reproduce:
1. Sales->Analysis->Time Phased Sales History
2. Select a calendar from the drop down list
3. Un Select all the periods and click on Query button
4. Observe that an error message is displayed and a DB log error is generated

DB log error:
Wed 14. Sep 18:16:12 2011 ERROR: syntax error at or near ")"
LINE 32: )
^
QPSQL: Unable to create query
-- Group: timePhasedSales
-- Name: detail
-- Notes:

SELECT

cust_id, cust_number, cust_name,

uom, warehous_code
-- Loop through each period bucket to find bookings for period

FROM (
SELECT cohist_invcdate,

cust_id, cust_number, cust_name

, warehous_code

, round((cohist_qtyshipped * currtobase(cohist_curr_id, cohist_unitprice, cohist_invcdate)), 2) AS amount
, ' USD-$' ::text AS uom

FROM cohist JOIN itemsite ON (itemsite_id=cohist_itemsite_id)
JOIN item ON (item_id=itemsite_item_id)

JOIN site() ON (itemsite_warehous_id=warehous_id)

JOIN custinfo ON (cohist_cust_id=cust_id)

WHERE ((cohist_invcdate BETWEEN
)
)) data
GROUP BY

cust_id, cust_number, cust_name,

uom, warehous_code
ORDER BY

cust_number,

uom, warehous_code;


Details
Reporter
vinaysingu
CRM Account
ZenQ
Status
Closed
Assigned
reddog


Priority
Normal
Severity
Minor
Updated
09-28-11 08:27
Resolution
Fixed



Comments

DateUsernameComment
09/28/11 08:27nagesh

Tested in 380 Beta:Issue fixed

09/14/11 11:26reddog

change parent window displayTimePhased and add edit that requires at least one period is selected

09/14/11 11:25svn

Revision: 12448
http://postbooks.svn.sourceforge.net/postbooks/?rev=12448&view=rev
Author: sunsetsolutions
Date: 2011-09-14 15:25:11 +0000 (Wed, 14 Sep 2011)
Log Message:
-----------
Issue #15670:add edit requiring at least one period selected

Modified Paths:
--------------
xtuple/trunk/guiclient/displayTimePhased.cpp

09/14/11 08:47vinaysingu

Querying without selecting any period generates a DB log error in ‘Time-Phased Sales History’ screen

Steps to Reproduce:
1. Sales->Analysis->Time Phased Sales History
2. Select a calendar from the drop down list
3. Un Select all the periods and click on Query button
4. Observe that an error message is displayed and a DB log error is generated

DB log error:
Wed 14. Sep 18:16:12 2011 ERROR: syntax error at or near ")"
LINE 32: )
^
QPSQL: Unable to create query
-- Group: timePhasedSales
-- Name: detail
-- Notes:

SELECT

cust_id, cust_number, cust_name,

uom, warehous_code
-- Loop through each period bucket to find bookings for period

FROM (
SELECT cohist_invcdate,

cust_id, cust_number, cust_name

, warehous_code

, round((cohist_qtyshipped * currtobase(cohist_curr_id, cohist_unitprice, cohist_invcdate)), 2) AS amount
, ' USD-$' ::text AS uom

FROM cohist JOIN itemsite ON (itemsite_id=cohist_itemsite_id)
JOIN item ON (item_id=itemsite_item_id)

JOIN site() ON (itemsite_warehous_id=warehous_id)

JOIN custinfo ON (cohist_cust_id=cust_id)

WHERE ((cohist_invcdate BETWEEN
)
)) data
GROUP BY

cust_id, cust_number, cust_name,

uom, warehous_code
ORDER BY

cust_number,

uom, warehous_code;



Files

No Files

Related Documents

TypeNumberDescriptionRelationshipRemove
ProjectXTUPLEAPPSPorted From Mantis


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
01/30/17 14:25adminFound In: -> 3.8.0Alpha
01/30/17 14:25adminFixed In: -> 3.8.0Beta