Purging the Cardex (F4111) in Xe???

[JD_Edwards]

Does anyone have any advice on how to purge the cardex (F4111) in Xe? I found
information about a "canned" JDE program in World, but nothing in OneWorld. How
long do most people keep cardex records around? We've been live for over a year
with Financials and over 5 months with manufacturing and haven't purged anything
yet.

John Gaughan
The Pfaltzgraff Company
[email protected]

OneWorld XE, SP 17.1
HPUX 11, Oracle SE 8.1.6
Mfg, Financials

 

[david_mallory]

John,

To paraphrase a post about two months ago from one of the wizards:

1. Create an F554111 table, just like F4111 (cardex) except for the name.

2. Create a P554111 program, just like P4111 except it reads F554111. Put on
menu.

3. Copy old records into F554111.

4. Try reading the old records with P554111.

5. Delete old records from F4111.

Thus old records are easy to get at. No new interface, no new lookup
routine, no reformat.

Our experience with a JDE purge program was short and not fun, so I suggest
rolling your own.

Dave Mallory Denver Water OW 7.332 SP 15.1 Oracle 8.1722 NT 4.0

 

[DSauve]

John,

We've been live on OneWorld for a little over 2 years, and this January did our first Cardex archive/purge, leaving the previous full year's transactions intact.

I ended up writing a custom UBE that combined all Cardex transactions older than a specified date, generating a summary record for each combination of Branch Plant, Short Item Number, Location, and Lot Number. I added in logic for unit of measure conversions, so I could show the correct quantity and cost amounts in the summary record. In this way, all the active Cardex transactions, plus the summary records, should still total up to the quantity on hand in the F41021 table.

I wrote the purged records into a separate table, which I later moved into an MSAccess table for long-term storage. I didn't want to clutter up my production database with all those records, and wanted to make it fairly easy for end-users to access the purged Cardex transactions.

Hope this helps!

Don Sauve
Wagstaff, Inc.
OW XE, SP15.1, HP-UX 11.0, Oracle 8.1.6