Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Remove references to Deleted company

(0) ShareShare
ReportReport
Posted on by 55

Hello,

I recently deleted the test company I created for a client. However I can see records in the system database pointing to this Deleted company id. How can I handle this scenario. Is there an option to Delete a company which automatically removes the orphan records in the system database. Please guide me.

Regards,

Srinivas Damodaran

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Remove references to Deleted company

    nope. No file. No ClearCompanies.sql

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Remove references to Deleted company

    Here is the ClearCompany script. This will clear up anything that is left over.

    support.microsoft.com/.../855361

    Make sure you have removed the company database from SQL.

  • Verified answer
    Naga Kiran Profile Picture
    on at
    RE: Remove references to Deleted company

    Hi Srinivas,

    Please look at below KB article.

    support.microsoft.com/.../968058

    The best option to delete a company is by using the utility Delete Company (Tools > Utilities > System > Delete Company)

    Hope this helps.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans