07-16-2018, 10:14 AM
I see we have a lot of new functionality in repots, which is very cool. One use case I have for this is: When you report salesorders, a lot of times you want to know if a salesorder has been completely invoiced (if you invoice salesorders in multiple invoices of course). Would it be possible to sum the total amount of invoice subtotals related to that salesorder on-the-fly during the generation of the report and display it as a normal cell? Or would it be more wise to create a field in salesorders that aggregates the invoices through a workflow and just use that on the report?