Manufacturing and Distribution

[Michael Gendrala]

Good Day Everyone,

I tried looking into Libero Manufacturing and Distribution because
when I tried it out using the latest adempiere361 from bitbucket, I
encountered errors.

I looked red1's forums and found this thread:
http://red1.org/adempiere/viewtopic.php?f=26&t=1577&p=7650&hilit=libero#p7650

It says on the thread that Adaxa Lite Manufacturing will be
implemented into iDempiere. What I want to ask is that if this will
also be implemented into ADempiere 361? Or will ADempiere361 continue
using Libero? When I tested the Distribution Module, in an attempt to
use the Generate Movement process I encountered this error:

MovementGenerate.generate: SELECT * FROM DD_Order o WHERE
DocStatus='CO' AND o.C_DocType_ID IN (SELECT C_DocType_ID FROM
C_DocType WHERE DocBaseType='DOO') AND o.IsDropShip='N' AND
o.DeliveryRule<>'M' AND EXISTS (SELECT * FROM DD_OrderLine ol WHERE
ol.M_Warehouse_ID=? AND o.DD_Order_ID=ol.DD_Order_ID AND
ol.QtyOrdered<>ol.QtyIntransit) ORDER BY M_Warehouse_ID, PriorityRule,
M_Shipper_ID, C_BPartner_ID, C_BPartner_Location_ID, DD_Order_ID [11]
org.postgresql.util.PSQLException: ERROR: column ol.m_warehouse_id
does not exist
Position: 223; State=42703; ErrorCode=0
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
2102)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:
1835)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
500)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:
273)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:
76)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy0.executeQuery(Unknown Source)
at
org.eevolution.process.MovementGenerate.generate(MovementGenerate.java:
229)
at org.eevolution.process.MovementGenerate.doIt(MovementGenerate.java:
216)
at org.compiere.process.SvrProcess.process(SvrProcess.java:147)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:105)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:
160)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:
105)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:649)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:394)
at java.lang.Thread.run(Thread.java:662)

I believe that I am missing some migration scripts? Also, when I tried
opening the MovementGenerate file from the console, it couldn't be
found.

Regards,
Michael G.

[Redhuan D. Oon]

Ola Mike,
About the roadmap you may get some idea from http://red1.org/adempiere/viewtopic.php?f=33&t=1482