Distribution - JDE1 (MOSC)

MOSC Banner

SQL Update Item Ledger Transaction Date

We have records from an inventory transfer in the item ledger that were done several years ago. The transaction date was fat-fingered to 2029 but the G/L date was correct and the batch had posted correctly.

Because of the bad 2029 date the records show up at the top of the list in the Cardex screen. Wondering if there would be any bad ramifications to changing with SQL the transaction date to the same as the G/L date so they don't show up that way.

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