Question:
Is there a way to report GL Audit Information? We need to show who posted GL entries and when.
Resolution:
It appears that the G/L general profile #56 is not turned on your system (set to 'Y' - please see screen shot below.) This posts additional data, including the user ID, into file GLTDTP, which has the same key as GLDETP (the g/l detail file). It will definitely increase the size GLTDTP. Please check the on line manual and notes on the profile (F6) for more detailed information. This would only impact entries made after the profile was turned on. Entries that have already been posted will not be in the database.
DXFM23 General Profile Y/N Maintenance 3/22/12
SFC 12:58:52
Type "Y" or "N", press Enter.
Area . . . . . . . GL GENERAL LEDGER
Rec # Description Y/N Notes
4 BYPASS BOOK LEVEL TOTALS ON J/E EDIT? N
14 HASH TOTALS ON GL EDIT N
29 OLD JE - RETURN CURSOR BOOK/JE# N
30 OLD JE - ALLOW INTERCO N
33 RESTRICT RECURRING J/E ONCE PER PERIOD N *
34 ENABLE CHANGE PERIOD BY RANGE IN J/E Y *
45 NO PAGE BREAK ON J/E EDIT LIST Y *
56 POST TRANS INFO TO G/L DETAIL-AMQUIP Y *
57 DISPLAY TRANS DETAIL INQ/REPORTS-AMQUIP Y *
59 INTERIM J/E POST - LIMIT ENTITIES/ACCTS N *
61 PRINT ACCTG PD DESC ON J/E EDIT Y *
64 DO NOT DELETE EXPIRING RECURRING ENTRIES Y
More...
Message Text
Posts details about the transaction into a separate file with the same key as the G/L detail file. If this is on then detail records whose balance
is set to $0.00 will NOT be deleted.
***************************************************************************
Paul Fuller
Comments