Help Sales order not closing

Sales order is not closing - Line 3 / R 1 is a duplication to line 2 / Rel 2
ERROR : Delete not allowed, Referenced by at lest one material queue

You have the AMM module. Open up the Material Request Queue and look for Sales Order 207871 and delete that line from the Material Request Queue and see if you can remove it.

1 Like

We do not have the AMM module. Any other suggestion would be appreciated. below is the error detail.

Exception caught in: Epicor.Mfg.BO.SalesOrder

Error Detail

Message: Referenced by at least one Material Queue. Cannot close this order.
Type: Error
Program: Server/bo/SalesOrder/SalesOrder.p
Method: CloseOrder
Table: OrderHed
Row:
Field:

Stack Trace

at Epicor.Mfg.Proxy.SalesOrderImpl.CloseOrder(Int32 iOrderNum)
at Epicor.Mfg.UI.Adapters.SalesOrderAdapter.CloseOrder(Int32 iOrderNum)

Inner Exception

ERROR condition: The Server application has returned an error. (7243) (7211)

Inner Stack Trace

at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Core.CallContext.CallContextPersistentProc.runProcedure(String procedureName, ParameterSet parameters, MetaSchema metaSchema)
at Epicor.Mfg.Core.CallContext.ProxyHelper.CallMethod(String methodName, ParameterSet parameters, MetaSchema metaSchema, BLConnectionPool connPool, Session connection, PersistentProc persistProc, CallContextDataSet callContextDataSet)
at Epicor.Mfg.Proxy.SalesOrderImpl.CloseOrder(Int32 iOrderNum)

Can you create a BAQ against the MtlQueue table and see what is in it?

We had this happen with an RMA. Ended up going to the line, adding RMA # to the box. ReOpen Release. Close Release.

Magic after that.

2 Likes