Skip to content


Excel Template – The parameter is incorrect.

Renee asked 7 years ago
I created a simple GL Journal Entry Excel Template in SmartConnect for import into Dynamics GP 2015.  I did not use the canned ones because I am using Binary Stream’s Multi-Entity Management module so I needed to add a User Defined Field for Entity.
However, when I click Submit in Excel, I receive the following error: 
The parameter is incorrect.
Any idea how to go about identifying what is wrong?
Lorren Zemke Staff replied 7 years ago

Renee, Can you run the map used against that Excel file, the SC Values Sheet, manually in SmartConnect?

Renee replied 7 years ago

Hmmm…I don’t actually see an “SC Values Sheet” in my Excel template. I have the following tabs: (1) SmartConnectConfig (2) Sheet2 (3) Template. I was able to import the Sheet2 tab manually in SmartConnect.

I’m not entirely certain I have the Web Service installed let alone configured. Is that needed for this? If so, how do I go about installing it?

Renee replied 7 years ago

Ok, I now see that I can install the Web Service from the installation media. However, when I attempt to do so, I receive the following error: SmartConnect ended prematurely because of an error.

How can I find out more information? I tried running the executable as Administrator but received the same error.


Renee replied 7 years ago

Disregard. I needed to install IIS. Now let me see if I can run the Excel template!

If you would like to submit an answer or comment, please sign in to the eOne portal.