Odoo Product Non Moving Stock

Click here to download the module


  • Generate Non Moving Stock Report in PDF and XLS Files, Reports can also be send through email.
  • You can view report using group by product category.

How To Use

Go to Inventory > Reporting > Non Moving Stock

Open Non Moving Stock Wizard Menu

Define Report Criteria.

Non Moving Stock Wizard

PDF file.

All Warehouse Report

XLS file.

All Warehouse XLS Report

Group By product category.

Group by Category
Group by Category

Select the groups from configuration to send the mail to users who belong to that groups.

Select Group for Email

You can send the email using send mail button.

To send Email attach with Report

WooCommerce My Purchase Analysis


  • This module help to know purchase analysis , product quantity with all orders with respective of price and total. simple as well as Variable products quantity analysis. Customer can also analyse products by particular year and categories.
  • Customer purchase analysis report in “My Account” section.
  • Report on all products in your orders and limit the report to only selected year.
  • Filter by years , products and category.
  • Report every single product in all orders with quantity.
  • Graph display payment method, category and product – quantity details in chart
  • Work with simple product and variable products.

My Purchase tab display purchase products with quantity.

My Purchase Screen

When click on product quantity that display selected product quantity and amount in different order.
Customer can view order information by clicking on “Order no”.

Product’s Order Details

Purchase analysis tab display year filter and display payment method , product and category details for selected year.
Also we can see graph by clicking “View Graphs”.

Purchase Analysis Screen

This pie chart display which different payment method customer used for pay order amount.

Payment Method Graph

Above chart represent category wise product count which customer was purchase.

Product Graph

This chart show products and their quantity which customer was purchase.

Product Quantity Graph

This is filter page for products.
Customer can select year and their category.

Product Filter Page
Product Filter Page

Purchase Analysis Graph View

Odoo stock purchase analysis

We have implemented a module “Dynamic Stock Purchase Analysis” which help users to take decision during purchasing products for company from suppliers.

It is displaying sold products (from POS and Sales Order) and current stock level based on selected date duration and product categories. And creating purchase order according to quantity enter by user for selected supplier.

Enhancement: OpenERP product quantities in different warehouses

Here we have done enhancement in our previous development that we made for product quantities in different warehouse.
Here is the link for Original Blog

Now, user can see only those warehouse which has quantity for particular product. There are 3 warehouses configured in database but only 2 warehouses have products available in stock.

OpenERP Product Warehouse
OpenERP Product Warehouse

During sales order creating process, we may want to decide that how many quantity can be sold from particular warehouse according to stock availability in our warehouses. So we have implemented easy solution for this. User can know available quantity as well as he can select warehouse also.

OpenERP Sales Order
OpenERP Sales Order

It’s not compulsory to assign warehouses for each line. In case of empty, it will consider default shop and user can continue his work smoothly.

OpenERP Sales Order
OpenERP Sales Order

User can perform same process for Purchase Order also which we can see in below screen.

OpenERP Purchase Order
OpenERP Purchase Order

OpenERP product quantities in different warehouses

In OpenERP, we already have a list of product quantities that is Quantity on Hand, Forcasted Quantity but it actual shows total quantity available in all our warehouse.

But let suppose if we have to check warehouse wise quantity then we have to check manually. And here we have implemented a module which helps us to get the warehouse wise product quantity.

Here is the list of the available warehouse in our database for example.

OpenERP Warehouse list
OpenERP Warehouse list

Below is the product form which shows total quantity available.

OpenERP Product List
OpenERP Product List

In following screen, we can see that we have added an image field at the last column and when we click on that, one popup will open and that will display all warehouse and quantity for that particular product.

OpenERP Product quantity
OpenERP Product quantity

The same thing is possible in Sales Order/Quotation, Purchase Order form also if we want to know the quantity during sales or purchase.

OpenERP product quantity in sales
OpenERP product quantity in sales
OpenERP product quantity in purchase
OpenERP product quantity in purchase

So here is the flow that how we can maintain and check product quantities during sales, purchase and overall.

How to configure product in OpenERP ?

While discussing about Sales or Purchase in a business, Product comes into picture always.

Product is playing major role in any type of business. In OpenERP, a product can be anything. It may be selling of product, purchasing of product or providing service to customers. You can easily configure product as per your requirements.

You will find three major fields available into product form as displayed in below screen.

It determine the system’s behaviour when a product is required. The system will generate different documents depending on the configuration of these three fields

Now let’s see in detail for above fields.

(1) Product Type

Stockable Product: You have to maintain stock of particular product. You can’t do any further operation until you have sufficient stock.

Consumable: When you are configuring this type to product, you don’t have to worry to maintain stock for your product.

Service: This type of product will configure at time when your company is providing any type of services to your customers.

(2) Procurement Method

Make to Stock: your customers are supplied from available stock. If the quantities in stock are too low to fulfil the order, a Purchase Order (according the minimum stock rules) will be generated in order to get the products required.

Make to Order: when a customer order is confirmed, you procure or manufacture the products for this order. A customer order ‘Make to Order’ will not modify stock in the medium term because you restock with the exact amount that was ordered.

(3) Supply Method

OpenERP supports two types of supply methods:

Produce: It will define when you will producing product with/without help of other products or services with help of your resources.

Buy: It will define when you are buying product from your suppliers.

Now see how above combination work with product and make it work for real time.

Consequences of Procurement Methods Make to Stock (MTS) and Make To Order (MTO)

Procurement Method    Produce                       Buy
MTS                             Wait for availability         Wait for availability
MTO                             Production Order            Purchase Order

Consequences of Procurement Methods when using Services

Procurement Method    Produce                       Buy
MTS                              –                                   –
MTO                             Create task                   Subcontract