Purging Item Ledger/Cardex

Hi List,

Does anyone out there know of any way to purge the Item Ledger (F4111) =
and what integrity issues need to be addressed before this can be done ? =


The reason we are looking at this issue is that we are expecting =
millions of records in the cardex each month and was wondering how to =
purge these records (after a certain number of years of course) and if =
we even had to worry about purging these records.

Anyone out there ever done this and if so how did you go about it ?

Thanks

Pete

SQL, XE, SP18

Pete,

There are purges that can be found ont he advanced and
technical explorer that deal with purging.
Essentially you create balance forward entries for
F4111 and then purge detail records (non BF document
types) for your date range. Your inventory management
manual describes the process in detail.
--- peterfourie <[email protected]> wrote:
http://www.jdelist.com/ubb/showflat.php?Cat=&Board=OW&Number=33627


__________________________________________________


World, OW B733X and Xe

Pete,

We wrote a custom UBE that archived F4111 records into a temporary table in Oracle, and created a "consolidating" entry in the F4111 table for each unique B/P, item #, location, lot# combination. This allows us to still go back and validate our on-hand quantity to all our cardex transactions. In our UBE, we had to code for unit of measure conversions, so watch out for that.

Also, once the purged records are in the temporary table, we pull them into an Access database for long-term storage. Then the temporary table is truncated for the next purge.

Our method is a bit labor-intensive, but we only run it once or twice a year, and it does clean up the Cardex.

Hi Pete

Which ever way you decide to purge your cardex, I'd recommend running a generation of the as-of file (R41542/R41548). This will give you a historic overview of usage/amount by period.

Once the as-of file is created and the cardex purged, NEVER run a full re-generation!! (By the way, the full re-generation Processing Option will NOT take data selection into consideration and will Re-gen the ENTIRE as-of file).

Also, the purging should take place based on G/L date and not transaction date.

Rgds,