...
First, locate the G/L Account Sequence # of the G/L Account # you wish 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.
Replace AA-AA-AAA-AAAA-AAAA with the G/L Account # you wish to change it TO.
SELECT glacseqno, glacct FROM GLAcct WHERE glacct = 'XXXXXXAA-AA-AAA-AAAA-AAAA' 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 note of the GLSGLAcctCtlID column which is used in the next query.
Replace BB with the Company Code; Replace CC with the Division Code.
SELECT GLSGLAcctCtlID, * FROM [dbo].[GLSGLAcctCtl] WHERE glctcocd = 'XXBB' AND glctdivcd = 'XXCC'
Finally, update the G/L Control Account row with the G/L Account Sequence # obtained in the first step (DD), and the GLSGLAcctCtlID (EE) found in the second step.
UPDATE [GLSGLAcctCtl] SET glctglacseqno = XXXDD WHERE GLSGLAcctCtlID = XXXEE