I am getting the following error, when I try to test fifo costing.
###################################################################
caused by: org.postgresql.util.PSQLException: ERROR: column c.costingmethod does not exist
Position: 53; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.GeneratedMethodAccessor73.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 $Proxy56.executeQuery(Unknown Source)
at org.compiere.model.MCost.getCurrentCostLayers(MCost.java:154)
at org.compiere.model.MCost.getCurrentCostLayers(MCost.java:271)
at org.compiere.model.ProductCost.getProductCostsLayers(ProductCost.java:694)
at org.adempiere.engine.FifoLifoCostingMethod.calculate(FifoLifoCostingMethod.java:56)
at org.adempiere.engine.FifoLifoCostingMethod.getCalculatedCosts(FifoLifoCostingMethod.java:68)
at org.adempiere.engine.AbstractCostingMethod.createCostDetails(AbstractCostingMethod.java:84)
at org.adempiere.engine.FifoLifoCostingMethod.processCostDetail(FifoLifoCostingMethod.java:131)
at org.adempiere.engine.FifoLifoCostingMethod.process(FifoLifoCostingMethod.java:100)
at org.adempiere.engine.CostEngine.createCostDetail(CostEngine.java:417)
#################################################################
It seems costingmethod column is missed from the M_Cost table.
Coming to steps I follwed:
1. Created Product XYZ
2. Created Purchase order with each XYZ costs 10 rupees
3. Then I created Material Reciept and Invoice for same product and price
4. Then I tried to issue the material, through Indent request
Then I got the above error.
I don't know this is the problem, howeve i also get the same problem. we cannot complete when costing method is fifo