G/L Year End Diagnostic Queries

Identify lingering "C" Records

As customers transition from to versions with "YREND_SESSION_NO" in glttrx, problems where the trans_type is set to "C" from older versions will arise. The simple solution is to identify these and set the value to "S". Also review these to make sure they aren't unresolved problems from prior years.

This query IDs where a Trans type "C" has a null value or a value from a prior year. This is typical caused by a "Closed" record from a prior year getting assigned a new date (via a GH support query) into the current year.

select X.source_code, X.session_no, X.gl_account, X.trans_type, X.trx_amount, X.trx_date, X.yrend_session_no, X.description_1,XR.TRX_DATE
 from glttrx X
INNER JOIN GLTACCT A ON A.GL_ACCOUNT=X.GL_ACCOUNT AND A.ACCOUNT_TYPE='I'
LEFT OUTER JOIN GLTTRX XR ON XR.SESSION_NO=X.YREND_SESSION_NO
where X.trx_date between :"Close Yr Begin" and :"Close Yr End"
AND X.TRANS_TYPE='C' 
AND (XR.TRX_DATE <:"Close Yr Begin" OR X.YREND_SESSION_NO IS NULL)