• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

A/R, A/P and G/L archive/purge

jdedave

Active Member
Hi,

We are planning to purge/archive A/R,A/P and G/L files
having three years older records. If you purged or
archived these tables can you please tell me the
procedures how you did and what are the important
things we must look for it. We are in B7332 SP11.3
Winnt. SQL 7.0. Thanks for your great help.

Thank you
David Soloman

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
 

Mike Dupaix

VIP Member
David,

As part of all purges, JDE purge programs create a new file based on the old file with an appendix of 'P' and a date (F0911PXXXX). You can save these purge files if you choose. The only file purge that has an additional step is F0911. There is a 'summarize' job that must be run. This creates one record per gl account, ledger and GL period that sums the monthly transactions. This record type (BF) should never be purged as it is used for GL reposts.

The GL manuals discuss this in depth (for JDE) and provide a check list. If their check list is followed, you should have no problem. I've used this many times with a problem both as a user and as consultant. More information is available through the Knowledge Garden by looking under publications.

> Hi,

We are planning to purge/archive A/R,A/P and G/L files
having three years older records. If you purged or
archived these tables can you please tell me the
procedures how you did and what are the important
things we must look for it. We are in B7332 SP11.3
Winnt. SQL 7.0. Thanks for your great help.

Thank you
David Soloman

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4582
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

<



Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 
Top