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

kevin5 · ‎12-10-2018

QBARSolutions · ‎12-10-2018

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

QBARSolutions · ‎12-10-2018

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

QBARSolutions · ‎12-10-2018

Please mark this as helpful if you find it so.

kevin5 · ‎12-10-2018

Awesome. Thanks!!

Browse by Topic