web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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,

I have the same question (0)
  • Mohit Rampal Profile Picture
    12,563 Moderator on at
    RE: Missing customer ID

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

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

    I can see it in custtable on Table Browser:

    pastedimage1681463138284v1.png

  • Suggested answer
    Mohit Rampal Profile Picture
    12,563 Moderator 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.

  • Mohit Rampal Profile Picture
    12,563 Moderator 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.

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

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,850

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 795 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans