Top > Billing Director > Report Manager > Aged A/R Report > Total shows all values equal to zero while on Details tab there are real data.
The empty Aged A/R Report and other reports are caused by NULL value returned by the mysql function CONVERT_TZ().
To resolve the issue, please populate again the timezone values from system to mysql tables with the following commands:
# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql # service mysqld restart
To verify the solution, please run
# hspc-sql > select CONVERT_TZ(now(), 'GMT', 'Europe/London');
It should return a not-NULL value.