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.