tpayne
Reputable Poster
RE: PURGING FILES
Back to this old topic, we have now run some GL purges in CRP and found some
interesting points that I could not find documented anywhere, and which you
might find useful.
The GL purge is performed in 2 stages:
Firstly, program P09811 needs to be run to summarise data that you are going
to drop from the F0911 file. The DEMO versions do not contain any date
selection, just a processing option which is the "number of months detail to
retain". It appears that this assumes that there are 14 months in a year,
even if you do not use all 14, therefore if you specify to retain 24 months
in detail, that is effectively 1 year and 10 months. I assume the program
calculates the cutoff period based on the current month and the number of
months to retain. This program determines which records to summarise
(posted only), flags them as having been summarised (field GLSUMM="Y") and
creates Bought Forward records (GLDCT="BF") with the same total.
The second program P09911 prompts you to select the year to be dropped (1
year at a time) and deletes all records for that year (other than BF) from
the F0911, copying them to file F0911yy in your production library.
Here is the crunch! If you only summarise part of a year, due to the fact
that you specify a number of period to retain in detail, the DEMO version of
F09911 does not select only those records which have been summarised - it
selects everything for that year except the BF document type. Therefore,
your ledger will be out of balance - oops!
What we have done is:
(1) On the F09811 summarisation, we have added a date selection so that no
matter what number of periods we are to retain, only F0911 records prior to
the year we want to purge are summarised. We have reduced the number of
periods so that we can guarantee that full years will be processed.
(2) On the F09911 purge, we have added the Summarisation flag to the data
selection, so that only summarised records are purged.
We are still running tests - takes forever just to copy the F0911 let alone
to run the summarisation, but I think we have it licked now.
Hope this helps.
----------------------------------------------------------
Tony Payne - Senior Systems Analyst
Selmer-UMI Inc.
Elkhart, Indiana 46516
Work: (219) 522 1675 ext. 451
Email: [email protected]
(Running JDE A73 cum 10 on V4R3M0)
Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516
Back to this old topic, we have now run some GL purges in CRP and found some
interesting points that I could not find documented anywhere, and which you
might find useful.
The GL purge is performed in 2 stages:
Firstly, program P09811 needs to be run to summarise data that you are going
to drop from the F0911 file. The DEMO versions do not contain any date
selection, just a processing option which is the "number of months detail to
retain". It appears that this assumes that there are 14 months in a year,
even if you do not use all 14, therefore if you specify to retain 24 months
in detail, that is effectively 1 year and 10 months. I assume the program
calculates the cutoff period based on the current month and the number of
months to retain. This program determines which records to summarise
(posted only), flags them as having been summarised (field GLSUMM="Y") and
creates Bought Forward records (GLDCT="BF") with the same total.
The second program P09911 prompts you to select the year to be dropped (1
year at a time) and deletes all records for that year (other than BF) from
the F0911, copying them to file F0911yy in your production library.
Here is the crunch! If you only summarise part of a year, due to the fact
that you specify a number of period to retain in detail, the DEMO version of
F09911 does not select only those records which have been summarised - it
selects everything for that year except the BF document type. Therefore,
your ledger will be out of balance - oops!
What we have done is:
(1) On the F09811 summarisation, we have added a date selection so that no
matter what number of periods we are to retain, only F0911 records prior to
the year we want to purge are summarised. We have reduced the number of
periods so that we can guarantee that full years will be processed.
(2) On the F09911 purge, we have added the Summarisation flag to the data
selection, so that only summarised records are purged.
We are still running tests - takes forever just to copy the F0911 let alone
to run the summarisation, but I think we have it licked now.
Hope this helps.
----------------------------------------------------------
Tony Payne - Senior Systems Analyst
Selmer-UMI Inc.
Elkhart, Indiana 46516
Work: (219) 522 1675 ext. 451
Email: [email protected]
(Running JDE A73 cum 10 on V4R3M0)
Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516
