How can I get more detailed information from the General Ledger, like date of entry, user who entered Journal Entry?

Question:

How can I get more detailed information from the General Ledger, like date of entry, user who entered Journal Entry?

Resolution:

There is a transaction level detail file available that tracks the date, time, user and workstation of each entry, but the profile must already have been set to 'Y' in order to have captured this data.  This Transaction detail  file (GLTDTP) is populated if GL General Profile option 56 POST TRANS INFO TO G/L DETAIL is set to 'Y'.   However, it cannot retrieve that information for entries posted PRIOR to the profile being set to 'Y'. 

Please contact the help desk for more information on the General Ledger Transaction Detail file.

File . . : GLTDTP Record Format . : GLTDT Record Length . : 127
Library . : GLFILE File type . . . : Physical Number of fields . : 18
Text . . : G/L transaction detail TAS

Field Size Typ Key# Text From To
CORP# 3,0 Pk 1 A CORPORATION CODE 1 2
DIV# 3,0 Pk 2 A DIVISION NUMBER 3 4
DEPT# 3,0 Pk 3 A DEPARTMENT # 5 6
GLACT# 6,0 Pk 4 A GENERAL LEDGER ACCT# 7 10
GLPDHH 2,0 Zn 6 A ACCT PERIOD CENTURY 11 12
SYTIME 6,0 Zn SYSTEM TIME 77 82
TRUSER 10 Ch TRANSACTION USER 83 92
TRDATA 30 Ch TRANSACTION DATA 93 122
TRROR# 9,0 Pk RENTAL ORDER# 123 127
GLPDYY 2,0 Zn 7 A ACCT PERIOD YEAR 13 14
GLPDNO 2,0 Zn 8 A ACCT PERIOD NUMBER 15 16
GLBOK# 4 Ch 9 A BOOK # 17 20
GLEXPL 25 Ch 10 A EXPLANATION 21 45
TRAMT$ 11,2 Pk AMOUNT 46 51
APJOB# 5,0 Pk 5 A A/P JOB COST # 52 54
TRDATE 8,0 Zn 11 A TRANSACTION DATE 55 62
TRSEQ# 10,0 Pk 12 A TRANSACTION SEQ# 63 68
SYDATE 8,0 Zn SYSTEM DATE 69 76