Help

0

How do I see all products in Invoice Lines? I only see Product Variants.

Odoo 16.0+e (Enterprise Edition)

When creating an Invoice and I go to select line items, the Product field only shows Product Variants (of which I have like 200) instead of Products (of which I have 6000).

Why is that and how can I see/select all of my products when creating an Invoice?

Avatar
Discard
2 Answers
0
Avatar
Alan Scott
Best Answer

In Odoo, the product field in the invoice line items is designed to display product variants by default. The reason behind this is that each variant represents a unique combination of attributes (such as color, size, etc.), which may have different prices and stock levels. This allows for more accurate invoicing and inventory management.

However, if you’d like to see all of your products when creating an invoice, you can follow these steps:

  1. Enable Product Templates: Go to Inventory > Configuration > Settings. Under the “Products” section, enable the option “Product Variants.” Save your changes.

  2. Update Product Templates: Go to the Products menu in either the Inventory or Sales apps, click on each product template, and make sure you’ve created at least one variant for it.

  3. Select Products in Invoice Line Items: Now when you create an invoice and add line items, you should be able to select from all of your products (including templates with multiple variants). Just start typing the name of a product or browse through the list.

Please note that enabling product templates will affect other areas of Odoo as well (e.g., sales orders, and purchase orders), so make sure this change aligns with your business requirements.

I hope this helps! Let me know if you have any further questions or need additional guidance.


Avatar
Discard
0
Avatar
Niyas Raphy
Best Answer

Hi,

Can you see if there is some sort of domain applied for your product field ? may be from a custom module.

Also by default odoo will show all products in the invoice line, you can get the total product count in the database from products menu and then click on search more from the products m20 field in invoice lines and see whether the same number of products is shown there. In the opened view, you will see total count like 1-80/6000


EDIT:

Each product will have a record in product variant model, so i hope everything is good and you miss this peace of information.

For eg: create a product without variants, you will see the created product in variant table also.


Thanks

Avatar
Discard