Sorry I have kept you waiting.
As you already know [Cursom reports] is to be explored. Gathering information and share it is indeed the best way to go, is also my opinion.
Basic knowledge of SQL is nice to have. I don’t know where you stand so I just start with the basic commands.
A SQL command is for instance SELECT * FROM [name of database]
In Manager there are, as far as we know now, the following names of databases:
Wether Manager understands the standard SQL commands like [SELECT *] depends on the maker of the program, so Lubos.
Let’s take Salesinvoices as an example.
Open Custom reports and put in the next line:
select * from Salesinvoices
Did you get a warning?! Fine, because the databasename is not right. Should be SalesInvoices. Be aware of Capitals. So try:
select * from SalesInvoices
Now you will see all your invoices.
As you can see all the columns does have headers. For instance DueDate and CustomerName.
So you can try this:
select DueDate, CustomerName from SalesInvoices
select CustomerName, BalanceDue from SalesInvoices where BalanceDue > 0
Which commands work and which don’t is a matter of trial and error.
Another way to go is to export the database(s) to your favorite spreadsheet program and work from there.
I do have experience in this field with Excel and Libre Office, but I am not an expert.
Hope I did get you on the track. Enjoy exploring!