Is there anyway of changing the account type of a GL Account from the database. I understand its not possible from Acumatica’s Chart of Account screen so I think a script is the most possible options but I am not sure which tables store the account type.
Page 1 / 1
Hello,
I have changed the account type in GL Chart of Accounts as follows:
- Set up a new account of the desired/target type
- Use GL Reclassify feature to move all historical transactions from the old account with incorrect type, to the new account with correct type.
- Change number of ‘bad’ account to something different.
- Change the number of the new ‘good’ account created in step 1 to use the desired account number. Now your old account number is of the correct type.
- Inactivate the ‘bad’ account.
Good luck!
I have tried this option but I get this when I try to Reclassify all
Hi,
Not all transactions can be reclassified, sometimes. If there is an ending balance in the account and the transactions making up the balance cannot be reclassified, then you can use a journal transaction entry to move your ending balance from the ‘old’ account to the new one.
Hi
You can not change this even on the database. Once there are transaction you have to create a new account and do a Journal Entry.
Thanks
See page 91 of this document
AcumaticaERP_2023R1_Beta_ReleaseNotes_full.pdf (acumatica-builds.s3.amazonaws.com)
Good catch Freeman. I just watched the video on the 2023R1 changes today and was happy to see that.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.