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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How to track the change of the cost of a product in the Inventory module?

inventory track cost

2 Vastaukset

10505 Näkymät

saharil sahari

I would like to track the change of cost of a product in the inventory module. For example, if someone changes the cost from 50 to 60, I would like it to appear in the chatter or somewhere that is easy to access. For example : "The cost has been changed from 50 to 60 on 4th December 2020". It would be nice if I could also make a graph from the changes based on months.

I have tried using audit trail, but it tracks the changes of all the fields. I am only interested in the change of the cost of product. Track_visibility only tells me that the cost has been changed, but it doesn't tell me from which value to which value. I would still like to know the previous value of cost even after updating the value. Is this possible?

Ray Carnes (ray)

Paras vastaus

You can do this with an Automated Action that is triggered On Update of either the Product model (if you are using Product Variants) or Product Template model (if you are not).

for record in records:
  currency_symbol = record.currency_id.symbol
  if record._context.get('old_values'):
    old_vals = record._context['old_values'].get(record.id, {})
    if 'standard_price' in old_vals:
      record.message_post(body="Cost changed from %s%.2f to %s%.2f." 
                          % (currency_symbol,
                             old_vals['standard_price'],
                             currency_symbol,
                             record.standard_price))

This will record cost price changes in the Chatter, like this:

Kévin Pouilliau

Hello does it work for standard_price in V13 ? I could achieve to do it for list_price, but not for standard_price.

Paresh Wagh

Track visibility shows both old and new values. Here's a sample.

Jonathan Wilson

Seems to work if cost is changed manually but not when receiving stock that affects the avg cost?

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
When changing the product cost, there is a Journal Entry posted to COGS, how can I change this? Ratkaistu inventory change cost	2 maalisk. 25	2924
Average Cost Method ( Not Updating standard_price after PO completed ) inventory cost productcategory	0 maalisk. 25	4591
goods received don't get reflected in inventory after receipt. inventory cost purchases	0 maalisk. 25	2871
Taxes not included in the product cost after creating a vendor bill Ratkaistu accounting inventory taxes cost	3 lokak. 25	1845
Linking non-billable material to a project Ratkaistu project inventory analytic cost	1 syysk. 25	1809

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!