Can someone point me to where the DMR number counter is located? I don’t see it in Company Configuration or in the Erp.CompanySequence table, and I can’t find it elsewhere. I’ve imported DMRs from Vantage 8 and now I can’t enter new DMRs.
Bryan,
I am pretty certain that the DMR number is not configurable. I have looked for this option in Vantage 8.03, Epicor 9 and Epicor 10 and I have never found it. I’m pretty sure I’ve had a few calls with support about it as well and there is not any way to configure it.
According to the Data Dictionary it is auto incremented.
When you say you cannot create more DMR’s what exactly is the error message?
There is also Ice.SysSequence but I don’t see DMR in there. I don’t actually use DMRs, so hard to search for the last number that way in case the naming is way off.
Yeah, I am not seeing this as a starting option, but the system I am looking at currently has multiple companies and they all start at 1000 then increment up from there.
What does your DMR Tracker show you?
Have you loaded all the related RMA and Non-conformance data also?
Are you getting an error when you try to fail a non-conformance or RMA into a DMR?
Brad Boes
bradboes@boosterpconsulting.com
231-845-1090
Not getting any errors, not related to the DMR# at least. I just discovered that it grabs the number based on the MAX(DMRNum) in the table, so I’m good in that regard. I wanted to insure there would be no conflict with the imported DMRs, and it appears to be handled. Thanks guys.
Also, I was mistaken on creating DMRs. Forgot that I have to create Non-Conformance and then reject the transaction in Inspection Processing to generate the DMR.
The error I’m getting now is on attempting to reject the imported DMR. So I’m missing something on my import. It’s not happening on DMR’s created through the standard process. I’m guessing I need the non-conformance record and that is what is missing.
Error Detail
Message: Object reference not set to an instance of an object.
Program: Epicor.ServiceModel.dll
Method: ShouldRethrowNonRetryableException
Client Stack Trace
at Erp.Services.BO.DMRProcessingSvc.GetNewDMRActnReject(DMRProcessingTableset& ds, Int32 ipDMRNum) in C:_Releases\ERP\UD10.1.500.17\Source\Server\Services\BO\DMRProcessing\DMRProcessing.cs:line 5298
at Erp.Services.BO.DMRProcessingSvcFacade.GetNewDMRActnReject(DMRProcessingTableset& ds, Int32 ipDMRNum) in C:_Releases\ERP\UD10.1.500.17\Source\Server\Services\BO\DMRProcessing\DMRProcessingSvcFacade.cs:line 520
at SyncInvokeGetNewDMRActnReject(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at Epicor.Hosting.OperationBoundInvoker.InnerInvoke(Object instance, Func2 func) in C:\_Releases\ICE\3.1.500.17\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59 at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:_Releases\ICE\3.1.500.17\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 47
at Epicor.Hosting.Wcf.EpiOperationInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) in C:_Releases\ICE\3.1.500.17\Source\Framework\Epicor.System\Hosting\Wcf\EpiOperationInvoker.cs:line 23
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Erp.Proxy.BO.DMRProcessingImpl.GetNewDMRActnReject(DMRProcessingDataSet ds, Int32 ipDMRNum)
at Erp.Adapters.DMRProcessingAdapter.GetNewDMRActnReject(Int32 ipDMRNum)
at Erp.UI.App.DMRProcessingEntry.Transaction.GetNewDMRActnReject()
Yep, the missing NonConf records were the problem. Got everything working now.
Glad to hear it.
Last year I had to split an Epicor company into a new company and I found what you did, have to first DMT in the Nonconformances and then DMT the fail to DMR.