Sorting using nl("Sum")

Hi there everybody.

I'm writing a product ranking report, showing the top 30 products based on sales quantity. The catch is I need to filter on a field that is only available in the Sales Invoice/Cr.Memo Header, and the report needs to be sorted from highest seller to lowest.

I was originally able to do this by using the Item table, filtering on Sales (Qty.) with a "-". This worked great, however did not allow me to filter on the invoice.crmemo header.

Any ideas how I might do this?


Please sign in to leave a comment.