Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GetNextDocNumbers for Customer/Vendor using eConnect

Posted on by 65

I'm creating a new customer using eConnect and when the CUSTNMBR is already exist the CreateEntity method throw an exception (when the UpdateIfExists flag is set to zero).

Is there any option to get the next customer number?

I see the GetNextDocNumbers can be used to get the next number for some documents but not for customer (or vendor).

Thanks.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GetNextDocNumbers for Customer/Vendor using eConnect

    You can add code to the taUpdateCreateCustomerRcdPre stored procedure to default your Customer ID.

    If you want to move to a more flexible mapping tool and also manage integrations from simple to extremely complex, consider using ezCinect which can be found by doing a web search. ezCinect allows you great flexibility to set variables for the integration as well as perform various automations.

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: GetNextDocNumbers for Customer/Vendor using eConnect

    Ramlul -

    Your question has been asked before.  Here is a previous thread about the issue.

    community.dynamics.com/.../80967.aspx

    1. Ethotech sells a modification to automate this www.ethotech.com.

    2. You can write your own customization - assuming you have the skill set.

    3. You can have a partner write a customization for you.

    You'll want to be very careful about this, because you need to start by reliably determining when a new customer number must be created, and when a customer already exists.  The procedure for this will vary based on where your customers are sourced from.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans