...
| Info | ||
|---|---|---|
| ||
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 , locate the G/L Account Sequence # of the G/L Account # you which wish to change it TO. Take not note of the GLACSeqno 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 , locate the specific G/L Control Account row record that you wish to modify. Pay special attention to the Company, Division, and Transaction Description rows to find the appropriate record. Take not 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 = 'BB' AND glctdivcd = 'CC'
Finally: Update , 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