To get a sum value of all the invoices in the Invoices Report:
- Make a new bookmark and paste this code in the URL field (ie. bookmark this code as a page):
javascript:javascript:$('[ng-repeat="result in vm.filterResults"]').each(function(){ var total = 0; $(this).find('.col_balance_due').each(function(){ total += parseInt($(this).text().replace(',','').replace('.00','')); }); $(this).find('h2').text($(this).find('h2').text()+' ($'+total+')'); });
-
Name it as you like (eg. AC-invoices-sum)
-
Go to Active Collab and run the Invoice Report