I have been playing a couple of days with Dolibarr, I love this software but I found a big usage issue for me… that I don’t find the way to create a Customer order to Supplier order.
I will try to explain a little bit more. I’m working on a company that does not have stock, just order what the client needs. That for me is a problem… Exist that way? I suppose that it could be a little bit complicated, because a Customer’s order, usually, has products from different suppliers and then should be generated as many Supplier orders as products from different suppliers on the Custumer’s order…
Try to code something/ write something in SQL
with fk_product_fournisseur which should be recorderd in the llx_commandes (llx_orders) table maybe ?
Because this foreign key is realted to the buying price of the product you set up in your customer order and so you should be able to retrieve the supplier by this key… for the moment this key is used to define margins… but one day, for supplier orders, certainly.
Sorry i don’t have dolibarr in english so if names of items or DBs are not correct, excuse me.
You define a “desired stock level” of “0”, when there is a customer order and your stock is too low, you know which products you should re-order… maybe ?
and so you should be able to retrieve the supplier by this key… for the moment this key is used to define margins… but one day, for supplier orders, certainly.
