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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Customer ID Does not E...
Finance | Project Operations, Human Resources, ...
Answered

Customer ID Does not Exist

(2) ShareShare
ReportReport
Posted on by Taylor_Greenwood 395
We have a customer who seems to have disappeared from RM00101, thus any time we go to enter something for them GP states that the "Customer ID does not exist." All the info is still in RM00102, RM00103, RM00104 etc. We are also getting an error message under receivables transactions on the main screen which I believe is related. See below:
 
Is this as simple as re-entering the customer card, or do I need to run check links, or is there a SQL script I can run to rebuild the RM00101?
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Pierre D. Profile Picture
    Pierre D. 42 on at
    Customer ID Does not Exist
    Hi 
    First do a backup, then re-enter the customer card (don't forget to use the same Address ID found in table RM00102) and then do a check links. I would not recommend to just do the Check Links since it could decide just to delete all the information or just recreate the card will minimum information.
     
    Hope it helps
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,069 Most Valuable Professional on at
    Customer ID Does not Exist
    It should not have been possible to delete a customer that is still in use in the system.
     
    I think you should be able to just re-enter the customer with the same ID as it had before.
     
    If it gives an error, you could add the record to the RM00101 table via SQL with just the Customer Number and Customer Name fields.
     
    Then come back to GP and fill in the rest of the details.
     
    One trick that might work.
     
    If you can find the record by restoring a backup to a test company or environment.
     
    You can use the SQL server Edit table feature.  Highlight the entire row and copy it to the clipboard.
     
    Then on your live system, use edit table, click on the blank line to highlight entire line and then paste. Then move down to the next line to force the new line to save.
     
    Then in GP check it is working again.
     
    Good luck.
     
    Kind regards
     
     
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 855 Super User 2025 Season 2 on at
    Customer ID Does not Exist
    Do you use GP's Service Management Series (Service Calls)? 
    We have a client using Service Call Management that often loses a customer.  The record is there but the customer ID is blank.

    Try this SQL Script:

    Select * from rm00101 where custnmbr=''

    If it returns a record, verify if it is the missing customer.  (If it is, and you are comfortable with SQL, you can update the custnmbr to be the missing customer number.)

    (If there is no record, do a second search looking for the customer name.  For example, if the customer's name is "ABC Electric", search for something like select * from rm00101 where custname like '%ABC%'.)

    I can provide more detail on the full data check we do for this if it sounds like the issue you are experiencing.  (It is a long-time support issue with Microsoft and we manage it through shadow tables to capture changes to customers, service calls, and equipment.)
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,976 on at
    Customer ID Does not Exist
    Just adding something else to this if you aren't using Field Service.
     
    You might want to use Field Level Security to possibly remove access to the Delete button in Customer Maintenance to anyone but admins. Honestly, as David said, you can't just delete a customer when there is other historical data out there for it, but it never hurts to look over the process and plug any holes.
     
    My opinions, of course.
     
    Joe
  • Verified answer
    Taylor_Greenwood Profile Picture
    Taylor_Greenwood 395 on at
    Customer ID Does not Exist
    I was able to just re-enter the customer card, and after I put in the customer ID and name, it allowed me to select an address etc. 

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans