Site Search:
Sign in | Join | Help

How to update GP table for Payable Management

Last post 07-22-2008 9:53 AM by Neerman. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 07-17-2008 10:28 AM

    How to update GP table for Payable Management

    HI,

    I am new to this forum and joined just now hoping that I get great help from all of you. My development platform has Microsoft Sharepoint 2003 for Listing the docuements and its metadata, VS 2005, C# for code behind, Captaris 6.0 for workflow, ASP.NET 2.0 for web form, MS SQL Server 2003 for backend database, MS Dynamics GP 9.0.

    In my previous application,I used to save all the metadata from the web form to the SQL Server and sharepoint Ducment library and then manually enter the Account payaments to Dynamic GP under batch mode. Then after, GP takes over the control for the posting to GL.

    Now, my new requirement is to automate this manual entry to GP and integrate the Dynamic GP 9.0 with the other application. All I need to do is to save the meta data from the web form into the one of the table of the Dynamics GP. I have been doing research on how to use eConnect or web service of GP to update the GP table but could not found the detail procedure. So, could you please help me in automating this new requirement.

    Thanking you in advance.

    Filed under:
    • 216.230.116.66
  • 07-17-2008 12:47 PM In reply to

    Re: How to update GP table for Payable Management

    Really, that's too big a question for the forum. You need to read the manual. Start by reading the 'install' guide, then the 'programmers reference'.

    You'll have to decide between using a 'manual' insert - where you form the XML document youreself and submit it or the 'serialized' approach, where you instantiate the eConnect objects and update properties on the object and then submit that object.

     Manual is easier if you're new, serialized requires more codeing but in the end handles more details for you.

    Go down one of these paths and ask as you have questions. But questions smaller in scope.

    Steve Gray, MCDBA
    Technical Editor
    steve@VSToolsForum.com
    • 216.64.79.2
  • 07-17-2008 1:30 PM In reply to

    Re: How to update GP table for Payable Management

    Thanks Guru for your prompt response. Let me simplify my requirement. All I would like to do is in the ASP.NET 2.0 web form, when I hit the submit button, it should call the web service or econnect (I do not know how it works) to update the Dynamic GP table. The entry being made is for the Invoice Accounts Payable in the GP. Web service operation to be used are CreatePayableCreditMemo and CreatePayableInvoice.

    Could it be possible to have some kind of sample project or step-by-step details that shows how ASP.NET form is using the Dynamics GP web service/eConnect to insert new invoice in the GP.

    Thanks

    • 216.230.116.66
  • 07-17-2008 2:20 PM In reply to

    Re: How to update GP table for Payable Management

    Still too big a question. I'm happy to help with questions, but you'll have to do some work first.

     Download and install eConnect 9

    Find the 'Microsoft Dynamcis GP eConnect Programmers Guide', which is a .chm help file that comes with the install

    Read the eConnect Programmer's Guide > .NET Development section. Every single word.

    Let me know what questions you have.

    Steve Gray, MCDBA
    Technical Editor
    steve@VSToolsForum.com
    • 216.64.79.2
  • 07-22-2008 9:53 AM In reply to

    Re: How to update GP table for Payable Management

    I have read the eConnect Programmers Guide " Chapter-.NET Developer Section". I could able to add reference but could nto able to procede further as all the codes are written in VB and I am not familiar with VB code. It would have been better if these explanations are in C#.

    What I am looking for in the project is "How to use eConnect v9 to add new transactions from ASP.NET webform to Dynamics GP 9.0.

    Manual entry into the Dymanics GP is through this step.

    "Transactions>purchasing>Payables Transaction Entry " Form and User enter some data into this fields and calls "Transactions>purchasing>Payable Transaction Entry?PayablesTrasaction Entry Distribution" Form.

    I donot see any sample project which uses ASP.NET web form to connect Dynamics GP through eConnect. Please help.

    • 216.230.116.66
Page 1 of 1 (5 items)