How do I create a report of last month's sales?

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I’m using SuiteCRM Version 7.11.1, Sugar Version 6.5.25 (Build 344) and PHP 7.3.5

I have a report set up, but the report returns each row twice and I can’t tell why.


What am I doing wrong and how can I get an accurate report? Thanks!

2

Try removing one of the “display” checkboxes.

3

thanks for the tip. I gave it a try, but it looks like the display checkbox only controls whether or not the field is displayed in the report.

It doesn’t seem to have an effect on my duplicate rows problems.

Is my report running on quotes and invoices? Is there a way to check this?

Since all my invoices are generated from a quote, that would explain why each row is getting returned twice. Is there somewhere that I can set the report to only query invoices?

4

I don’t know, I never tried Reports for “Line Items”.

To test your theory, you can try adding a condition that depends on an Invoice field, so that it only fits invoices, but fails for Quotes.

Another approach is to make the entire Report based on the Invoices module and use just the Grand total for the Report - if this is enough for your requirements.