Invoice date is incorrect
I'm trying to pull a report of Sales Orders and filter by Invoice Date. (ex: all of 2025) Unfortunately, the filter still returns lots of SO's from other years including 2026 which would be impossible to have an invoice in 2025 from a 2026 order. It's even returning ones that don't even have an invoice. There must be some issue with how the Invoice Date is synced perhaps? Not sure but need help. Even when adding Invoice Date to the Summary, Group By it seems to throw weird date with hundreds of lines per Sales Order, but goes away when I remove the Invoice Date field.