web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

eConnect - Field Service RMA Line/Serial Line error.

(0) ShareShare
ReportReport
Posted on by

I am in the process of creating a custom interface to receive items on an RMA and am using eConnect to do this in a GP Dynamics 2010 environment. I am encountering an error that specifies the Return_Record_Type is missing. In the XML document it is clearly there. I am attaching the error and xml document along with the code that is setting it. I am using C# to perform this.

Any help or assistance with this would be great.

//RMA Serial Item ( GP Table: SVC05255)

detailcount = 0;

taFSRMALineSerial_ItemsTaFSRMALineSerial serialitem = new taFSRMALineSerial_ItemsTaFSRMALineSerial();

serialitem.Return_Record_Type = 1;

serialitem.RETDOCID = rmaheader.RETDOCID;

serialitem.CUSTNMBR = rmaheader.CUSTNMBR;

serialitem.LNSEQNBR = 100;

serialitem.QTYTYPE = 1;

serialitem.ITEMNMBR = "VX510 DC";

serialitem.SERLNMBR = "2-2-2-2";

serialitem.SERLTQTY = 1;

serialitem.SLTSQNUM = detailcount + 1;

serialitem.ADRSCODE = "PRIMARY";

serialitem.LOCNCODE = "RETURN";

serialitem.SVC_Original_Serial = 1;

serialitem.SVC_Original_SerialSpecified = true;

serialitem.UpdateIfExists = 1;

serialitems[detailcount] = serialitem;

eConnect Error:

Procedure or function 'taFSRMALineSerial' expects parameter '@I_vReturn_Record_Type', which was not supplied.

XMLDocument:

<?xml version="1.0" ?>

- <eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">

- <FSRMAType>

 <eConnectProcessInfo xsi:nil="true" />

 <taRequesterTrxDisabler_Items xsi:nil="true" />

- <taFSRMALineSerial_Items>

- <taFSRMALineSerial>

 <Return_Record_Type>1</Return_Record_Type>

 <RETDOCID>RMA0KFP000002</RETDOCID>

 <CUSTNMBR>BBTFINANC027494</CUSTNMBR>

 <ADRSCODE>PRIMARY</ADRSCODE>

 <LNSEQNBR>100</LNSEQNBR>

 <ITEMNMBR>VX510 DC</ITEMNMBR>

 <SERLNMBR>2-2-2-2</SERLNMBR>

 <LOCNCODE>RETURN</LOCNCODE>

 <SLTSQNUM>1</SLTSQNUM>

 <SVC_Original_Serial>1</SVC_Original_Serial>

 </taFSRMALineSerial>

 <taFSRMALineSerial xsi:nil="true" />

 </taFSRMALineSerial_Items>

- <taFSRMALine_Items>

- <taFSRMALine>

 <Return_Record_Type>1</Return_Record_Type>

 <RETDOCID>RMA0KFP000002</RETDOCID>

 <RETTYPE>RP</RETTYPE>

 <RETSTAT>20</RETSTAT>

 <CUSTNMBR>BBTFINANC027494</CUSTNMBR>

 <ADRSCODE>PRIMARY</ADRSCODE>

 <ITEMNMBR>VX510 DC</ITEMNMBR>

 <ITEMDESC>0126011 - P/N M251-060-36-NAA VX510 DC 6-meg</ITEMDESC>

 <LOCNCODE>RETURN</LOCNCODE>

 <RETORIG>1</RETORIG>

 <LNITMSEQ>100</LNITMSEQ>

 <QUANTITY>1</QUANTITY>

 <UOFM>EACH</UOFM>

 <CUSTOWN>1</CUSTOWN>

 </taFSRMALine>

 <taFSRMALine xsi:nil="true" />

 </taFSRMALine_Items>

- <taFSRMAMaster>

 <Return_Record_Type>1</Return_Record_Type>

 <RETDOCID>RMA0KFP000002</RETDOCID>

 <RETORIG>1</RETORIG>

 <RETSTAT>10</RETSTAT>

 <RETTYPE>RP</RETTYPE>

 <LOCNCODE>RETURN</LOCNCODE>

 <CUSTNMBR>BBTFINANC027494</CUSTNMBR>

 <ADRSCODE>PRIMARY</ADRSCODE>

 <CUSTNAME>BB&T Financial, FSB</CUSTNAME>

 <CONTACT>Attn.: BB&T Equipment Manager</CONTACT>

 <ADDRESS1>2713 Forest Hills Road</ADDRESS1>

 <CITY>Wilson</CITY>

 <STATE>NC</STATE>

 <ZIPCODE>27893</ZIPCODE>

 <Bill_To_Customer>BBTFINANC027494</Bill_To_Customer>

 </taFSRMAMaster>

 </FSRMAType>

 </eConnect>

*This post is locked for comments

I have the same question (0)
  • Josh P Profile Picture
    2,895 on at

    Hi Kevin,

    Did you modify the underlying stored procedure for this eConnect call by chance?

  • Community Member Profile Picture
    on at

    No, not at all. In fact when I execute the stored proc and pass in just the params I am using, it inserts just fine. I did not use the pre or post procs though.

  • Josh P Profile Picture
    2,895 on at

    I don't see anything glaring at me as wrong, but it could be the formatting. Let me try to load up a unit test, and see if I can duplicate the error. It may take me a little bit, so please post if you figure it out first.

  • Community Member Profile Picture
    on at

    Awesome...thank you!

  • Josh P Profile Picture
    2,895 on at

    Actually, if you could post your .cs file for this integration so I can use your settings, that would help. You can attach a file in rich formatting mode.

  • Community Member Profile Picture
    on at

    I had to make a copy and rename it to a .txt file to upload.

  • Community Member Profile Picture
    on at

    It is a crude app to prep for a project so forgive all the messiness, haha.

  • Josh P Profile Picture
    2,895 on at

    I'll take a look and let you know.

  • Community Member Profile Picture
    on at

    I thought I would let you know as well, there is a section in it in which I am adding the QTYTYPE  to the XML, it seems that after serialization is done, it dissappears, so I was adding it back in for debugging purposes thinking it was blowing up for that reason.

  • Verified answer
    Josh P Profile Picture
    2,895 on at

    Alright, check this out. Your when I create a test unit, I am not getting an errors, but when I compare your XML to my XML, I notice that in the taFSRMALineSerial_Items and taFSRMALine_Items collections, you have a single null node following your line item details. I believe this might be causing your error. My file does not have these.

    This tells me there might be something in your OrderDetails collection that is causing an extra entry to be made into the serialization process for each section.

    Here is a Gist link for the XML you get, and I marked the two lines that show the potential problem areas. Let me know what you find out.

    gist.github.com/.../f0f5cc98b51003584e80

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans