I am using Odoo 16.

How do I create an inventory report with the following calculation?

/

=Delivery Note Issued quantity - Goods Returned quantity - Goods Invoiced quantity 

I would also like the report to show which Customer has been issued the pending Delivery Notes.

/

Here is an example:

Customer A, B, and C have been sent the following items:

1. Product 1 - 6 units
2. Product 2 - 10 units
3. Product 3 - 4 units

• Customer A: returns 2 units of Product 1, bills 10 units of Product 2 and 4 units of Product 3.
• Customer B: returns 6 units of Product 1, bills 5 units of Product 2, Returns 3 units of Product 3.
• Customer C bills 6 units of Product 1, returns 5 units of Product 2, and returns 4 units of Product 3.

The report would state as below in nested format:

Customer A ​     ​Product 1 ​    ​4 unit

Customer B ​ ​    ​Product 2 ​ ​   5 units

​ ​ ​ ​    Product 3 ​    ​1 units

Customer C ​     ​Product 2 ​ ​   5 units

​ ​ ​ ​

​

​ ​ ​