Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm trying to create a list of cancelled quotes for my Sales Reps. This list should contain at minimum: Quote number, Customer, Total and what Products were quoted. I'll be using this list as a way to train Reps so Products quoted must be listed.
Using custom filters I can get all of this information via Quotations - except Products quoted.
I've tried Studio - but "Products" is not an Item I can add to the columns. How best can I get this list?
Navigate to Sales > Reporting menu to pivot view .. filter by status cancelled. Select Qty Ordered, unit price and totals as measures. Add the customer, order reference and product to the pilot columns. The report would have products as well as SO totals. You could further group by salesperson as well
You can then download the pivot table to a spreadsheet.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
Product Report
Solved
|
|
2
Feb 24
|
1300 | |
|
0
Nov 24
|
247 | ||
|
2
Jan 18
|
7663 | ||
|
1
Jan 20
|
3059 | ||
|
3
Feb 19
|
8178 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
