Skip to main content

Notifications

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

  • Community Member Profile Picture
    on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

    Thanks a bunch! I kinda feel dumb for not catching that but sometimes a second pair of eyes are helpful! Thank you again, it worked!

  • Verified answer
    Josh P Profile Picture
    2,895 on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

    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

  • Community Member Profile Picture
    on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

    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.

  • Josh P Profile Picture
    2,895 on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

    I'll take a look and let you know.

  • Community Member Profile Picture
    on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

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

  • Community Member Profile Picture
    on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

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

  • Josh P Profile Picture
    2,895 on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

    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
    RE: eConnect - Field Service RMA Line/Serial Line error.

    Awesome...thank you!

  • Josh P Profile Picture
    2,895 on at
    RE: eConnect - Field Service RMA Line/Serial Line error.

    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
    RE: eConnect - Field Service RMA Line/Serial Line error.

    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.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans