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, ... / ClearCompany script re...
Finance | Project Operations, Human Resources, ...
Suggested answer

ClearCompany script reports a conversion error

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

Can someone please remind what the fix is to prevent this error message when running the ClearCompany script?

Conversion failed when converting the varchar value 'MyCpy' to data type int.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: ClearCompany script reports a conversion error

    I believe this blog should help:

    community.dynamics.com/.../error-message-when-running-clearcompanies-script-for-microsoft-dynamics-gp-error-conversion-failed-when-converting-the-varchar-value-abc-to-data-type-int

    Usually it is a CMPANYID or companyID value in some table, that is a string, such as 'MyCpy', but the script is expecting an integer, thus the error.

    The script in the blog will help find any mention of 'MyCpy', letting you know the table/column combinations, then we would want to look through those to find any related to a company ID value.

    Thanks

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 588 Most Valuable Professional

#3
Sumit Singh Profile Picture

Sumit Singh 544

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans