Error when opening smartlist

(0) Share

Report

Posted on by Romryan

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.

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (0)

Romryan on at

Like (0)

Report

RE: Error when opening smartlist

Derek,

Thank you so much. Your contribution is always quality and on point.
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Error when opening smartlist

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
Romryan on at

Like (0)

Report

RE: Error when opening smartlist

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??.
Suggested answer

Derek Albaugh on at

Like (1)

Report

RE: Error when opening smartlist

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
Suggested answer

Romryan on at

Like (0)

Report

RE: Error when opening smartlist

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