Costing method: Last Purchase Price

by
Odoo 6
v 15.0 Third Party 1557
Download for v 15.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Purchase (purchase)
• Discuss (mail)
• Invoicing (account)
Lines of code 197
Technical Name stock_last_purchase_price
LicenseAGPL-3
Websitehttps://www.openhrms.com
Versions 17.0 16.0 13.0 15.0 14.0 12.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Purchase (purchase)
• Discuss (mail)
• Invoicing (account)
Lines of code 197
Technical Name stock_last_purchase_price
LicenseAGPL-3
Websitehttps://www.openhrms.com
Versions 17.0 16.0 13.0 15.0 14.0 12.0
Community
Enterprise

Costing method: Last Purchase Price

Introducing new costing method 'Last Purchase Price' in Odoo

Explore this module

Overview

Learn more about this module

Features

View features of this module

Screenshots

See key screenshots of this module

Overview

This module allows you to update your product's cost as your last purchase price and changes the stock valuation based on that

Configuration

After installing the module, Select the newly added costing method in product category. Provide 'Price Difference Account' too if you are following automated inventory valuation.

Features

New Costing Method

A New Costing Method Is Added To The List And Can Be Chosen From Product Category Form

Last Purchase Price

Cost Price Of Products Will Be Updated With Their Last Purchase Price

Stock Valuation Report

Takes Last Purchase Price In Stock Valuation Report

Price Difference Account

Automatically Posting Price Difference Related Accounting Entries To The 'Price Difference Account' When We Use Automated Inventory Valuation

Screenshots

Product form

Product category

Purchase order created with new cost

Cost updated in product form

Journal Item generated by the price change

Suggested Products

Our Services

Odoo Customization
Odoo Implementation
Odoo Support
Hire Odoo Developer
Odoo Integration
Odoo Migration
Odoo Consultancy
Odoo Implementation
Odoo Licensing Consultancy

Our Industries

Trading

Easily procure and sell your products

POS

Easy configuration and convivial experience

Education

A platform for educational management

Manufacturing

Plan, track and schedule your operations

E-commerce & Website

Mobile friendly, awe-inspiring product pages

Service Management

Keep track of services and invoice

Restaurant

Run your bar or restaurant methodically

Hotel Management

An all-inclusive hotel management application

Need Help?

odoo@cybrosys.com
WhatsApp

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Ok, but...
by
fernando.milesi.8@gmail.com
on 7/18/23, 9:20 AM

You should be carefull with de stock valuation. This module updates stock valuation in the account journal, but not in the stock valuation layer. This cause, for example, stock valuation decreases to negative if we buy with increasing costs. On the other hand, IMHO the price difference account is not for this purpose.
I make some changes, i'm using it, useful mainly in inflationary contexts. So thanks.

Re: Ok, but...
by
Cybrosys Technologies
on 7/20/23, 12:53 AM Author

Yes, Fernando.
This is not a good practice anyway. Still, some users need this. 

Only works on Automated Inventory Valuation.
by
Bilal Shehab
on 5/30/22, 12:24 PM

Tried the add-on it's useful, but unfortunately it only works on Automated Inventory Valuation.

While on Manual Inventory Valuation it gives this error:

  File "/opt/odoo15/odoo-custom-addons/stock_last_purchase_price/models/stock.py", line 44, in product_price_update_before_done
    move.product_id.with_context(force_company=move.company_id.id).sudo().write({'standard_price': new_std_price})
UnboundLocalError: local variable 'new_std_price' referenced before assignment

Please advise. Thank you