Due to scheduled maintenance, some areas of our site are currently inaccessible. Thank you for your patience.

Please reach out to sales@eonesolutions.com with any questions.

Back

Sql procedure error codes returned:

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When running a GL Account map, receiving an error on all accounts that says “Sql procedure error codes returned:” followed by the record information.

This is caused by a shortcoming in the Microsoft eConnect error reporting. If you are creating posting accounts the Account Category becomes a required field. The error message should be “Account category is required if account type is set to a posting account”. When importing the account category, you need to import the full name of the category as a string.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.