Distribution - JDE1 (MOSC)

MOSC Banner

How to Clear old S Records

HI

R41544, R41543, and R41760

E1 9.2 Finance Inventory reconciliation

There are some old records with S in the IPCD and are creating errors in the ledger total. the Item balance has been corrected through F41112a but they continue to show in the integrities. Is the following an acceptable way to clear them


  1. SQL where F4111.IPCD = S and F4111.ICU = Blank and F411,DGJ = Blank Set the fields to IPCD = Y and ICU = 100 (Unused Batch Number and DGJ = 1/1/2003 or does DGJ have to be a different date. Is that enough to have the report pick up the record
  2. Do I have to do any other updates?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center