Community mailing list archives

Re: "Computed Purchase Order" Modules

Alejandro Perez Cosio
- 09/12/2014 08:05:22
Hello Sylvain,

Few days ago I started with purchases in Odoo 8 but just as a user, I found that there are lots of leaks (obviously maybe just for my case, or even maybe I don't understand how works all the purchase process in Odoo) what I'm trying to do is:
- Buy several products from various suppliers.
- Add costs to the purchase for EXW Icoterms (where the product cost doesn't include transport, customs and others fees)
- Add others fees to the purchase after the purchase arrived. (Solved with analytic accounts)
- Get the total cost of the purchase (total = product cost + transport + customs + other landed fees). Solved it with analytic accounts and various purchases for each new fee.
- Compute the cost for each product in base of total spent. Here is where I'm stuck:
    -- Compute product cost in base of an analytic account is not possible (?)
    -- Set a custom portion of the extra cost to some product is not possible (E.g.: bought 3 products which come in the same container and I want to assign 20% of extra costs to the first product, 15% to the second and 65% to the third one)

I really would want to test your module because it could help me to understand "how" I should start with the programmatic part in Odoo for purchases.


On 12/09/14 07:24, Sylvain LE GAL wrote:
<blockquote cite="" type="cite">
Hi all,

In my company, we recently developped modules that realize something that we called "computed purchase order".

I would like to share this bunch of modules in OCA if possible.
- Are there some people interested by this feature ?
- In wich repository / repositories can I realize the PR ?
- I'm willing to change some part of my code to make my modules compatible with existing OCA modules;

Video demo: available here.

Purchaser decides to realize a new purchase order to a defined supplier.
->The module displays all the product linked to this supplier (with price);
-> It allows to compute what you have to buy. (quantity) depending of some parameters:
--> your stock; (1)
--> your average consumption of your product; (you have product you don't sell a lot and other you sell a lot);
--> An objective:
----> Objective of carriage; "franco de port" in french (not sure about the translation). IE: Some times the supplier only accepts to ship products if you buy 500 $ or 500kg of products)
----> Objective of number of days. (Some times, a supplier realizes a shippling each month only, so you have to be sure to have enought stock during the next 30 days); In this way, you can manage supplier hollidays;

After the compute of what the purchaser has to buy, the user can change manualy quantities, prices and convert to a "normal" purchase order.
If informations have changed, a wizard is available to update informations of all the products for that customer in one time (price / name and code of the supplier, etc.);

1/ The algorithm can be base on:
-> available stock; (=qty_available);
-> including "pending" stock; (=virtual_available);
-> including "draft" stock; new concept: (virtual_available + draft incoming qty - draft outgoing qty);
2/ Of course that module will not be usefull for all purchaser. It depend of how the purchaser realize the purchase order. But for my customers (little shop managers) it is very suitable.

3/ If somebody are interested to review that modules, please contact me.

Thanks & Regards.

Sylvain LE GAL
Service informatique
Groupement Régional Alimentaire de Proximité

3 Grande rue des feuillants 69001 Lyon
Bureau :
Astreinte :
Site Web :
Twitter :

Post to:

<html style="padding: 0px; margin: 0px;"><head><style>p { margin: 0; }</style><link rel="stylesheet" href="/zimbra/css/msgview.css?v=120410004736"></head><body class="MsgBody MsgBody-html" style="margin: 0px; height: auto;">

  <span style="font-family: arial, helvetica, sans-serif; font-size: 13px; background-color: rgb(255, 255, 255); font-weight: bold; color: rgb(153, 0, 0);">