ESC Inventory Adjustment Error

e10

(Jacob Kolar) #1

Another developer and I are creating a workflow to process a list of Inventory Adjustments and are running into this error. Has anyone come across it before and know what is causing it specifically?

<?xml version="1.0" encoding="utf-16" standalone="yes"?>

<msg:req tag=“InventoryQtyAdj.Erp.Proxy.BO.InventoryQtyAdjImpl.SetInventoryQtyAdj”>
msg:ers
<msg:error type=“unexpected error”>
msg:number2147220990</msg:number>
msg:descriptionUnspecified error: Unknown fatal errors occurred: Failed execute proxy assembly: Failed execute proxy assembly:
Exception of type System.Data.ConstraintException: This property cannot be set to a null value.
</msg:description>
msg:sourceFailed execute proxy assembly: Failed execute proxy assembly:
Exception of type System.Data.ConstraintException: This property cannot be set to a null value.

Server stack trace:
at Epicor.NETProxy.RemoteNETProxy.ExecuteAssemblyCode(String settingsXml, String requestXml, Queue`1& errs)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Epicor.NETProxy.RemoteNETProxy.ExecuteAssemblyCode(String settingsXml, String requestXml, Queue`1& errs)
at Epicor.NETProxy.NETProxy.ExecuteAssemblyCode(AssemblyCallSettings settings, String requestXml, IBusinessContext ctx)
at ScaWGenericNETCall.GenericNETCall.ParseDta(IBusinessContext ctx, ManagerRequest request, XmlTextReader reader, XmlTextWriter writer)
at iScala.Framework.InternalBaseManager.ProcessXML(String Data)</msg:source>
</msg:error>
</msg:ers><msg:dta xmlns:msg=“http://Epicor.com/InternalMessage/1.1”><ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request:Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request xmlns:ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request=“http://Epicor.com/InventoryQtyAdj/Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request”><ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request:CompanyID>TMC</ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request:CompanyID><ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request:ds><ext_InventoryQtyAdj:InventoryQtyAdjDataSet xmlns:ext_InventoryQtyAdj=“http://www.epicor.com/Ice/300/BO/InventoryQtyAdj/InventoryQtyAdj”><ext_InventoryQtyAdj:InventoryQtyAdj><ext_InventoryQtyAdj:Company>TMC</ext_InventoryQtyAdj:Company><ext_InventoryQtyAdj:PartNum>55632-4</ext_InventoryQtyAdj:PartNum><ext_InventoryQtyAdj:WareHseCode>VLI</ext_InventoryQtyAdj:WareHseCode><ext_InventoryQtyAdj:OnHandQty>0</ext_InventoryQtyAdj:OnHandQty><ext_InventoryQtyAdj:BinNum>TMKT</ext_InventoryQtyAdj:BinNum><ext_InventoryQtyAdj:AdjustQuantity>-2</ext_InventoryQtyAdj:AdjustQuantity><ext_InventoryQtyAdj:ReasonCode>10</ext_InventoryQtyAdj:ReasonCode><ext_InventoryQtyAdj:Reference>Hose</ext_InventoryQtyAdj:Reference><ext_InventoryQtyAdj:UnitOfMeasure>FT</ext_InventoryQtyAdj:UnitOfMeasure><ext_InventoryQtyAdj:TransDate>2018-06-08T13:03:16.631-05:00</ext_InventoryQtyAdj:TransDate><ext_InventoryQtyAdj:ReasonType>A</ext_InventoryQtyAdj:ReasonType><ext_InventoryQtyAdj:SerialNoQty>0</ext_InventoryQtyAdj:SerialNoQty><ext_InventoryQtyAdj:TempSerialNo>0</ext_InventoryQtyAdj:TempSerialNo><ext_InventoryQtyAdj:ReasonCodeReq>false</ext_InventoryQtyAdj:ReasonCodeReq><ext_InventoryQtyAdj:AllowNegQty>false</ext_InventoryQtyAdj:AllowNegQty><ext_InventoryQtyAdj:StkUOMCode>FT</ext_InventoryQtyAdj:StkUOMCode><ext_InventoryQtyAdj:EnableSN>false</ext_InventoryQtyAdj:EnableSN><ext_InventoryQtyAdj:OnHandUOM>FT</ext_InventoryQtyAdj:OnHandUOM><ext_InventoryQtyAdj:SysRowID>00000000-0000-0000-0000-000000000000</ext_InventoryQtyAdj:SysRowID><ext_InventoryQtyAdj:ReasonCodeDescription>1</ext_InventoryQtyAdj:ReasonCodeDescription><ext_InventoryQtyAdj:EpicorFSA>false</ext_InventoryQtyAdj:EpicorFSA><ext_InventoryQtyAdj:PartTrackLots>false</ext_InventoryQtyAdj:PartTrackLots><ext_InventoryQtyAdj:PartTrackDimension>false</ext_InventoryQtyAdj:PartTrackDimension><ext_InventoryQtyAdj:PartSellingFactor>0</ext_InventoryQtyAdj:PartSellingFactor><ext_InventoryQtyAdj:PartTrackSerialNum>false</ext_InventoryQtyAdj:PartTrackSerialNum><ext_InventoryQtyAdj:PartIUM>FT</ext_InventoryQtyAdj:PartIUM><ext_InventoryQtyAdj:RowMod>U</ext_InventoryQtyAdj:RowMod></ext_InventoryQtyAdj:InventoryQtyAdj></ext_InventoryQtyAdj:InventoryQtyAdjDataSet></ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request:ds></ext_Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request:Erp_Proxy_BO_InventoryQtyAdjImpl_SetInventoryQtyAdj_Request></msg:dta>msg:wfl<msg:usr xmlns:msg=“http://Epicor.com/InternalMessage/1.1”><msg:OriginalData xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”>

TMC55632-4VLITMKT-210HoseFTA1
</msg:OriginalData></msg:usr><msg:ElemID xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>{65A315A5-D496-4FBA-B2DC-B541FDD598F9}</msg:ElemID><msg:PrcID xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>{653F7BF0-0223-433A-A660-9DF4CB265893}</msg:PrcID><msg:MsgType xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>MassQtyAdjustment</msg:MsgType><msg:Action xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>MassAdj</msg:Action><msg:WflID xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>MassQtyAdjustment\MassQtyTrace</msg:WflID><msg:MsgID xmlns:msg=“http://Epicor.com/InternalMessage/1.1”></msg:MsgID><msg:BreakCode xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>0</msg:BreakCode>msg:IsFinishedtrue</msg:IsFinished></msg:wfl>msg:ctx/</msg:req>
msg:trcmsg:PrcID{53D7D1EC-2051-4C63-BCBA-C71BAFB3950B}</msg:PrcID>msg:TrcSessionID{71AEE904-0C7A-4E9B-9C40-4E18D3DC8071}</msg:TrcSessionID>msg:TrcID{8159302F-D8EF-47F3-8A60-F5FFEE0CDB37}</msg:TrcID>msg:CallModesync-req/res</msg:CallMode></msg:trc></msg:msg>

(Jaicker Avila) #2

Hi,

First you must to call the GetInventoryQtyAdj method

image