G/L Summary and Purge

[ed111263]

[crazy] - Could someone help me with Summary and Purge of G/L Journal Entries? Our company does not use "BF" type records today. When I run a test of the process to Summarize the Journal Entries, I get a ton of "BF" type records in the F0911. If our F0911 and F0902 files do not balance with each other today, than why create "BF" records in F0911? Has anyone just copied the records to an archive file and then deleted them from F0911 in production? Would this have any adverse affect on the system? Please help! I have a IS department that loves to delete and a finance department that loves to save everything!!!!!

 

[John_Dickey]

Your F0902 and F0911 files should balance. If they don't you need to
understand why that is happening. The "BF" records are used to keep the
F0911 in balance with the F0902. What needs to happen is at some point when
you are allowed to take a fiscal year off the disk, you should purge both
the F0902 and the F0911 for that fiscal year. I would NOT purge F0911
records by themselves.

John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466

 

[ssolberg]

I know this topic has come up in the past so check the archives as well. I purge all the time... (multiple environments...) We have chosen NOT to summarize je's but my guess is that is where the BF's are coming from. I would NOT go down the process and just copying and deleting the records. Just not a good idea and bound to screw something up. The process to purge F0911 and F0902 is pretty straight forward and seems to do it's job well enough.

 

[Colin_Hugill]

Ed,

Check prior posts to the World forum especially in March this year and
December last year.

There has been a lot of discussion on this topic that is worth the time it
takes to read it. Also you really should read the JDE GL reference manuals
regarding purging, they actually do provide some good details.

Finally, once you run your purges make sure you execute reorgs (RGZPFM) over
the purged files.

Regards

Colin Hugill

----- Original Message -----
From: "ed111263" <[email protected]>
To: <[email protected]>
Sent: Thursday, November 14, 2002 6:39 AM
Subject: G/L Summary and Purge


Entries? Our company does not use "BF" type records today. When I run a test
of the process to Summarize the Journal Entries, I get a ton of "BF" type
records in the F0911. If our F0911 and F0902 files do not balance with each
other today, than why create "BF" records in F0911? Has anyone just copied
the records to an archive file and then deleted them from F0911 in
production? Would this have any adverse affect on the system? Please help! I
have a IS department that loves to delete and a finance department that
loves to save everything!!!!!



Colin Hugill
Consultant
(World A7.3 cum12)

 

[DShea]

My company has been working with JDE in Denver to create purge and archive
functionality for World. My company's product is called ARCTOOLS, and it's
a rules based purge and archive utility. Instead of writing RPG programs,
you create a set of rules somewhat like writing a query. Denver's goal is
to provide a standard set of rules, or scripts, that can then be fine-tuned
by clients as necessary.

We (Denver and DCSoftware) have developed rules for purging and archiving
AP, AR, GL and other files.

If you would like more information, please contact me at [email protected]
.

Thanks.

++++++++++++++++++++++++++++++++++++++++++++
Go... FASTER! Without an upgrade! With ARCTOOLS/400(tm)
http://www.arctools.com
[email protected]
DCSoftware, Inc.
Ph: (508) 435-8243
Fax: (508) 435-4498
++++++++++++++++++++++++++++++++++++++++++++

 

[Mike Dupaix]

BF records are net summarizations by account by
period. Their purpose is to leave audit informaton
for GL reposts of prior periods. You can certainly
risk purging F0911 records without creating them, but
be prepared... You stated that F0902 and F0911 are
not in balance. Is someone in your company running
and resolving GL integrity issues??
--- ed111263 <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=45049


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com



World, OW B733X and Xe

 

[ed111263]

Well it has been determined by my boss to just run a copy to an ARCDATA
library and then run a SQL delete in the production library!!! I told them
I did not agree with this, but what can you do. CAN'T FIGHT CITY HALL. I
wanted them to give me the OK to fix the out of balance problem with the
F0911 and F0902 first, then run the JDE process to summarize and purge
information, but I was told otherwise. Well looks like I will have job
security fixing problems the rest of my life!!! Thanks for your help.

Ed Hughes
Bonne Bell
(440) 808-2425




Mike_Dupaix <[email protected]>
Sent by: [email protected]
11/15/2002 03:08 PM
Please respond to jdeworld

To: [email protected]
cc:
Subject: Re: G/L Summary and Purge


BF records are net summarizations by account by
period. Their purpose is to leave audit informaton
for GL reposts of prior periods. You can certainly
risk purging F0911 records without creating them, but
be prepared... You stated that F0902 and F0911 are
not in balance. Is someone in your company running
and resolving GL integrity issues??
--- ed111263 <[email protected]> wrote:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=45049
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
World, OW B733X and Xe
--------------------------

 

[tidiehl]

Sue Brown is working on Purge/archive tools for WorldSoftware