Hi everyone,

I am trying to setup openerp and have come across a problem. I realize this is a bit of a lecture, but I hope someone will go through the trouble and answer me.

I am assembling machines from parts that I buy from different suppliers/manufacturers. So one part, many suppliers. Each supplier has an individual price and delivery time. I have categorized the product types by means of production.

So I do the following:
1. import category list
2. import suppliers
3. import products, then import suppliers to product list (somehow I can't get it done in one import, I get a no "name" error. But I managed to bypass it by the second import, so that's not an issue). The cost each product is set to 0.
4. import pricelists for each supplier, where for each product a rule is created with cost (0) + product price of supplier
5. import BOM's

Now I have a few issues and I hope someone can help me out. I'm still in the testing phase, so I can change my method for importing data.

1. when making step 3. - it happens that I have a product 2 or more times on the import list. I'm adding a unique ID, so they don't appear more than once. But when I'm importing the supplier list for each product and a product appears 2 times on the import list, the supplier also appears 2 times in the product supplier specification. I use the supplier ID when importing.

2. When there are 2 suppliers for a product and an automatic procurement is issued, which one is being choosed? I've made some tests and when both have the same delivery time, the cheaper one is choosed. When they have a different delivery time, the one with the shorter delivery time is choosed. How can I influence this decision by setting rules or something? The only paramter which I found for this is "sequence" in the supplier tab of a product, which for now is the same for each supplier. What I need is a control window for each sales order how to proceed with the purchase orders. Choose supplier by price, by delivery time or override all rules and set preferred suppliers in order: supplier 1 or if not available, supplier 2 or if not available, supplier 3 etc. Is there any such thing?

3. After-production analyze

Another important thing would be analyzing the real cost of each manufacturing order. Let's say we have BOM 1 made of product 1, 2, 3 and BOM 2 made of product 2, 4, 5. When purchasing the products for the manufacturing order, I connect the purchase orders into one, for my convenience. After the production and sale is done. I'd like to see a report for each bom, which includes a summary of all costs (so the program needs to be able to divide the cost of product 2 for the 2 BOMs). Then it would be nice to review the history of BOM costs to compare the summarized costs. So that we can see a tendency that the manufacturing cost for this BOM are growing, while they are getting smaller for another BOM.

try importing your master data with Python scripts, that will give you more flexibility
hope this helps,

Thanks Morrillo, I'll try that.

But that still leaves points 2 and 3 open. Choosing the supplier for each sales order and post-production BOM-analyzing.

If I'm expecting too much from OpenERP, could someone just tell me so? I looked through the downloadable modules and through the forums but I couldn't find anything that would help me. Still I could have missed something, that's why I'm asking.

@delpen
Hi, for point 2 you can check
nan_mrp_procurement_cheapest_supplier

is for version 5 of Openerp, but perhaps works on version 6 also.

for point 3
https://code.launchpad.net/~openerp-rom ... tatech_mrp
check this module, but its need you to be a bit technical. it does make a lot of things so you can better follow your costs.

Keep us posted if you advance with your issues, I need that too.

Thanks

You could check the mrp_manufacturing_cost, that might help you tracking your production costs:

https://launchpad.net/avanzosc/manufacturing