Undo Year End Processing

Starting with Keyston 3.6.29, G/L Year End records the Year End Session number when closing. This allows for better diagnostics as you can track which transactions were rolled into the resulting Retained Earnings 'R' type entry.

As a result of this change, there are now 3 changes required in order to Undo a g/l year end...

• Set the transaction type from 'C' back to 'S' for all closed transactions
• Set the YREND_SESSION_NO to null for all closed transactions
• DELETE the 'R' record

First identify the 'R' transaction for the retained earnings account. Then substitute it for <R SESSION> in this script...

update glttrx set trans_type = 'S' where trans_type ='C' AND YREND_SESSION_NO=<R SESSION>;
 
update glttrx set YREND_SESSION_NO=NULL where YREND_SESSION_NO=<R SESSION>;
 
DELETE FROM GLTTRX where SESSION_NO=<R SESSION> AND TRANS_TYPE='R';