After looking at AOR_report.php, i can see that curdate() is used to create the query to fetch the results for TODAY. The final query is not allowing for entries that are UTC timestamp in the DB into the next day.
ie… 06/28/2018 curdate() fetches records with that date. We create records in the -4UTC timezone until 21:00 HOURS which records entries at 06/29/2018 00:59
it appears that Suitecrm is not designed to display reports correctly when entering records later in the day .
Anyone know of a workaround or fix. This is driving me crazy not seeing the last two hours of records for the day on our reports. Not to mention seeing the prior days late records on the current days reports. it’s a simple TZ shift but seems impossible to fix.