After setup, G/L Control Accounts cannot be changed through the Aeros ERP interface. Any changes must be made directly through a SQL command.
WARNING
Note: DO NOT run this command against a LIVE database without reviewing the change, the reason for change, and its effect on the rest of the system with the Professional Services Manager and/or Customer Support Department Manager.
First, locate the G/L Account Sequence # of the G/L Account # you which to change it TO. Take note of the GLACSeqno column which is used in the next query. If no records are found, you will want to check the G/L Account # and ensure that the G/L Account is setup as a Control Account.
SELECT glacseqno, glacct FROM GLAcct WHERE glacct = 'XXXXXX' AND glctlacct_flag = 1
Second, locate the specific G/L Control Account record that you wish to modify. Pay special attention to the Company, Division, and Transaction Description rows to find the appropriate record. Take not of the GLSGLAcctCtlID column which is used in the next query.
SELECT GLSGLAcctCtlID, * FROM [dbo].[GLSGLAcctCtl] WHERE glctcocd = 'XX' AND glctdivcd = 'XX'
Finally, update the G/L Control Account row with the G/L Account Sequence # obtained in the first step, and the GLSGLAcctCtlID found in the second step.
UPDATE [GLSGLAcctCtl] SET glctglacseqno = XXX WHERE GLSGLAcctCtlID = XXX