It seems that regardless of how much testing you do, something can still slip through the cracks. Well after v10.00 Service Pack 4 was released, an issue with the SmartList Builder/Excel Report Builder code was identified. A Hot Topic has been posted with a temporary workaround fix.
Here is an excerpt from the Hot Topic:
After installing Service Pack 4 for Microsoft Dynamics GP 10.0, you will receive the error Wrong number of arguments to 'Replace_Text' when using areas of SmartList Builder and Excel Report Builder. For example, the error appears completing the following: Clicking Publish in Excel Report Builder. Saving a calculation in SmartList Builder or Excel Report Builder. Exporting the SmartList Builder or Excel Report Builder setup to a file.
After installing Service Pack 4 for Microsoft Dynamics GP 10.0, you will receive the error Wrong number of arguments to 'Replace_Text' when using areas of SmartList Builder and Excel Report Builder. For example, the error appears completing the following:
The fix is an updated SmartList Builder dictionary which needs to be installed after loading Service Pack 4. Please see the following links for the full details:
Hot Topic – Service Pack 4 for Microsoft Dynamics GP 10.0 Causes Errors in SmartList Builder and Excel Report Builder
CustomerSourcehttps://mbs.microsoft.com/customersource/support/knowledgebase/hottopics/hot_topic_MDGP10_PostSP4Fix.htm?printpage=false
PartnerSourcehttps://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/hot_topic_MDGP10_PostSP4Fix.htm
The main Service Pack, Hotfix and Compliance Update and Service Pack 4 pages have been updated with a note linking to the Hot Topic page.
David
Posting from DynamicAccounting.net
http://msdynamicsgp.blogspot.com/2009/09/hotfix-for-sp4-issues.html
Posting from DynamicsBlogger
http://janakirammp.blogspot.com/2009/09/updated-smartlist-dictionary-released.html
Just had this error come up and while I remembered there was a fix, I could not find it in the GP KnowledgeBase. However a quick internet search resulted in finding this post. Thanks again David for all the help you provide to the GP community!
-Victoria
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.