posted

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

Best Answers

Highlighted

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

Highlighted

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

Highlighted

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.

Highlighted

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

Awesome. Thanks!!

Featured

QuickBooks Online Year End Resources

We know you are busy, so we have collected all the articles and information...

QuickBooks Desktop Year End Resources

We know you are busy, so we have collected all the articles and information...

Intuit Online Payroll Year End Resources

We know you are busy, so we have collected all the articles and information...

Need to get in touch?