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.
Best answer by Laura02View original
I have changed the account type in GL Chart of Accounts as follows:
I have tried this option but I get this when I try to Reclassify all
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.
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.
@kbeatty21 I will do just that. @laura01 I appreciate you advice.
See page 91 of this document
Good catch Freeman. I just watched the video on the 2023R1 changes today and was happy to see that.