02 March 2009

Better price control

The basic setup of OpenERP has a very simple pricelist setup: manually set the list prices of the products and use them for the sales orders. Many companies use a cost price + margin% = list price formula. To work like this, we could easly modify the default public pricelist (sales pricelist) to be based on the cost price and add some percentage to that.
But this is usually not enough, for two reasons:
  • The prices calculated by the sales pricelist can only be seen when creating new sales order lines. Nothing updates the list price field on the products.
  • The sales prices change with every purchase because it changes the cost price they are based on. Many companies don't want to change prices every hour or so.
The solution: use the product_listprice_upgrade module in extra-addons. We need the original public pricelist that is based on the list price. Plus we have to create a new one of the type 'internal' and set it up to be based on the cost price + margin formula. The wizard in the listprice_upgrade module under the Pricelist menu will update the list price for the products we choose. This has to be run every time we decide to have new list prices.

p.s. There's a better module than product_listprice_upgrade, read this post.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.