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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

What is the way of getting all customers from GP using an eConnect?

(0) ShareShare
ReportReport
Posted on by

HI,

I want get all customers as a list using an eConnect.

Thanks & Regards,

*This post is locked for comments

I have the same question (0)
  • Almas Mahfooz Profile Picture
    11,009 User Group Leader on at

    Do you mean you want to show GP customers in your application? like in lookup or in grid? If yes you can query RM00101 table to get all existing customer list.

    If you mean you want to import customer data inside your application database then you can do small integration to import data from customer related tables.

  • Community Member Profile Picture
    on at

    Thanks for reply, I want get all customers as a list using eConnect.

  • Tim Wappat Profile Picture
    5,713 on at

    Refer to the GP eConnect Programmers Guide, look at "Transaction Requester"

    If you use as the parameters:

    eConnectOut= New eConnectOut()
     
    eConnectOut.INDEX1TO = "0"
    eConnectOut.INDEX1FROM = "z"
    eConnectOut.DOCTYPE = "CUSTOMER"
    eConnectOut.OUTPUTTYPE = 2
    eConnectOut.FORLOAD = 0
    eConnectOut.FORLIST = 1
    eConnectOut.ACTION = 0
    eConnectOut.ROWCOUNT = 0
    eConnectOut.REMOVE = 0

    This should give you a long list of customers and assumes they will all have Customer numbers between 0 and z...

    Requesters are much more powerful, you can create custom ones too, read the docs and this post:
    www.timwappat.info/.../eConnect-Customer-Requester-Document-No-ShipToName-field
  • Community Member Profile Picture
    on at

    Thanks Tim Wappat,

    I know till get the all customers output type as a xml, but I need to serialize and de serialize that output in the form of lists as a customer type using c#.

    Thanks and Regards

    T Vamsikrishna

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

    Ah, well in that case see this example, it is in VB.NET but easy to convert to C#

    msdn.microsoft.com/.../ff623173.aspx

  • Community Member Profile Picture
    on at

    Thanks Tim Wappat.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans