Hi Everyone,

 

If you haven’t heard, we on the GP team are starting a new video blog series on YouTube where we provide some helpful tips on various troubleshooting throughout the program.

 

Well, I’m here to provide you with another one that focuses on some common SmartList issues. There is some general SmartList troubleshooting tips as well as some pointers on a few of the more common errors that we see.

 

I’ll also provide the links and scripts below that you can use alongside the steps.

 

ASI_INITIALIZE_EXPLORER_TREE

“Unhandled script exception: Index 0 of local array is out of range in script 'AsI_Initialize_Explorer_Tree. Script terminated.” - Microsoft Dynamics GP Community

 

ASI_Initialize_Explorer_Favorites Troubleshooting - Microsoft Dynamics GP Community

 

INSERT DATA FROM MAIN TABLE TO TEMP TABLE:

https://mbs2.microsoft.com/fileexchange/?fileID=c4ebdbce-a017-4ee0-9b9b-0b43273b8dd5

 

RECREATE ASIEXP81 (Default)

https://mbs2.microsoft.com/fileexchange/?fileID=89f31ef9-c277-4861-9909-bf16bab5926a

 

SmartListEnhancedExcelExport=TRUE

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2010/05/13/smartlist-exports-slowly-to-excel-part-1/

 

UseCOMForExcelExport = TRUE

https://community.dynamics.com/gp/b/dynamicsgp/archive/2014/08/22/gp-2013-r2-copy-and-paste-from-excel-to-gl-nothing-happens.aspx  

 

As always, if you need further assistance or have any questions, we’re always ready to assist you in a support case.

 

Happy SmartListing!

 

-Jake Gilleshammer