Skip to Content
Menu
This question has been flagged
3 Replies
7030 Views

Hi,

Hello, I would like to know how to consult the list of items not sold (not sale since 6 months or 1 year for example) on odoo 10..

thanks.

Avatar
Discard
Best Answer

Go to settings > Technical > Model > product.product.

Create new field of type date,  in name  type  x_stock_move_date, in  string  type  'Stock Move  Date ',  and  in related field, type below code.

stock_move_ids.create_date

save this filed. That's it. Now go to product list. in "Filters" Select 'Stock Move Date', in operator, select 'Is Before ', in date field select your desired date and press apply.

You will get products having move date later than that date.


Avatar
Discard

Attempting to save the model on v17 results in an error:

Validation Error
Unable to order by priority: fields used for ordering must be present on the model and stored.

Is this technique invalid on v17?

Best Answer

hello

I think in odoo doesn't has built-in feature. may be you have to create the report for it.

there is app available in odoo apps. you can see here that app: https://www.odoo.com/apps/modules/11.0/non_moving_product_ept/

Avatar
Discard
Best Answer

If you use odoo 10 C.E you must build your own report module with custom sql view

For reference build own report module maybe you can check "sale" modules on odoo10 base modules : https://github.com/odoo/odoo/tree/10.0/addons/sale/report

I have no idea if odoo 10 E.E has report thats like you want it

Avatar
Discard