WikiAdmin: 1 revision imported

2023-07-14T12:58:50Z

1 revision imported

← Older revision

Revision as of 12:58, 14 July 2023

Chanson: Created page with "===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 version..."

2022-08-02T11:57:54Z

Created page with "===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 version..."

New page

===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.

<PRE>
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)
</PRE>

G/L Year End Diagnostic Queries - Revision history

WikiAdmin: 1 revision imported

Chanson: Created page with "===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 version..."