Se rendre au contenu
Menu
Cette question a été signalée
3 Réponses
3706 Vues

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.

Avatar
Ignorer
Meilleure réponse

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.


Avatar
Ignorer

But there's no Sales or Purchase Analysis on reporting menu? What do we need to enable to see this?

Meilleure réponse

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

Avatar
Ignorer
Meilleure réponse

use OCA modules

product pricelist revision

product supplierinfo revision


Avatar
Ignorer
Publications 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