Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Best way to define Customer Number

(0) ShareShare
ReportReport
Posted on by 18,267

One of my friend is having his own eCommerce web site and he sells his items on ebay,Amazon and other eCommerce site. What will be best way to define customer number?

Thanks

Sandip

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to define Customer Number

    The customer numbering sequence - which becomes the Customer ID in GP...could just be sequential numbering?

    The analysis could be handled through the customer class ID and the user defined fields.

    It would be a lot easier to just code a sequential number for customer ID. So each time a new customer adds themselves - you increase the last number by one - then auto generate the class ID based on location, business sector, customer type etc. This way you can use the class ID to roll down common values during integration [I presume you are using eConnect?] - and you can analyse / report based on the class ID.

    Ian.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Best way to define Customer Number

    Hi Sandip,

    The other thing I would do is to document the naming rules as a window note on the customer maintenance window.

    Kind regards,

    Leslie

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: Best way to define Customer Number

    Hi Moh'd,

    Much appreciate your response.

    Thanks

    Sandip

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Best way to define Customer Number

    I am actually thinking of considering several factors when numbering these customers, especially that the customer segmentation is almost narrow to e-commerce businesses.

    Although, I might think of the following categorization to be considered as a suggestion:

    • e-commerce Type Segment (BB, BC): in your case, it is apparently only business to business, I would consider BC for any possible future expansion
      • B2B Business to Business
      • B2C Business to Customer
    • Business Branch Segment: regardless of the fact that an online website is not restricted to one location, it is needless to say that each e-commerce business could have several branches in several countries (Amazon for instance has several branches all over the world such as Germany, France, Italy ...etc), I would limit the branch segment into two characters as derived from the ISO country code
      • FR for France
      • IN for India
      • ...etc
    • Customer Name Segment: distinguished characters through which the business can be clearly  figured out
      • AMZ for Amazon
      • EBY for ebay
      • .. etc

    All in all, the Customer number will be as follows;

    e-commerce type - Branch Code - Customer Name - Serial

    As a matter of fact, Amazon Branch in France would be coded as follows

    BB-FR-AMZ-001

    Hope this helps !

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: Best way to define Customer Number

    One more - He is using Dynamics GP. We want to define Customer ID in Dynamics GP.

    Thanks

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans