It might help if you relate the core issues that caused your cardex to become
corrupt. What transactions were involved? Did the corruption involve
Advanced Warehousing? Are you in a manufacturing environment?
Are you running both the R41543 Item Ledger/Account Integrity Report and the
R41544 Item Balance/Ledger Integrity Report? What are the errors showing on
these two reports.
You mentioned As-Of processing, have you been running the Item Ledger As Of
Generation Program (R41542)?
Have you ever purged any records from your cardex?
Have all journal entry batches been posted on your system?
The Physical Inventory procedure is covered in the Inventory Management
Manual and is on the G4121 menu.
If you haven't read white paper ODS-01-0057, take a look at it. Look at the
example it gives of integrity problems caused in a standard cost environment
by people overriding the costs on transactions. Is there any chance that
this describes your situation?
I haven't thought this one through completely but another possible solution
for you would be to:
1. Complete a physical inventory
2. Create a file of your inventory items, locations, and on hand quantities
based on the physical inventory.
3. Wipe out your cardex and as-of files.
4. Use the previously created file to generate IB records for each item and
location in the cardex.
5. Run the various repost jobs for inventory commitments (I think these are
all of them)
R42295 Repost Active Sales Orders
R43990 Repost Open Purchase Orders
R3190 Repost Open Quantities
Another worst case alternative would be to create a new company and branch
plant in JDE, do inventory transfers to move all your inventory to it. This
would create a fresh set of cardex records in that company. Then export your
GL records and use the F0911Z1 to pull them into the new company and then
begin running your operation through the new company. That is the short
version, to actually do it would be much more complex, but it is an option.
Also try to have fun and view it as a learning experiance!
Patrick Conlon
XE SP4 Update 19, DB2, JAS, Terminal Serve