cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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
Not applicable

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]) 

3 Comments
Not applicable

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]) 

Not applicable

Please mark this as helpful if you find it so.

Please mark this as helpful if you find it so.
Not applicable

Awesome.  Thanks!!

Awesome.  Thanks!!

Need to get in touch?

Contact us