[AMEBIS]

Estimados, estoy dando de alta un producto mediante entrada y salida simple, selecciono y creo un nuevo atributo que es el numero de lote, lo diferencia bien en el stock, lo agrupa, hace todo perfecto. El problema surge cuando voy a crear un remito de salida, no me permite seleccionar ese atributo para el articulo, solo el articulo sin atributo, alguien hizo andar este modulo en Libertya 22? Me parece que funcionaba bien en versiones muy viejas de LBY, me interesa actualizar el modulo para que funcione a la perfeccion en Libertya 22, cualquier partner me avisa y arreglamos.

Mientras tanto, este es el error

——————————-
12:20:33.617 PAttributeInstance.enableButtons: M_AttributeSetInstance_ID=-1 – null [25]
12:20:33.617 DB_PostgreSQL.convertStatement: En DBposgresSQL.java/convertStatement -sql:= SELECT DISTINCT asi.M_AttributeSetInstance_ID, asi.Description, asi.Lot, asi.SerNo, asi.GuaranteeDate, l.Value,s.M_Locator_ID, s.QtyOnHand, s.QtyReserved, s.QtyOrdered, bomPriceStd(p.M_Product_ID, ?, asi.M_AttributeSetInstance_ID), cast((TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))-cast(cast(p.GuaranteeDaysMin as text)|| ‘days’ as interval)as text), cast(TRUNC(asi.GuaranteeDate)-TRUNC(SysDate)as text), CASE WHEN p.GuaranteeDays > 0 THEN cast(TRUNC(((TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))/p.GuaranteeDays)*100)as text) ELSE cast(0 as text) END FROM M_AttributeSetInstance asi INNER JOIN M_Product p ON (p.M_Product_ID = ?) LEFT OUTER JOIN M_Storage s ON (s.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID AND s.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Locator l ON (s.M_Locator_ID=l.M_Locator_ID AND l.M_Warehouse_ID=?) WHERE ( asi.M_AttributeSet_id = p.M_AttributeSet_id ) AND asi.AD_Client_ID IN(0,1010016) AND asi.AD_Org_ID IN(0,1010053) AND (s.QtyOnHand<>0 OR s.QtyReserved<>0 OR s.QtyOrdered<>0) ORDER BY asi.GuaranteeDate, s.QtyOnHand [25]
12:20:33.617 CPreparedStatement.executeQuery: estamos p_stmt= SELECT DISTINCT asi.M_AttributeSetInstance_ID, asi.Description, asi.Lot, asi.SerNo, asi.GuaranteeDate, l.Value,s.M_Locator_ID, s.QtyOnHand, s.QtyReserved, s.QtyOrdered, bomPriceStd(p.M_Product_ID, 1010527, asi.M_AttributeSetInstance_ID), cast((DATE_Trunc(‘day’,asi.GuaranteeDate)-DATE_Trunc(‘day’,CURRENT_TIMESTAMP))-cast(cast(p.GuaranteeDaysMin as text)|| ‘days’ as interval)as text), cast(DATE_Trunc(‘day’,asi.GuaranteeDate)-DATE_Trunc(‘day’,CURRENT_TIMESTAMP)as text), CASE WHEN p.GuaranteeDays > 0 THEN cast(DATE_Trunc(‘day’,((DATE_Trunc(‘day’,asi.GuaranteeDate)-DATE_Trunc(‘day’,CURRENT_TIMESTAMP))/p.GuaranteeDays)*100)as text) ELSE cast(0 as text) END FROM M_AttributeSetInstance asi INNER JOIN M_Product p ON (p.M_Product_ID = 1015721) LEFT OUTER JOIN M_Storage s ON (s.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID AND s.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Locator l ON (s.M_Locator_ID=l.M_Locator_ID AND l.M_Warehouse_ID=1010048) WHERE ( asi.M_AttributeSet_id = p.M_AttributeSet_id ) AND asi.AD_Client_ID IN(0,1010016) AND asi.AD_Org_ID IN(0,1010053) AND (s.QtyOnHand<>0 OR s.QtyReserved<>0 OR s.QtyOrdered<>0) ORDER BY asi.GuaranteeDate, s.QtyOnHand [25]
===========> PAttributeInstance.refresh: refresh – SELECT DISTINCT asi.M_AttributeSetInstance_ID, asi.Description, asi.Lot, asi.SerNo, asi.GuaranteeDate, l.Value,s.M_Locator_ID, s.QtyOnHand, s.QtyReserved, s.QtyOrdered, bomPriceStd(p.M_Product_ID, ?, asi.M_AttributeSetInstance_ID), cast((TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))-cast(cast(p.GuaranteeDaysMin as text)|| ‘days’ as interval)as text), cast(TRUNC(asi.GuaranteeDate)-TRUNC(SysDate)as text), CASE WHEN p.GuaranteeDays > 0 THEN cast(TRUNC(((TRUNC(asi.GuaranteeDate)-TRUNC(SysDate))/p.GuaranteeDays)*100)as text) ELSE cast(0 as text) END FROM M_AttributeSetInstance asi INNER JOIN M_Product p ON (p.M_Product_ID = ?) LEFT OUTER JOIN M_Storage s ON (s.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID AND s.M_Product_ID=p.M_Product_ID) LEFT OUTER JOIN M_Locator l ON (s.M_Locator_ID=l.M_Locator_ID AND l.M_Warehouse_ID=?) WHERE ( asi.M_AttributeSet_id = p.M_AttributeSet_id ) AND asi.AD_Client_ID IN(0,1010016) AND asi.AD_Org_ID IN(0,1010053) AND (s.QtyOnHand<>0 OR s.QtyReserved<>0 OR s.QtyOrdered<>0) ORDER BY asi.GuaranteeDate, s.QtyOnHand [25]
org.postgresql.util.PSQLException: ERROR: la referencia a la columna «m_pricelist_version_id» es ambigua
Detail: Podría referirse tanto a una variable PL/pgSQL como a una columna de una tabla.
Where: función PL/pgSQL bompricestd(integer,integer,integer) en la línea 9 en sentencia SQL; State=42702; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:162)
at org.openXpertya.apps.search.PAttributeInstance.refresh(PAttributeInstance.java:390)
at org.openXpertya.apps.search.PAttributeInstance.actionPerformed(PAttributeInstance.java:428)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.JToggleButton$ToggleButtonModel.setPressed(JToggleButton.java:308)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)

Saludos

[Autor]

Entradas