anyone have a faster way to merge GL Accounts than...
# general
a
anyone have a faster way to merge GL Accounts than using the UI? We have a very messy chart of accounts, and we're trying to merge a bunch of similar accounts together, but the volume of historical transactions in these accounts is huge and the response just errors out
r
I don't think I've tried tbh. You might be stuck creating new accounts and transferring balances.
a
Hoping that's not the case since we're trying to merge Inventory accounts. We're in the apparel business and have thousands of items we wouldn't be able to update the default accounts for short of deactivating and re-creating them
s
You could try it by initiating the merge via a suitescript as it may avoid the error since a script will normally run for an hour before being forced to end. You could also run it during overnight hours when more system resources are available.
a
@Simon Whittle thanks we might try a script, it's just unfortunate since we have a ton of GL accounts (prior controller set it up like QB) so we may have to continuously edit the script
s
try it with one and see because it might still be better than trying to reclass everything into a new account.
a
@Simon Whittle since the folks writing this script aren't going to be accounting folk, do you know all the background processes that happen during an account merge that we'd need to mimic w/ scripting?
s
You should be able to execute the merge operation via script in the same way that it's initiated via the UI. You're not replicating the merge process, simply executing it via script.
a
awesome thanks