Skip to Content
This question has been flagged
inventorychangecost
2 Replies
2860 Views
Avatar
Community Question

I’ve configured my product category inventory valuation as Automated and set up the following accounts in the product category:

- Stock Valuation Account

- Input Account

- Output Account

- Expense Account (set as my Cost of Goods Sold (COGS) account based on my Chart of Accounts).

Here’s the issue I’m facing:

When I change the cost in the product master, the amount is reflecting in the Profit and Loss Report under the COGS account, but no sales have been made

this is entry happening when change cost

  • COGS Account (Credit)
  • Inventory Account (Debit)

Why does the system post this journal entry when the cost changes?


Avatar
Discard
Chris TRINGHAM

Hi @Ray - this is a good way of changing the cost in v18 for products with FIFO and Average Cost. But it can't be used for products with Standard Cost.

Avatar
Ray Carnes (ray)
Best Answer

When you increase the cost in the Product master, your inventory is now worth more so the Journal Entry is to reflect this change.

As we explain in the documentation at https://www.odoo.com/documentation/18.0/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/inventory_valuation_config.html#costing-method - "If the value in the Cost field on a product form is changed manually, Odoo generates a corresponding record in the Inventory Valuation report."

The account used is the Expense Account on the Product (or Product Category) - which is normally a Cost of Goods account.


A better way to manage changes in product cost is to change it for specific quants in Inventory via the Valuation Report in the Inventory App.


Select the Quant(s) you want to update and use Adjust Valuation from the Action Menu:


You will then have the ability to choose the counterpart account for the write-down / mark-up:

Avatar
Discard
Related Posts Replies Views Activity
How to track the change of the cost of a product in the Inventory module? Solved
inventory track cost
Avatar
Avatar
Avatar
2
May 24
10454
Average Cost Method ( Not Updating standard_price after PO completed )
inventory cost productcategory
Avatar
0
Mar 25
4591
goods received don't get reflected in inventory after receipt.
inventory cost purchases
Avatar
0
Mar 25
2871
Taxes not included in the product cost after creating a vendor bill Solved
accounting inventory taxes cost
Avatar
Avatar
Avatar
Avatar
3
Oct 25
1819
Linking non-billable material to a project Solved
project inventory analytic cost
Avatar
Avatar
1
Sep 25
1784