Skip to content


Inactivate GL Accounts

Charles asked 7 years ago
I’m trying to inactivate accounts in GL. I created a map and mapped the account number and the Active column. The Active column I’ve set to a local constant of 0 and a List Option value of False. I also marked the option to update existing records.
Either way, when the map runs, I get a message that says SQL procedure error codes returned. I don’t see any specific error messages. What would be causing this issue?
Jared Dux Staff answered 7 years ago
Are you mapping the Category field?  This is required if it is a posting account.  Once you have the Account Number, Account category, and Active (set to False list option) fields mapped you should be able to set your accounts to inactive.
Charles Allen replied 7 years ago

Well, no. But I’ll try it. I guess a person should check the window to see what’s required if having a similar issue. It was a bit odd to see nothing required in the documentation when it’s obvious you need at least the account number.

Thank you

Lorren Zemke Staff replied 7 years ago

Charles, you are correct, Microsoft eConnect does not state any fields are required for Accounts.

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