Random Scripts

07/19/2024 11:18 am EDT
//Update gl_accounting_period Set Status = 'C' where start_date = '2020-08-1

-- Select to reopen_close fiscal year

SELECT * FROM GL_Accounting_Period ORDER BY Accounting_Period_ID DESC

-- to see which Accounting_Period_Id you wanna target

// UPDATE GL_Accounting_Period SET Status = 'R' WHERE Accounting_Period_Id in (x,y,z)

-- "R" is to Re-Open use same script to close back instead "C"

--tell them that's re-open status only - safeguard against anyone who might fudge a date wrong that has open-access rights ..... only admins/controllers would have the R (re-open) status

--never SET Status = 'O' in other words.... unless they say "Oh, it won't let me!"

-- close fiscal year after customer is done

// UPDATE GL_Accounting_Period SET Status = 'C' WHERE Accounting_Period_Id in (x,y,z)
Was this article helpful?