Activate the App:
Navigate to the Apps module and install the "All In One Inventory Analysis" app.

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 also filter the records with the help of domains.

The most availing feature is still remaining. You can even download this as excel report. On clicking the save button, you would see buttons 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.

Go to inventory app, underreporting, you will find Inventory Stock Movements.
Apps >> Inventory >> Reporting >> Inventory Stock Movements

You will see the default data already present. It takes the default duration as current month. The mandatory fields are the duration, warehouse and location. You need to select the time period for which you want the records from the particular warehouse and location. You can also use the product category and product fields to filter your records.
Form >> Duration >> Warehouse >> Location

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.

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, stock in, stock out and closing stock for the mentioned duration of that particular warehouse location.
You can also see the Total Opening, Total In, Total Out and Total Closing at the top.
You can also filter the records with the help of domains. There are number of fields on which you can apply the rule and hence filter the records based on the applied rule.
You can also see the number of matched records.

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

You will see the default data already present. It takes the default duration as current month. The mandatory fields are the duration, warehouse and location. You need to select the time period for which you want the records from the particular warehouse and location. You can also use the product category and product fields to filter your records.

Form >> Duration >> Warehouse >> Location

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 and turnover ratio for the mentioned duration of that particular warehouse location.

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

You can also filter the records with the help of domains. There are number of fields on which you can apply the rule and hence filter the records based on the applied rule.

You can also see the number of matched records.

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 Turnover Analysis.

Form >> Save >> Actions >> Inventory Turnover 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. 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.