Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Average cost updates automatically

By
Santiago EV
on 11/28/14, 12:50 PM 1,275 views

Isn't OpenERP supposed to automatically update cost based on new purchases?

0
Santiago EV
On 11/29/14, 10:46 AM

Ok, it is calculating average cost, I verified.  Its just that if I enter a PO and receive those products in:

Purchasing > Receive Products > Receive Products ... it doesnt update the unit cost.  It only updates the qty.

if I receive those new products via:

Warehouse > Products Moves > Receive Products ... it doesnt update the unit cost.  It only updates the qty.

It only works if I receive those products via:

Purchasing > Receive Products > Incoming Shipments

#1  Why is that?

As for the prices, I learned how to make a Sales Pricelist and configured the price rule as based on Cost Price for Price Computation and I made it 20% markup.  It seems to work because whenever a client to which that Pricelist is assigned, gets quoted for a product, the sales price shows up as 20% over cost.  Is this the right way to handle this?  

This is what I wanted but I have a usability question:

#2  This means I have to go and reset the sales pricelists for all the customers I have already set up?  Or should I update the PublicPricelist for this computation method?  And if I should update the PublicPricelist, will that change the invoices that I have already created in the past which didnt use that 20% markup over cost rule?

 

Thanks!

Is there a way to set Real Time Valuation and Average Cost method as defaults for any new products created?

Santiago EV
on 8/21/15, 3:26 PM
0

Bole

--Bole--
2385
| 5 4 6
Zagreb | Karlovac, Croatia
--Bole--

there is only 10 kind of people the ones that understand binary ... and others

Bole
On 11/29/14, 5:03 AM

It is, but you need to carefuly setup the process in order for it to happen.. 

On product:
1. Costing method : Average price,
2. Invenotry valuation : Realtime (automated
3. you need to define suppliers and suppliers prices,

Purchase pricelist:
base your purchase price calculation on Prices from supplier form

Configuration > Purchase
1. Use 'Real Price' or 'Average' costing methods.
2. Manage different pricelists

#not neccesary but also can make a difference
Enable landed cost calculation, because it also modifies purchase price -> avergae price

All this combined... and it will give you average price.. .

It works ok for one warehouse, and it is a great iomproovment compared to v7, but still faar from perfect inventory valuation,
Because you can't have different valuation for same product on different warehouses, ( average price may vary fro Wh to Wh dependinh on landed cost - transport between WH and WH locations.. ) 


Hope this helps.. 
 

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

4 follower(s)

Stats

Asked: 11/28/14, 12:50 PM
Seen: 1275 times
Last updated: 5/9/16, 4:16 PM