What's the best way to analyze the history of price for every product we sell and buy?
Each year we adapt the purchase prices and selling prices of our products.
How do I get an overview of this without opening every invoices ou SO.
Thank you.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
What's the best way to analyze the history of price for every product we sell and buy?
Each year we adapt the purchase prices and selling prices of our products.
How do I get an overview of this without opening every invoices ou SO.
Thank you.
To analyze the history of prices for every product you sell and buy, you can use the reporting and analysis features in your accounting software, such as Odoo v16. Here are some steps you can follow:
Go to the accounting module and select the "Reporting" menu.
Under Reporting, select the "Sales" or "Purchases" menu depending on whether you want to analyze the selling prices or purchase prices.
Select the "Sales Analysis" or "Purchases Analysis" report, depending on what you want to analyze.
Choose the product(s) you want to analyze from the product filter.
Set the date range to cover the period you want to analyze.
Run the report and review the results.
The Sales or Purchases Analysis report will show you the history of prices for each product you sell or buy within the specified date range. You can see the selling or purchase price of each product, along with the date of the transaction, the quantity sold or purchased, and the total amount.
Additionally, you can use other reporting and analysis features in Odoo v16, such as the Pivot Table and Graph View, to get a more visual representation of the data. These features allow you to group and filter the data in different ways, so you can analyze it more effectively.
Overall, using the reporting and analysis features in your accounting software is the best way to analyze the history of prices for every product you sell and buy, without having to open every invoice or sales order individually.
But there's no Sales or Purchase Analysis on reporting menu? What do we need to enable to see this?
Hi,
One possible solution to analyze the history of prices for products that you sell and buy is to use a specialized software tool, such as the Odoo module called "Previous Sale/Purchase Product Rates".
This module enables a view to see all previous sale/purchase product rates of selected customer. It will help you to manage your orders according to these price history. You can see these option from sale/purchase form.
App Link
https://apps.odoo.com/apps/modules/16.0/sale_purchase_previous_product_cost/
Regards
use OCA modules
product pricelist revision
product supplierinfo revision
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrirePublications associées | Réponses | Vues | Activité | |
---|---|---|---|---|
|
1
févr. 25
|
385 | ||
|
1
nov. 24
|
692 | ||
|
1
mars 24
|
2509 | ||
|
1
juin 23
|
241 | ||
|
1
déc. 22
|
3014 |