I have only just started to set up reports and invoices for my suitecrm and there are problems I am unable to sort out.
I have loaded a number of closed/won opportunities then tried to run a report that simply lists them and totals their combined amounts.
There should be 39 results on the report, but the report only returns one result, and the total is incorrect for that one result. For the opportunity that did show on the report, the result should have been $3,650. On the report, it shows $38.
Checking the log, I have the following errors:
And in fact, in the reports module’s relationship section the only relationships are:
Also, in case this is a related issue, I am having a lot of issues with the invoicing section as well and will likely post on that later.
I am getting similar errors
05/21/15 19:34:50 [FATAL] error loading relationship aor_reports
05/21/15 19:34:51 [FATAL] aor_reports for aor_report_aor_conditions failed to load
It seems the report will work fine the first time I add the Parameter. However, if I edit the report or the parameter the report breaks. When entering back into the report for editing the report the module structure changes from
Accoutns : Cases : Timesheets
Accounts : Cases : Cases