Note that this is only for use when the system has caused an error that needs to be corrected. Script not for use on user data entry errors.
If a customer needs to update a GL register entry to a different account or the system assigned the entry to be an Account_ID of 1, you can update the GL to the proper account using the script below. Replace [Register_ID] with the proper register ID you need to change. Once this is complete execute the Stored Procedure Reset_Totals
update GL_register
set Account_id = ‘’
where Register_ID = '[Register_ID'
