Notifications
Announcements
No record found.
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.
The issue is gone.
community.dynamics.com/.../index-0-of-local-array-is-out-of-range-in-script-asi_initialize_explorer_tree-script-terminated
community.dynamics.com/.../unhandled-script-exception-index-0-of-local-array-is-out-of-range-in-script-39-asi-initialize-explorer-tree-script-terminated
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
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??.
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
Thank you so much. Your contribution is always quality and on point.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
