CARDEX (F4111) Purging

[tpayne]

The default version of the Cardex purge on P00PURGE selects only records
with "As Of Posted Date" = "Y".
All the records generated for Location Added and a number of other
transaction types do not have this flag set, therefore only a few records
are being dropped when we run a purge.
Does anyone know the significance of this field on the Cardex?
Thanks for your help.
----------------------------------------------------------
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 V4R5M0)




Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516

 

[John_Dickey]

Tony,
Yes, there is a another file on the system - the F41112. This is a
summarized version of the Cardex. There is a program (do not remember the
program number off the top of my head) that would read the F4111 records and
post those records to the summary monthly buckets (record is by fiscal year)
in the F41112, then set that As Of Posted Date flag on so will not process
the record again when the program runs. We run the program once a week, on
Saturdays. Sounds like you are not running this program. F41112 is used if
you take the command key 10 (I think) in Cardex inquiry to see summary
numbers. Certainly not used haavily like the F4111 is. Hope this helps
some.

John Dickey
White-Rodgers IT

 

[tpayne]

Thanks very much John,
The program is P41542. Looks like we have it suspended on Sleeper as from a
couple of years ago, so I am investigating the reason, but this is obviously
the missing link I was looking for.
Thanks for your help.




Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516

 

[ssolberg]

Re: RE: CARDEX (F4111) Purging

Wanted to bring this subject back up to see where you got with things. I'm wanting to purge the F4111 as well but we have never done any of the As Of processing. The process looks simple enough: Generate the As Of "through" a certain date, which flags the records in F4111 and puts a summarized entry in F41112, then use P00PURGE to purge the F4111 records through the same date. Yes?

My question is... what does the Cardex inquiry look like now (after you summarize and purge). Does the "as of" record(s) show up at the bottom of the Cardex view or can you only see what you summarized some other way. I'm worried about the guy who only sells part X once a year and looks up the part in the Cardex and only see transactions up to where I purged. (hope that made sense)

Programmer/Developer/Anything-They-Give-Me
World A7.3 c11

 

[John_Dickey]

RE: RE: CARDEX (F4111) Purging

That is a valid question. In the Cardex Inquiry, there is a command
key/function key (F10) that switches you from running balance to detail
ledger and back. The detail ledger will show you only the non-purged
records. The running balance is just a summary thing - won't show you
summary through the purge date, then the detail still remaining. What we
did is purged to a hold file after 18 months. The hold file stays another
18 months, with a separate menu option that points to the hold file - in
case anyone wants to see activity that far back. 18 months of detail seems
to work okay for us, but it could be a problem for others. So it is
something you have to worry about.

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

 

[ssolberg]

Re: RE: RE: CARDEX (F4111) Purging

One thing I did find is that there are quite a few tranaction records in this file that really aren't of much use. In particular, when you add a warehouse record, or a location record, or if you duplicate the part (via the batch process), you get a transactional record with 0 transaction qty, a document # of either 41026 (or 41021 or 41015) in the F4111. These records are essentially only an "audit" of the action that took place but have no impact on "history" (unless your company needs it?) and seems silly to "as of" these records just so you can delete them. I'm looking into purging just those records (earlier than 2000). Anyone concur?

Programmer/Developer/Anything-They-Give-Me
World A7.3 c11

 

[John_Dickey]

RE: RE: RE: CARDEX (F4111) Purging

Well, it is like most stuff - you do it at your own risk. I would say that
if you did a version that selected those records and include as criteria
that quantity = 0 and dollar amount = 0, then, sure, my reaction would be to
say go ahead and get rid of those suckers. I would archive them, just in
case.

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