Re: Need tips on \"Purging\" of F0911
First go to menu G09317 .
When purging the first thing is you must summarize your data. This
process will generate summarized transaction types "BF" for each account
and period . The records it summarized will have the field GLSUMM set
with a "Y" .
There is also an AAI where you can define accounts which should never be
summarized .
Once the data is summarized you can run the purge program and only select
the records which have been summarized .
Tips
We maintain the same retention across all the systems i.e A/P, A/R
Purchasing is retained for 3 years . When we purge we
purge them all.
When you summarize you may also want to exclude certain ledger types. i.e
"BA" .
Write reports for the different files and have them processed into fiche
and/or burnt to CDs .
Another approach I have seen presented at Focus2000 was to write your own
custom programs which goes through and flags records that you can and/or
cannot delete. This program would be more robust in that it could go
across the different files an could maintain data integrity. For example if
an invoice was still unpaid then it wouldn't' allow the corresponding F0911
records to be summarized .
It sure would be nice if JDEdwards had a fully integrated purge program in
their system which would purge data and maintain integrity across all the
systems .
World A7.3 c 12 .
Michael Kenney
IT Services
University of Windsor
fcomron
<
[email protected] To:
[email protected]
om> cc:
Sent by: Subject: Need tips on "Purging" of F0911
owner-jdeworld@j
delist.com
10/17/2001 11:35
AM
Please respond
to jdeworld
__________________________________________________