Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

No customer summary record exists for this customer ID

(0) ShareShare
ReportReport
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
    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
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans