Process Number: 172

Revision Date: 9/8/2004 9:38:00 AM
Revision #: 9
Back | Access Password:
 

GL - Purge/Restore Journal Entries

Office Responsible: DCS - District - Computing Services Process Type: internal
Position Title: Sr. Programmer/Analyst Author: jmoody
Cross Trained Staff: bnoble Manager: DHarris Vice Pres.: RTemple

Timeline (Deadlines or Time-Constraints) :
Fiscal Year End
What must be done before this process is started:
See GL Year End Close (ProcessNo 185)
Which processes are waiting for this process:
Year End Close, Fiscal Services completion of
Source documents or communication with information needed for this process:
JRNL.ENTS
What is the end-result of this process, or the hand-off
Journal entries saved in JExxxx files, for fiscal year xxxx
What steps must be taken independent of the computer system (Manual Process)
Which steps must be taken on a computer (Electronic Process):
to purge (before year end close):
CREATE.FILE JE2002 (modulo 1000?)
SSELECT JRNL.ENTS WITH JRTS.TR.DATE GE "7/1/01" AND WITH JRTS.TR.DATE LE "6/30/02"
(Note how many: e.g., 1139)
COPY FROM JRNL.ENTS TO JE2002 DELETING ("Y" to copy from select list)
(Check expected number.)
(COPY FROM DICT JE2001 TO DICT JE2002)

to restore (after year end close):
SELECT JE2002
COPY FROM JE2002 TO JRNL.ENTS ("Y" to copy from select list)
Related Documents to Process (e.g. Datatel documentation, Government code books, etc.)
Datatel`s GL Reference Manual.
Sbccd`s GLProcedures.doc.
Notes (Cautions, suggestions for improvement, etc.)

Process Number: 172

Revision Date: 9/8/2004 9:38:00 AM
Revision #: 9
Back | Access Password:

 
© 2013 San Bernardino Community College District - All Rights Reserved