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.
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
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.