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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect Classes not v...
Microsoft Dynamics GP (Archived)

eConnect Classes not visible in referenced dll Microsoft.Dynamics.GP.eConnect.Serialization\12.0.0.0__31bf3856ad364e35\Microsoft.Dynamics.GP.eConnect.Serialization.dll

(1) ShareShare
ReportReport
Posted on by Community Member

IV_Suggest_Sales_Setup_HDR(IV00400),IV_Suggest_Sales_Setup_LINE(IV00401) These are two classes to insert suggested items in Item card  

These are two tables related to suggested items in Item card and i found that these are the two econnect classes through  this http://www.profad.com/media/259634/company-data-archive-manual-gp-2013.pdf  link but i am not able to access these IV_Suggest_Sales_Setup_HDR, IV_Suggest_Sales_Setup_LINE  2 classes through econnect reference and when i check Microsoft.Dynamics.GP.eConnect.Serialization.dll classes i am not able to see those classes in my dll  using object browser and i figured out that these classes are not available inside econnect dll itself.

Can anybody help me how can i enable and add those classes in my econnect reference ?

I am new econnect and GP please help me in resolving this issue

Thanks 

Sandeep K

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Not all tables can be accessed via the "out the box" eConnect. You will often find corners of GP that have not had the eConnect API created for them. This is one of those. 

    The good news is that eConnect is extendable, but you have to do a little work and write your own SQL and attempt to maintain the biz logic, that can be interesting. 

    Use your internet search engine to look at various articles in results for "econnect custom node"

    I have a few blog posts that might point you in the right direction too:

    http://www.timwappat.info/post/2010/01/04/Piggyback-your-data-on-eConnect-for-Dynamics-GP

    and some useful links in this one too

    http://www.timwappat.info/post/2016/02/10/Custom-eConnect-XML-Node-Procedure-or-function-expects-parameter-which-was-not-supplied

    [edit]

    And this is a wonderful article on how to do it properly and get your own custom econnect serialisation going. 

    https://blogs.msdn.microsoft.com/developingfordynamicsgp/2010/12/02/creating-a-custom-serialization-assembly-for-econnect-for-microsoft-dynamics-gp-2010/

    Tim 

  • Community Member Profile Picture
    Community Member on at

    HI Tim

    As mentioned in blogs.msdn.microsoft.com/.../creating-a-custom-serialization-assembly-for-econnect-for-microsoft-dynamics-gp-2010  link:

     I added 2 custom nodes in IVITemMaster.XSD and generate class file and created a dll and consumed it in my application and created stored procedures with names( [taCreateSuggestedItemsLine],[taCreateSuggestedItemsHrd]) of newly added XML Nodes but it is always throwing error like ITEMNMBR not supplied even I  provide item number along with all 4 values for IV00400

    Procedure or function 'taCreateSuggestedItemsHrd' expects parameter '@I_vITEMNMBR', which was not supplied.

    Can you please  help me out on this

    Thanks

    Sandeep K

  • Verified answer
    Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Have you named your SQL parameters correctly by convention in the SQL stored procedures, that is a common mistake?

    It sounds like you've done well, must be 99% there, this is going to be something silly.

    By all means send me some snippets from your stored procedure header etc if you want me to have a look for you.

     

    Tim. 

  • Community Member Profile Picture
    Community Member on at

    Hello Tim 

    Here is the sample of my implementation

    XSD

    <xs:complexType name="taCreateSuggestedItemsHrd">
    <xs:sequence>
    <xs:element minOccurs="1" maxOccurs="1" name="ITEMNMBR" type="xs:string" />
    <xs:element minOccurs="0" maxOccurs="1" default="1" name="QUOTE" type="xs:byte" />
    <xs:element minOccurs="0" maxOccurs="1" default="1" name="PRDER" type="xs:byte" />
    <xs:element minOccurs="0" maxOccurs="1" default="1" name="FULFILL" type="xs:byte" />
    <xs:element minOccurs="0" maxOccurs="1" default="1" name="INVOICECB" type="xs:byte" />
    </xs:sequence>
    </xs:complexType>

    ALTER procedure [dbo].[taCreateSuggestedItemsHrd]
    @I_vITEMNMBR char(31),@I_vQUOTE tinyint,@I_vPRDER tinyint,@I_vFULFILL tinyint, @I_vINVOICECB tinyint
    as
    BEGIN
    if((select COUNT(*) from IV00400 where ITEMNMBR = @I_vITEMNMBR)!=0)

    Update IV00400 set QUOTE=@I_vQUOTE,PRDER=@I_vPRDER,FULFILL=@I_vFULFILL,INVOICECB=@I_vINVOICECB
    where ITEMNMBR=@I_vITEMNMBR;
    else
    INSERT INTO IV00400
    (ITEMNMBR,QUOTE,PRDER,FULFILL,INVOICECB)
    VALUES(@I_vITEMNMBR,@I_vQUOTE,@I_vPRDER,@I_vFULFILL,@I_vINVOICECB);
    grant execute on dbo.taCreateSuggestedItemsHrd to DYNGRP
    end
    GRANT EXEC ON dbo.sampleLeadCreateUpdate TO DYNGRP

    GO

    The stored procedure is  working fine when i run it from sqlserver

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    I've been away on summer vacation, sorry for the delay in response.

    What you are doing looks great.

    First thing that stands out to me is that you must implement the error reporting parameters in the stored procedure,

    see this url for more info: msdn.microsoft.com/.../dd996509.aspx

    Implement

       @O_iErrorState int OUTPUT,

       @oErrString varchar(255) OUTPUT

    For development purposes, just default them,

    /** Declare local variables **/

    declare

       @iStatus int,

       @iAddCodeErrState int,

       @exists tinyint,

       @O_oErrorState int,

    /** Initialize local variables **/

    select @O_iErrorState = 0,

       @iStatus = 0,

       @exists = 0,

       @O_oErrorState = 0,

    if (@oErrString is NULL)

    begin

       select @oErrString = ''

    end

    Other than that, I've compared your snippet with a similar production bit of code I'm running -and it looks the same shape, so I'm struggling to see what else could be wrong.

    Could you run SQL profiler to see what SQL eConnect is generating against the database, it might give a clue?

    Tim.

  • Community Member Profile Picture
    Community Member on at

    I need to restart the eConnect Service in services as we modify the schema, so after restarted it worked fine for me.Yes ofcourse i need to add error handling as you mentioned in my procedure.  

    But i am facing a new problem as we can insert mutiple items as suggested line items , i placed maxOccurence="unbounded" and i am geeting array as expected,but i am not getting a clue how to implement stored procedure to insert multiple line items on a sigle hit.

    Can you help me out on this.

    Thanks

    Regards

    Sandeep K

  • Verified answer
    Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Oh yes I should have remembered that one- see my point about restarting the service in this post, catches everyone out at some point:

    www.timwappat.info/.../Custom-eConnect-XML-Node-Procedure-or-function-expects-parameter-which-was-not-supplied

    Regarding inserting multiple suggestions at once. eConnect is not efficient in that way, in its design it intendeds you to put multiple nodes in XML to insert the each suggestion, one at a time, as you would if you were using a native node like inserting new items.

    Remember you can do many inserts in one XML document, but keep an eye on the size of the XML document generated.

    Tim

  • Community Member Profile Picture
    Community Member on at

    I am getting multiple XML nodes in XML Document but i am getting the problem when I hit the stored procedure with multiple suggested items.

    I am getting the fallowing error as like before

    Procedure or function 'taCreateSuggestedItemsLine' expects parameter '@I_vITEMNMBR', which was not supplied.

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Keep restarting the service as any change is cached.

    It seems to be trying to call the SP.

    Tim.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans