User timezone not applied to report filters?
I've been having a strange problem when trying to pull POS sales summary daily reports. It seems that because our timezone is EST (UTC-4), all sales that are processed after 20:00 EST appear on the next day's sales report.
Let me explain. If we go to 'Reporting' -> 'Point of Sale' -> 'Sale Details' and choose the same start and end date (our accountant likes to pull daily reports), the generated report includes sales from the day selected, as well as all orders from the previous day that were placed after 20:00 EST. The actual date and time in the report is correct for our time zone, but the filter isn't correctly including all and only sales from the selected day. I believe that since all time is converted to UTC by OpenERP, the orders after 20:00 EST are recorded as in the next day's sales.
Is this a bug, is there a workaround?