posted

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

Best Answers

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

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

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

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

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

Please mark this as helpful if you find it so.

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

Awesome. Thanks!!

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

Sign In / Sign Up

Featured

Your guide to 1099s for 2020 taxes | QuickBooks Desktop

This pre-recorded webinarwill go over how to set up 1099s in your QuickBook...

Print your W-2 forms

Learn all about printing your W-2 forms with your payroll service. Making s...

Your guide to 1099s for 2020 taxes | QuickBooks Online

This pre-recorded webinarwill go over how to make sure your account is set ...

Need to get in touch?