For example, the client wants to know how much revenue did he make with products from vendor A.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
Go to the Sales Module & then to Studio -> Edit menu :
Create a new Menu (“Revenue per supplier”) based on an Existing Model "sales order line" -> Confirm -> Confirm
Then, you can :
- Add a column to get the Supplier : Related field -> Product > Supplier
- Add a column to get the product : Existing field -> Product
- Go to the magnifying glass and add the field "supplier" that we have created (existing field) in the "group by" to be able to group by supplier
Warning: if you can't find the field you have created, you have to close and go to dashboard, debug, search for "Fields", find the one you have created and then select the "stored" and "indexed" properties.
Then we can go back to studio, and select it in the “group by”.
You will get the revenue per product per supplier :
Great forum entry!
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
3
Sep 24
|
2696 | ||
|
1
Aug 24
|
455 | ||
|
2
Feb 24
|
1879 | ||
How does Odoo send emails ?
Solved
|
|
2
Jan 24
|
16478 | |
|
1
Oct 23
|
4188 |