The latest version (18.9.60) is greatly improving custom reports functionality. Most notably, it’s no longer required to write SQL. Instead of SQL, there is visual query builder. For example, to generate report which lists your customers with their email address and billing address, you’d set it up…

I thing that the “join” part, in @lubos idea, is completely carried out via general ledger transaction query which join every table of the software. Is my interpretation correct?

Well, maybe, but my example is not showing something like that, I think. I cannot show any data from customers in this example

@pandhm @Davide , joins in custom reports are automatic but General Ledger Transactions fields are not yet 100% populated. Currently, Customer field is filled only for general ledger transactions posting to Accounts Receivable. Similarly, InventoryItem field is only filled for general ledger transact…

I can’t believe it’s happening.

Business Name on report should be fixed. [image] Business Name on Reports If business name was provided under business details, then I agree Manager should use that on reports just like it is using it on all other documents. The latest version (18.5.82) is making it that…

I think that you should also give the possibility to export/inport the single custom report’s setup so that we can share them between different businesses and also between Manager’s users.

Suggestion. Can lubos made the listing multi level folder like for ease of managing and categorizing? I had this feeling I might create a lot of custom report. [custom%20report%203] Can We Have ‘Balance’ field? where it shows after applying debit or credit, it shows the general account balance fi…

Please consider adding Tracking Codes in reports generating

[image] AJD: Ability to bring in account balances Balances are the sum of transactions. They are already available via the Summary. Balances do not exist as variables. But if you group by account, you will get the total of transactions presented. Depending on other parameters you choose for t…

[18.9.60] Improved custom reports (added visual query builder)

Abu_Hasan September 20, 2018, 6:14am 20

Business Name on report should be fixed.

Topic		Replies	Views
New implementation of custom reports available	111	10259	November 16, 2020
Renamed "Advanced Search" to "Custom Reports" and making the feature look report-like	35	1725	February 26, 2024
Custom Reports	72	17088	May 17, 2018
[17.10.42] Added three new sales reports	32	8547	March 10, 2019
SQL schema for creating custom reports	61	11713	March 5, 2018

[18.9.60] Improved custom reports (added visual query builder)

Related topics