First, I’d like to say that I’ve built numerous Service Connect workflows and 95% of them were massive PITAs to troubleshoot through the process of building them. They really need to work on their error logging. That being said I’m working on a workflow that creates AP Invoices. Everything has gone smoothly(ish) up until now. I’ve managed to have my workflow create the group, the header, and any non PO invoice line, and PO invoice lines that have not been received. The problem comes when trying to invoice Receipts. I get an “Invalid Uninvoiced Receipt” error on the SelectUninvoicedRcptLines BO. I’ve ran through the manual trace and literally every field matches up with the SC return. Has anyone run into this and managed to find a solution?
Thanks for the reply Bernie. This is pretty similar to what I’m using. No errors until that select uninvoiced rcpt line bit. I ran across something mentioning that if the amount on the header doesn’t match the receipts total it would throw an error. I’m just glad to see that at least I know it’s possible now.
Thanks
Jason Duncan
Removing the amount made no difference. I still can’t get past that one part at selecting the invoices. Still get Invalid Uninvoiced Receipts.
Was there anything out of the ordinary that you had to during the conversion between GetAPUninvoicedReceipts and SelectUninvoicedRcptLines?
Forgive me but it has been many years since this was created,
In the conversion all fields are mapped across except SelectLine is set to true and RowMod is set to U in the APUninvoicedRcptLines table (for the current vendor invoice)
And RowMod set to U in the APUnivoicedReceipts table
1 Like
I’m sorry to bother you again but I’ve been trying just about everything I can think of for the past 2 days to get past this one part with 0 luck. In your conversion between your UpdateMaster and GetAPUninvoicedRcptLines did you provide anything to the request other than CompanyID, InVendonNum, InInvoiceNum, and InPONum? I’m trying to work backwards at this point to see if I’ve left something out along the way to the SelectUninvoicedRcptLines. Thank you very much for your help.
This is the full error I’m getting and as you can see it’s pulling in all the correct information (as far as I can tell): <msg:msg xsi:schemaLocation=“http://Epicor.com/InternalMessage/1.1 http://scshost/schemas/epicor/ScaInternalMsg.xsd” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:msg=“http://Epicor.com/InternalMessage/1.1”>
<msg:req tag=“APInvoice.Erp.Proxy.BO.APInvoiceImpl.SelectUninvoicedRcptLines”>
msg:ers
<msg:error type=“unexpected error”>
msg:number-2146232832</msg:number>
msg:descriptionInvalid Uninvoiced Receipt.</msg:description>
msg:sourceEpicor.ServiceModel</msg:source>
</msg:error>
<msg:error type=“unexpected error”>
msg:number2147220990</msg:number>
msg:descriptionUnspecified error: Unknown fatal errors occurred: Failed to execute proxy assembly: Invalid Uninvoiced Receipt.</msg:description>
msg:sourceFailed to execute proxy assembly: Invalid Uninvoiced Receipt.
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_APInvoiceImpl_SelectUninvoicedRcptLines_Request:Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request xmlns:ext_Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request=“http://Epicor.com/APInvoice/Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request”>
<ext_Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request:CompanyID>BWF</ext_Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request:CompanyID>
<ext_Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request:ds>
<ext_APInvReceiptBilling:APInvReceiptBillingDataSet xmlns:ext_APInvReceiptBilling=“http://www.epicor.com/Ice/300/BO/APInvoice/APInvReceiptBilling”>
<ext_APInvReceiptBilling:APUninvoicedReceipts>
<ext_APInvReceiptBilling:Company>BWF</ext_APInvReceiptBilling:Company>
<ext_APInvReceiptBilling:VendorNum>82</ext_APInvReceiptBilling:VendorNum>
<ext_APInvReceiptBilling:PONum>28203</ext_APInvReceiptBilling:PONum>
<ext_APInvReceiptBilling:PackSlip>28203_20220526</ext_APInvReceiptBilling:PackSlip>
<ext_APInvReceiptBilling:ReceiptDate>2022-05-26T00:00:00-04:00</ext_APInvReceiptBilling:ReceiptDate>
<ext_APInvReceiptBilling:PackSlipTotal>0</ext_APInvReceiptBilling:PackSlipTotal>
<ext_APInvReceiptBilling:DocPackSlipTotal>0</ext_APInvReceiptBilling:DocPackSlipTotal>
<ext_APInvReceiptBilling:CurrencySwitch>true</ext_APInvReceiptBilling:CurrencySwitch>
<ext_APInvReceiptBilling:BaseCurrSymbol>$</ext_APInvReceiptBilling:BaseCurrSymbol>
<ext_APInvReceiptBilling:CurrSymbol>$</ext_APInvReceiptBilling:CurrSymbol>
<ext_APInvReceiptBilling:PurPoint/>
<ext_APInvReceiptBilling:InvoiceNum>TestInvoice</ext_APInvReceiptBilling:InvoiceNum>
<ext_APInvReceiptBilling:CurrencyCode>USD</ext_APInvReceiptBilling:CurrencyCode>
<ext_APInvReceiptBilling:Rpt1PackSlipTotal>0</ext_APInvReceiptBilling:Rpt1PackSlipTotal>
<ext_APInvReceiptBilling:Rpt2PackSlipTotal>0</ext_APInvReceiptBilling:Rpt2PackSlipTotal>
<ext_APInvReceiptBilling:Rpt3PackSlipTotal>0</ext_APInvReceiptBilling:Rpt3PackSlipTotal>
<ext_APInvReceiptBilling:DropShip>false</ext_APInvReceiptBilling:DropShip>
<ext_APInvReceiptBilling:DropShipPackSlip/>
<ext_APInvReceiptBilling:DummyKey>4920851c-3104-4867-aae9-7e137099f664</ext_APInvReceiptBilling:DummyKey>
<ext_APInvReceiptBilling:BaseCurrencyID>USD</ext_APInvReceiptBilling:BaseCurrencyID>
<ext_APInvReceiptBilling:CurrencyID>USD</ext_APInvReceiptBilling:CurrencyID>
<ext_APInvReceiptBilling:AllSelected>false</ext_APInvReceiptBilling:AllSelected>
<ext_APInvReceiptBilling:LegalNumber/>
<ext_APInvReceiptBilling:SysRowID>4920851c-3104-4867-aae9-7e137099f664</ext_APInvReceiptBilling:SysRowID>
<ext_APInvReceiptBilling:RowMod>U</ext_APInvReceiptBilling:RowMod>
</ext_APInvReceiptBilling:APUninvoicedReceipts>
<ext_APInvReceiptBilling:APUninvoicedRcptLines>
<ext_APInvReceiptBilling:Company>BWF</ext_APInvReceiptBilling:Company>
<ext_APInvReceiptBilling:VendorNum>82</ext_APInvReceiptBilling:VendorNum>
<ext_APInvReceiptBilling:PurPoint/>
<ext_APInvReceiptBilling:PackSlip>28203_20220526</ext_APInvReceiptBilling:PackSlip>
<ext_APInvReceiptBilling:PackLine>1</ext_APInvReceiptBilling:PackLine>
<ext_APInvReceiptBilling:InvoiceNum>TestInvoice</ext_APInvReceiptBilling:InvoiceNum>
<ext_APInvReceiptBilling:PartNum>G751720.7Z(S-1)A1630</ext_APInvReceiptBilling:PartNum>
<ext_APInvReceiptBilling:OurQty>16048.70000000</ext_APInvReceiptBilling:OurQty>
<ext_APInvReceiptBilling:OurUnitCost>1.90000</ext_APInvReceiptBilling:OurUnitCost>
<ext_APInvReceiptBilling:PONum>28203</ext_APInvReceiptBilling:PONum>
<ext_APInvReceiptBilling:POLine>1</ext_APInvReceiptBilling:POLine>
<ext_APInvReceiptBilling:PORelNum>1</ext_APInvReceiptBilling:PORelNum>
<ext_APInvReceiptBilling:TranReference/>
<ext_APInvReceiptBilling:PartDescription>ECG 75 0.7Z 172 Binder 630 Bobbin S-1 Treatment Metered Yarn</ext_APInvReceiptBilling:PartDescription>
<ext_APInvReceiptBilling:VendorQty>16048.70000000</ext_APInvReceiptBilling:VendorQty>
<ext_APInvReceiptBilling:VendorUnitCost>1.90000</ext_APInvReceiptBilling:VendorUnitCost>
<ext_APInvReceiptBilling:PUM>KG</ext_APInvReceiptBilling:PUM>
<ext_APInvReceiptBilling:DUM/>
<ext_APInvReceiptBilling:PassedQty>0</ext_APInvReceiptBilling:PassedQty>
<ext_APInvReceiptBilling:FailedQty>0</ext_APInvReceiptBilling:FailedQty>
<ext_APInvReceiptBilling:SysRowID>2016a9a9-c813-4bf6-ad7f-b78acd6cfee9</ext_APInvReceiptBilling:SysRowID>
<ext_APInvReceiptBilling:InVendorUnitCost>0</ext_APInvReceiptBilling:InVendorUnitCost>
<ext_APInvReceiptBilling:SupplierUnInvcReceiptQty>16048.70000000</ext_APInvReceiptBilling:SupplierUnInvcReceiptQty>
<ext_APInvReceiptBilling:Inspection>None</ext_APInvReceiptBilling:Inspection>
<ext_APInvReceiptBilling:LineAmount>30492.530</ext_APInvReceiptBilling:LineAmount>
<ext_APInvReceiptBilling:SelectLine>true</ext_APInvReceiptBilling:SelectLine>
<ext_APInvReceiptBilling:DocLineAmount>30492.530</ext_APInvReceiptBilling:DocLineAmount>
<ext_APInvReceiptBilling:GridVenPartNum>G751720.7Z(S-1)A1630</ext_APInvReceiptBilling:GridVenPartNum>
<ext_APInvReceiptBilling:CurrencyCode>USD</ext_APInvReceiptBilling:CurrencyCode>
<ext_APInvReceiptBilling:Rpt1LineAmount>0</ext_APInvReceiptBilling:Rpt1LineAmount>
<ext_APInvReceiptBilling:Rpt2LineAmount>0</ext_APInvReceiptBilling:Rpt2LineAmount>
<ext_APInvReceiptBilling:Rpt3LineAmount>0</ext_APInvReceiptBilling:Rpt3LineAmount>
<ext_APInvReceiptBilling:DropShip>false</ext_APInvReceiptBilling:DropShip>
<ext_APInvReceiptBilling:DropShipPackSlip/>
<ext_APInvReceiptBilling:DummyKey>4920851c-3104-4867-aae9-7e137099f664</ext_APInvReceiptBilling:DummyKey>
<ext_APInvReceiptBilling:RowMod>U</ext_APInvReceiptBilling:RowMod>
<ext_APInvReceiptBilling:Number01>0</ext_APInvReceiptBilling:Number01>
<ext_APInvReceiptBilling:CheckBox01>false</ext_APInvReceiptBilling:CheckBox01>
<ext_APInvReceiptBilling:UD_SysRevID>AAAAACp9mGE=</ext_APInvReceiptBilling:UD_SysRevID>
</ext_APInvReceiptBilling:APUninvoicedRcptLines>
<ext_APInvReceiptBilling:APUninvoicedRcptLines>
<ext_APInvReceiptBilling:Company>BWF</ext_APInvReceiptBilling:Company>
<ext_APInvReceiptBilling:VendorNum>82</ext_APInvReceiptBilling:VendorNum>
<ext_APInvReceiptBilling:PurPoint/>
<ext_APInvReceiptBilling:PackSlip>28203_20220526</ext_APInvReceiptBilling:PackSlip>
<ext_APInvReceiptBilling:PackLine>2</ext_APInvReceiptBilling:PackLine>
<ext_APInvReceiptBilling:InvoiceNum>TestInvoice</ext_APInvReceiptBilling:InvoiceNum>
<ext_APInvReceiptBilling:PartNum>G751720.7Z(S-1)A2630</ext_APInvReceiptBilling:PartNum>
<ext_APInvReceiptBilling:OurQty>2007.00000000</ext_APInvReceiptBilling:OurQty>
<ext_APInvReceiptBilling:OurUnitCost>1.90000</ext_APInvReceiptBilling:OurUnitCost>
<ext_APInvReceiptBilling:PONum>28203</ext_APInvReceiptBilling:PONum>
<ext_APInvReceiptBilling:POLine>2</ext_APInvReceiptBilling:POLine>
<ext_APInvReceiptBilling:PORelNum>1</ext_APInvReceiptBilling:PORelNum>
<ext_APInvReceiptBilling:TranReference/>
<ext_APInvReceiptBilling:PartDescription>ECG 75 0.7Z 172 Binder 630 Bobbin S-1 Treatment Non Metered Yarn</ext_APInvReceiptBilling:PartDescription>
<ext_APInvReceiptBilling:VendorQty>2007.00000000</ext_APInvReceiptBilling:VendorQty>
<ext_APInvReceiptBilling:VendorUnitCost>1.90000</ext_APInvReceiptBilling:VendorUnitCost>
<ext_APInvReceiptBilling:PUM>KG</ext_APInvReceiptBilling:PUM>
<ext_APInvReceiptBilling:DUM/>
<ext_APInvReceiptBilling:PassedQty>0</ext_APInvReceiptBilling:PassedQty>
<ext_APInvReceiptBilling:FailedQty>0</ext_APInvReceiptBilling:FailedQty>
<ext_APInvReceiptBilling:SysRowID>679287a9-a69c-4dbc-92b1-4bc10602e0e9</ext_APInvReceiptBilling:SysRowID>
<ext_APInvReceiptBilling:InVendorUnitCost>0</ext_APInvReceiptBilling:InVendorUnitCost>
<ext_APInvReceiptBilling:SupplierUnInvcReceiptQty>2007.00000000</ext_APInvReceiptBilling:SupplierUnInvcReceiptQty>
<ext_APInvReceiptBilling:Inspection>None</ext_APInvReceiptBilling:Inspection>
<ext_APInvReceiptBilling:LineAmount>3813.300</ext_APInvReceiptBilling:LineAmount>
<ext_APInvReceiptBilling:SelectLine>true</ext_APInvReceiptBilling:SelectLine>
<ext_APInvReceiptBilling:DocLineAmount>3813.300</ext_APInvReceiptBilling:DocLineAmount>
<ext_APInvReceiptBilling:GridVenPartNum>G751720.7Z(S-1)A2630</ext_APInvReceiptBilling:GridVenPartNum>
<ext_APInvReceiptBilling:CurrencyCode>USD</ext_APInvReceiptBilling:CurrencyCode>
<ext_APInvReceiptBilling:Rpt1LineAmount>0</ext_APInvReceiptBilling:Rpt1LineAmount>
<ext_APInvReceiptBilling:Rpt2LineAmount>0</ext_APInvReceiptBilling:Rpt2LineAmount>
<ext_APInvReceiptBilling:Rpt3LineAmount>0</ext_APInvReceiptBilling:Rpt3LineAmount>
<ext_APInvReceiptBilling:DropShip>false</ext_APInvReceiptBilling:DropShip>
<ext_APInvReceiptBilling:DropShipPackSlip/>
<ext_APInvReceiptBilling:DummyKey>4920851c-3104-4867-aae9-7e137099f664</ext_APInvReceiptBilling:DummyKey>
<ext_APInvReceiptBilling:RowMod>U</ext_APInvReceiptBilling:RowMod>
<ext_APInvReceiptBilling:Number01>0</ext_APInvReceiptBilling:Number01>
<ext_APInvReceiptBilling:CheckBox01>false</ext_APInvReceiptBilling:CheckBox01>
<ext_APInvReceiptBilling:UD_SysRevID>AAAAACp9mJI=</ext_APInvReceiptBilling:UD_SysRevID>
</ext_APInvReceiptBilling:APUninvoicedRcptLines>
<ext_APInvReceiptBilling:APReceiptTotals>
<ext_APInvReceiptBilling:CurrencyCode>USD</ext_APInvReceiptBilling:CurrencyCode>
<ext_APInvReceiptBilling:AvailableTotal>34305.830</ext_APInvReceiptBilling:AvailableTotal>
<ext_APInvReceiptBilling:Company>BWF</ext_APInvReceiptBilling:Company>
<ext_APInvReceiptBilling:DocAvailableTotal>34305.830</ext_APInvReceiptBilling:DocAvailableTotal>
<ext_APInvReceiptBilling:DocSelectedTotal>0</ext_APInvReceiptBilling:DocSelectedTotal>
<ext_APInvReceiptBilling:InvoiceNum>TestInvoice</ext_APInvReceiptBilling:InvoiceNum>
<ext_APInvReceiptBilling:Rpt1AvailableTotal>0</ext_APInvReceiptBilling:Rpt1AvailableTotal>
<ext_APInvReceiptBilling:Rpt1SelectedTotal>0</ext_APInvReceiptBilling:Rpt1SelectedTotal>
<ext_APInvReceiptBilling:Rpt2AvailableTotal>0</ext_APInvReceiptBilling:Rpt2AvailableTotal>
<ext_APInvReceiptBilling:Rpt2SelectedTotal>0</ext_APInvReceiptBilling:Rpt2SelectedTotal>
<ext_APInvReceiptBilling:Rpt3AvailableTotal>0</ext_APInvReceiptBilling:Rpt3AvailableTotal>
<ext_APInvReceiptBilling:Rpt3SelectedTotal>0</ext_APInvReceiptBilling:Rpt3SelectedTotal>
<ext_APInvReceiptBilling:SelectedTotal>0</ext_APInvReceiptBilling:SelectedTotal>
<ext_APInvReceiptBilling:VendorNum>82</ext_APInvReceiptBilling:VendorNum>
<ext_APInvReceiptBilling:SysRowID>00000000-0000-0000-0000-000000000000</ext_APInvReceiptBilling:SysRowID>
<ext_APInvReceiptBilling:RowMod>U</ext_APInvReceiptBilling:RowMod>
</ext_APInvReceiptBilling:APReceiptTotals>
</ext_APInvReceiptBilling:APInvReceiptBillingDataSet>
</ext_Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request:ds>
</ext_Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request:Erp_Proxy_BO_APInvoiceImpl_SelectUninvoicedRcptLines_Request>
</msg:dta>
Anything in the Epicor Server event logs?
Anything different from the error message in the tracking in the Service Connect logs?
We are on 10.2.500.9 BTW