https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42678 Bug ID: 42678 Summary: accountline and account_offsets datetime mismatch. Initiative type: --- Sponsorship --- status: Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Point of Sale Assignee: koha-bugs@lists.koha-community.org Reporter: EugeneKohaUser@gmail.com QA Contact: martin.renvoize@openfifth.co.uk Created attachment 199500 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199500&action=edit Screen Shots of tables and Koha POS screens/summary When preforming Cashup some transactions are not being included. Upon further investigation it seems that the accountlines date time is incorrect, they are marked as a time in the future. The account_offsets have the correct datetime. So if a sale is completed at 12:02pm the accountlines transaction is marked is marked as 13:02. the account_offsets has the correct time of 12:02. We try to run the cashup at 1:00 but the transactions are marked as after and are not included. If we wait until later then we run cashup again to get the rest of the transactions. I am on version 25.11, but it happened on 24.11 and before that. I thought if I upgraded it would fix it, but it has not. I have had time issues with my Google Watch time and VOIP also, because of the time change. I checked the server time, workstation time and the MariaDB time. They are all correct. I suspect it has something to do with my location which is Mexico. Mexico City officially abolished Daylight Saving Time (DST) on October 30, 2022. Eugene St. Michael's Library Cuernavaca, Mexico -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.