Reports module is not working correctly

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

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.

Any thoughts/input? Much appreciated -

2

Which version are you running?

AOR in 7.1.x has basic functionality and some bugs with currencies which have been fixed in the 7.2 release.

Thanks,

Will.

3

I assume 7.1 as it would be the latest full release. Should I assume this is on the developer’s side or could there be a wonky permission issue somewhere??

4

I’m using 7.2 and getting similar errors

Mon Apr 6 19:20:21 2015 [8589][1][ERROR] Unable to find relationship aor_report_aor_conditions
Mon Apr 6 19:20:21 2015 [8589][1][FATAL] aor_reports for aor_report_aor_conditions failed to load

thoughts?

5

I have similar errors in the log as well

Tue Apr 7 14:45:27 2015 [5528][1][ERROR] Unable to find relationship aor_report_aor_fields
Tue Apr 7 14:45:27 2015 [5528][1][FATAL] aor_reports for aor_report_aor_fields failed to load

Tue Apr 7 14:45:27 2015 [5528][1][ERROR] Unable to find relationship aor_report_aor_conditions
Tue Apr 7 14:45:27 2015 [5528][1][FATAL] aor_reports for aor_report_aor_conditions failed to load

as well as

Tue Apr 7 14:46:37 2015 [7721][1][ERROR] SugarBean.load_relationships, Null relationship name passed.

However, it looks like the results returned by the report are correct.

Running 7.2.1

6

I am getting similar errors
05/21/15 19:34:50 [54588][1][FATAL] error loading relationship aor_reports
05/21/15 19:34:51 [54588][1][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
To
Accounts : Cases : Cases