Bug Tracker Incident #15669

 


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


Product Version
3.8.0Alpha
Fixed In Version
3.8.0Beta


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


Description

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

#####Screenshot attached#####

Steps to Reproduce:
1. Sales->Analysis->Time-Phased Bookings
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:10:23 2011 ERROR: syntax error at or near ")"
LINE 34: )
^
QPSQL: Unable to create query
-- Group: timePhasedBookings
-- 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 cohead_orderdate,

cust_id, cust_number, cust_name

, warehous_code

, round((coitem_qtyord * coitem_qty_invuomratio) * (currtobase(cohead_curr_id, coitem_price, cohead_orderdate) / coitem_price_invuomratio), 2) AS amount
, ' USD-$' ::text AS uom

FROM coitem
JOIN cohead ON (coitem_cohead_id=cohead_id)
JOIN itemsite ON (coitem_itemsite_id=itemsite_id)
JOIN item ON (itemsite_item_id=item_id)

JOIN site() ON (itemsite_warehous_id=warehous_id)

JOIN custinfo ON (cohead_cust_id=cust_id)

WHERE ((coitem_status != 'X')
AND (cohead_orderdate 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:29
Resolution
Fixed



Comments

DateUsernameComment
09/28/11 08:28nagesh

Tested in 380 Beta: Issue fixed

09/14/11 11:31reddog

fixed in Incident #15670

09/14/11 08:41vinaysingu

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

#####Screenshot attached#####

Steps to Reproduce:
1. Sales->Analysis->Time-Phased Bookings
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:10:23 2011 ERROR: syntax error at or near ")"
LINE 34: )
^
QPSQL: Unable to create query
-- Group: timePhasedBookings
-- 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 cohead_orderdate,

cust_id, cust_number, cust_name

, warehous_code

, round((coitem_qtyord * coitem_qty_invuomratio) * (currtobase(cohead_curr_id, coitem_price, cohead_orderdate) / coitem_price_invuomratio), 2) AS amount
, ' USD-$' ::text AS uom

FROM coitem
JOIN cohead ON (coitem_cohead_id=cohead_id)
JOIN itemsite ON (coitem_itemsite_id=itemsite_id)
JOIN item ON (itemsite_item_id=item_id)

JOIN site() ON (itemsite_warehous_id=warehous_id)

JOIN custinfo ON (cohead_cust_id=cust_id)

WHERE ((coitem_status != 'X')
AND (cohead_orderdate BETWEEN
)
)) data
GROUP BY

cust_id, cust_number, cust_name,

uom, warehous_code
ORDER BY

cust_number,

uom, warehous_code;



Characteristics

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

Files

Filename
Timephasedbookings.png


Related Documents

TypeNumberDescriptionRelationshipRemove
Incident1368Planned Orders & Scheduling...Related tox
ProjectXTUPLEAPPSPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
09/14/11 08:41vinaysinguNewIncident Added
09/14/11 08:41vinaysinguCharacteristic Backport Added: "No"
09/14/11 08:41vinaysinguCharacteristic CodeReview Added: ""
09/14/11 08:41vinaysinguCharacteristic Operating System Added: "all"
09/14/11 08:41vinaysinguCharacteristic haxTuple Added: "No"
09/14/11 08:41vinaysinguCharacteristic Estimated Hours Added: ""
09/14/11 08:41vinaysinguCharacteristic Doc Flag Added: "False"
09/14/11 08:41vinaysinguCharacteristic Copyright Assigned Added: "Yes"
09/14/11 08:41acdrupalFound In: -> 3.8.0Alpha
09/14/11 11:31reddogCharacteristic CodeReview Changed: "" -> "Needed"
09/14/11 11:31reddogDescription Updated: "Querying without sel..." -> "Querying without sel..."
09/14/11 11:31reddogStatusStatus Changed: New -> Resolved
09/14/11 11:31reddogAssignedAssigned to: "" -> "reddog"
09/14/11 11:31reddogResolutionResolution Changed: -> Fixed
09/14/11 11:32reddogFixed In: -> 3.8.0
09/28/11 08:28nageshDescription Updated: "Querying without sel..." -> "Querying without sel..."
09/28/11 08:28nageshStatusStatus Changed: Resolved -> Closed
06/20/14 10:24bc_adminCharacteristic Points Deleted: ""