It took a while to get to this point but new custom reports are now in the latest version (24.2.23) You can now turn your data within any tab into a custom report. The first change is that Advanced Search button has been renamed to Custom Reports. [image] When you create New Custom Report, the f…

Many Thanks. This is a very important report for my business. I’m going to use this report for my purchasing forecast. Thank You for your hard work

Hi Lubos, Two Questions please. Why do I get negative QTY? [image]

@Aldo do not go to Custom Reports under Reports tab. Go to Sales Invoices, then click Sales Invoices - Lines button in bottom-right corner to get list of sales invoice lines across all sales invoices. Then click Custom Reports on that screen as per the first post in this topic.

[image] shahabb: Further Discount and Item Unit are not available. I dont know if its by design just wanted to point it out. On which screen? More columns can be added based on what’s required. [image] eko: The customs report generation for a tab is a great addition but should not go at …

[image] lubos: On which screen? More columns can be added based on what’s required. [41243423423] [12321353431] The Unit of Invenotry item and Discount could not be selected in the Custom report. So the Qty and Unit Price doesnt make up total amount of the line. Not that much of a big deal…

Thank You, Lubos. I have attached a part of my Custom Report. Some blank lines and negative qtys are showing up. Can you please Tell me why this is? [image]

[image] Aldo: I have attached a part of my Custom Report. Some blank lines and negative qtys are showing up. This Screenshot is from old custom reports not new ones. And for the negative qty and blank lines they might be related to inventory. So select general ledger account as one of the col…

Awesome work, @Lubos . I think this is one step ahead regarding system improvements. How ever, one thing I see is missing - as per my opinion - which is the Report Date under the Report name- because the printed report does not show which date it is for. I think this will necessitate that "from & to…

@lubos On Manager Windows server v24.2.23.1317 Fixed assets tab → Custom Reports Sort by Control account then time stamp works But if a Group by Control account is added only the control account groups are shown with no item data (equivalent to not Selecting any fields).

Thank You. I’ll try the suggestions.

Renamed "Advanced Search" to "Custom Reports" and making the feature look report-like

Uncategorized

Topic		Replies	Views
[18.9.60] Improved custom reports (added visual query builder) Uncategorized	90	6364	November 11, 2018
New implementation of custom reports available Uncategorized	111	10624	November 16, 2020
Advanced Queries Uncategorized	5	590	March 1, 2024
Improved "Advanced Search" function so the searches can be saved for quick access Uncategorized	20	1896	January 17, 2024
Several Classic Custom Fields reporting Uncategorized	6	396	February 24, 2024

Renamed "Advanced Search" to "Custom Reports" and making the feature look report-like

Related topics