Product Info history records/reserved qty doesn't show reservations

Description

because i cant find any related improvement, i classify it as BUG.

proces
1. create new product type item/partner
2. create sales order with type standard
3. add new partner and new product (in my case 111 qty)
4. double check, open orders = PASS, Warehouse Tab, Product Info history records/reserved qty doesn't show reservations << BUG

in normal case, reserved products must be appear in this tab.

Environment

Sales Order/Demo Server

Activity

Show:
Elaine Tan
April 7, 2014, 9:23 AM
Edited

A currency column is added to Price History tab in Info Product problem - not showing currency. The currency column is missing from Reserved Quantity and Ordered Quantity tabs. The Price History, Reserved Quantity and Ordered Quantity tabs are using the same method (i.e. InvoiceHistory.fillTable) to fill the data.

08:06:43.482===========> InvoiceHistory.fillTable: SELECT p.Name, ol.PriceActual,ol.PriceList,ol.QtyReserved,o.DateOrdered,dt.PrintName || ' ' || o.DocumentNo As DocumentNo, w.Name,ol.Discount, 0 FROM C_Order o INNER JOIN C_OrderLine ol ON (o.C_Order_ID=ol.C_Order_ID) INNER JOIN C_DocType dt ON (o.C_DocType_ID=dt.C_DocType_ID) INNER JOIN M_Warehouse w ON (ol.M_Warehouse_ID=w.M_Warehouse_ID) INNER JOIN M_Product p ON (ol.M_Product_ID=p.M_Product_ID) WHERE ol.QtyReserved<>0 AND o.C_BPartner_ID=? AND o.IsSOTrx='Y' ORDER BY o.DateOrdered [120]
org.postgresql.util.PSQLException: Bad value for type double : 2013-05-22 00:00:00; State=22003; ErrorCode=0
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toDouble(AbstractJdbc2ResultSet.java:3038)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getDouble(AbstractJdbc2ResultSet.java:2382)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getDouble(NewProxyResultSet.java:2556)
at org.adempiere.webui.panel.InvoiceHistory.fillTable(InvoiceHistory.java:323)
at org.adempiere.webui.panel.InvoiceHistory.initReservedOrderedTab(InvoiceHistory.java:444)
at org.adempiere.webui.panel.InvoiceHistory.onEvent(InvoiceHistory.java:378)
at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742)
at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713)
at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654)
at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:325)
at org.zkoss.zul.Tabbox$Listener.onEvent(Tabbox.java:428)
at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2742)
at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2713)
at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2654)
at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1717)
at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1502)
at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1212)
at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600)
at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482)

Assignee

Elaine Tan

Reporter

Norbert Bede

Labels

None

Tested By

Carlos Ruiz

Components

Affects versions

Priority

Critical
Configure