Inventory At Date : how can i get both valuation and quantities ? - ODOO ver.11

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Inventory At Date : how can i get both valuation and quantities ? - ODOO ver.11

2 Replies

6509 Views

inventory history cost_price valuestock quantities

Louis Boivin

Hello,

I am working on a data visualization problem.

I'd like to be able to get both the valuations and the quantities of my inventory in order to show an historical of the valuation of my inventory .

I already know that in the inventory module I can obtain the quantities of each product at any given date, nevertheless there is no cost associated. Besides I found in the module "Inventory Valuation" that on clicking on a product name and then on "inventory valuation" on the product card, I could see all the product moves with the unit price and the value associate but not directly the cost of a product at a given time.

Is there any simple way that I could combine those two fonctionnalities to get the result I want ?

Thanks in advance,

Louis

sahdevsinh

Best Answer

Maybe help this:

Go to the Inventory module and select the product you want to check the cost for.
Click on the "Product Moves" button to see the list of all product moves related to that product.
Identify the last move for that product before the date you want to check the cost for.
Note the unit price of that move, which represents the cost of the product at that time.
Go to the Inventory Valuation module and select the same product.
Click on the "Inventory Valuation" button to see the list of all inventory valuations related to that product.
Find the inventory valuation corresponding to the date you want to check the cost for.
Note the total value of the inventory valuation, which represents the total cost of all the products in stock at that time.
Divide the total value by the quantity in stock to get the average cost per unit at that time.
Compare the average cost per unit with the unit price of the last move before that date to ensure they are consistent. If they are not, you may need to investigate further to identify any discrepancies or changes in cost.

Ahmed elghazaly

Hello there,Did you have any luck with this issue?

This question has been flagged