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
- 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
- Do I have to do any other updates?