Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

No customer summary record exists for this customer ID

Posted on by 585

When I encountered this issue in SOP Invoice posting, I ran the Customer Master checklinks to fix it.

support.microsoft.com/.../en-us

I've been experiencing this problem almost every month. Do you know what is causing this issue?

Thanks,

Cecile

*This post is locked for comments

  • Cecile Dinh Profile Picture
    Cecile Dinh 585 on at
    RE: No customer summary record exists for this customer ID

    Hi Richard,

    Thanks for your response.  Yes, we use Stored Procedures to load customers from another database to GP.  Do you have the script handy you can share with me?  I will add it in our stored proc?

    Thanks,

    Cecile

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: No customer summary record exists for this customer ID

    If you imported customers and addresses using a SQL script you missed the customer summary record.  Opening the customer card, changing something, and saving will create the record to prove this.  Rather than do this for all customers, write a SQL script that will insert a summary record in the summary record table if the customer cannot be found in that table.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans