Download and install the Inventory FSN Analysis module from the Odoo App Store.

Go to inventory app, under Reporting, you will find Inventory FSN Analysis.
Apps >> Inventory >> Reporting >> Inventory FSN Analysis

Once you click on that, you will see a form view.

You will see the default data already present. It takes the default duration as current month. The mandatory fields are the duration, warehouse, location and FSN classifications. You need to select the time period for which you want the records from the particular warehouse and location. You are also allowed to assign turnover ratios to FSN classification. The FSN classification field will help you separate the fast-moving, slow-moving and non-moving products. You can also use the product category and product fields to filter your records.

Form >> Duration >> Warehouse >> Location >> FSN Classification

If you have selected any product category or products it will only list out those products in the tree view. But if you haven't selected any of the two, it will list out all the products for the mentioned duration for that warehouse location. Click on the refresh button everytime you want the updated information.

Form >> Refresh

Not to miss out, you can see a zero movement boolean on the left. If you uncheck that it will only show products with movements.

You will see the list of products with their category, opening stock, closing stock, average stock, sale, turnover ratio and FSN classification for the mentioned duration of that particular warehouse location. Isn't that amazing?

You can also see the Total Opening Stock and Total Closing Stock at the top.

You can check out all movements for a particular product too. Click on any product in the tree view. A form view will pop up with product name, product category, FSN classification and product movements. Now, that's something you wouldn't have expected.

Form >> stock movement list >> click any product

The most availing feature is still remaining. You can even download this as Excel report. On clicking the save button, you would see button on the top i.e. Actions. Click the actions button and select Inventory FSN Analysis.

Form >> Save >> Actions >> Inventory FSN Analysis

An Excel report will be downloaded. It would look like this..... This is something you can't miss out. You can now easily analyze your stocks.

Now, you don't have to manually calculate the turnover ratios and classify them into FSN. Instead, you can use our app that does the same for you and saves you a lot of time. To enjoy more updates like this, stay tuned with us.