Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Missing customer ID

(0) ShareShare
ReportReport
Posted on by 5

Hi

I have a challenge with a missing customer ID in the system

pastedimage1681461967472v1.png

Any input how to solve this? I have tried the record ID but it does not allow me to rename it (its missing compared with the other records) and update through the entity.

Thanks,

  • SnorreL Profile Picture
    SnorreL 5 on at
    RE: Missing customer ID

    Thanks! Appreciated. I will run it with MS for PROD.

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Missing customer ID

    Do you know the Customer Id that should be filled and how it got empty. It can be done from Sql Server but I doubt if anyone will do it.

    I have tested using Excel Add-in and got few errors about lower number sequence and dependent transactions, you can try but if its Production then you can raise ticket to Microsoft to run SQL Script. If non-prod then you or your team can do it. From SQL, it works.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Missing customer ID

    Can you try Excel-Addin. Open in excel and Enter the customer account. You can also update Customer ID from SQL sever if its Non Production environment.

  • SnorreL Profile Picture
    SnorreL 5 on at
    RE: Missing customer ID

    I can see it in custtable on Table Browser:

    pastedimage1681463138284v1.png

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Missing customer ID

    Hi, In which form it is missing and can you see it from SQL Server or Table Browser?

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…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans