Hi All, Am getting the issue below on GP 2018 RTM (version 18.00.0400). I migrated one of the company from original server to a new server. The other companies are still in the old server. Now in the new server after migration, I can't open the smartlist. kindly assist.
Yes.
You can download the 'new' clearcompanies script from this article:
KB 849249 - How to remove a company that is no longer being used in Microsoft Dynamics GP
The direct link is here:
https://mbs2.microsoft.com/fileexchange/?fileID=e1140f50-afc0-4a4d-83ef-e9826aff6d64
Thanks
Derek,
Thank you. Actually I had ran the old script severally as it was giving errors during SQL query execution.
It wasn't running smoothly like I used to see before and unfortunately I didn't know that there is old and new clear company scripts.
One more question, should I have ran the new script??.
Thanks for the update. I'm happy to hear the issue was resolved.
As an added note, I wanted to mention, this issue occurs when using the old ClearCompanies script, more times than not, so make sure that if using this script, it is the 'new' version that omits the ADH00100 table, which is what causes this SmartList error, the old script removes records from this table.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (