cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

How can I add total sales or total amount invoiced to the customer list report in advanced reporting?

 
Solved
Best answer 12-10-2018

Accepted Solutions
Level 2

Hi, To find the total invoiced amount for each customer,...

Hi,

To find the total invoiced amount for each customer, you can add this expression to the Customer List report.

sum({<[Transactions.Txn Type]={'Invoice'}, [Transactions.Header Or Line]={'Header'}>}[Transactions.Amount With Sign]) 

View solution in original post

3 Comments
Level 2

Hi, To find the total invoiced amount for each customer,...

Hi,

To find the total invoiced amount for each customer, you can add this expression to the Customer List report.

sum({<[Transactions.Txn Type]={'Invoice'}, [Transactions.Header Or Line]={'Header'}>}[Transactions.Amount With Sign]) 

View solution in original post

Level 2

Please mark this as helpful if you find it so.

Please mark this as helpful if you find it so.
Level 1

Awesome.  Thanks!!

Awesome.  Thanks!!

Need to get in touch?

Contact us