Hello,
I would like to create a report in Odoo similar to an Excel format, where data is consolidated and grouped by Lot/Serial Number, Month, and Expiry Date. The report should include details such as quantity per carton, the total number of cartons shipped, and the total quantity. What is the best way to implement this in Odoo while using packages?”
| BATCH NUMBER | QUANTITY PER SHIPPER | TOTAL NUMBER OF SHIPPERS | TOTAL QUANTITY | |
| xyz | TAXVJ4004 | 100 | 7 | 700 |
| 25 | 1 | 25 | ||
| TAXVJ5001 | 100 | 20 | 2000 | |
| 24 | 1 | 24 | ||
| TAXVJ5002 | 100 | 15 | 1500 | |
| TOTAL | 44 | 4249 |
how to consolidate this kind of report in odoo using custom group
