Missing CARDEX records - P4112

husni

Well Known Member
Hi List,
We have got a very serious problem with the Inventory Issues.
Some of the Issues transactions entered using P4112 program displays the document number and updates the item balance file, but does not create the item ledger records and GL ledger records.

Recently we change the processing option number 2 of the "Process" tab, "Account Number" to 1 (Account number required).

The problem of missing records was existing before as well though the balance file did not update incorrectly. As a practice, we were running a report daily to check the missing documents in F4111 file and re-enter them again.

We are using the original JDE program without any custom mods.

Husni
Oneworld Xe, Update 3, SP17
Win2000 / SQL 2000
 
We have something similar here, in that we get these out of balences. You said that check for missing doc's in the F4111 and reenter them. How do you reenter them, as the on hand has already been updated, by re-entering do you over/under-state your inventory?

I am curious, how you getit back in synch (the F4111 and the F41021)

Thanks,
AW
 
It seems like a major issue here. In this case, Item Ledger and Item Balance will always have Integrity. I believe the On hand is overstated/understated. It is acceptable to re-key in the P4112 again but you need to run SQL to update F41021.
 
Are you aware that you can turn on rollback functionality, to rollback records that did not commit to the F4111 correctly? There is a white paper that exists on the jde knowledge garden about it. You activate a UDC, and then you can rollback the F41021 file using the P42210 application.
 
We have had this issue also, but it has not happenned since we installed ESU 14340. We are also running an integrity report each day until we are sure. Our problem was happenning only on very large orders, and in the afternoon when our system traffic was very high. We were never able to capture any logs. Also FYI there is no rollback for Work Order Issues, P31113.
 
We re-enter the missing records and update the balances accordingly. I was not aware of the roll back option. We will try to activate and see. Also we will try to apply ESU 14340. Thanks for the responses.

Husni
 
We had the same problem not only in inventory adjustments but shipment confirmation and work order completion. We found two things. The first was a bad ODBC driver update that required a patch to fix. The other issue was a rogue document type set up in a transporation table that was getting validated everytime a user modified an order. The latter instance caused a commit fail error. We also an occasional transaction where the F4111 records are created along with the necessary journal entries, but no update to the F41021.
 
Back
Top