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 not of the GLACSeqno column which is used in the next query.
SELECT glacseqno, glacct FROM GLAcct WHERE glacct = 'XXXXXX' AND glctlacct_flag = 1
Second: Locate the specific G/L Control Account row 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]
Finally: Update the G/L Control Account row with the G/L Account Sequence # obtained in the first step.
UPDATE [GLSGLAcctCtl] SET glctglacseqno = XXX WHERE GLSGLAcctCtlID = XXX