How to re-open and close Period in SQL with SQL Studio.

To re-open:

UPDATE cfcommon_period_tran SET statusid = 1 WHERE isactive = 1 AND modulerefid = 1 AND period_code = 'Jan - 20'

To re-close:

UPDATE cfcommon_period_tran SET statusid = 2 WHERE isactive = 1 AND modulerefid = 1 AND period_code = 'Jan - 20'

Transferred from ZohoDesk

Created By: Bright Lartey