Re: [Dolibarr-dev] update supplier price

[Olivier Geffroy]

I have a form for that and a table

llx_ventilation_achat (fk_facture_fourn_det, qty, fk_facture)

Olivier Geffroy Consultant informatique Jeffinfo SARL 295 rue d'aire 59660 Merville Tel: 06 08 63 27 40 | Fax: 03 62 02 49 29 Le blog  Le site web

Want a signature like mine? CLICK HERE.  

2012/4/20 Christophe Battarel <address@hidden>

ok i understand
but when (and where) do you make the link betweek customer invoice and supplier invoice line ?


Le 20/04/2012 10:52, Olivier Geffroy a écrit :

This is working for my sales not my proposal 

each line in llx_facfourndet is link with a customer invoice 

like this i have my commercial margins 

* by invoice

* by customer

* by month and year

2012/4/20 Christophe Battarel <address@hidden>

thank you Olivier, i will look at your code in details...

taking the price in lls_facturefourndet is a idea but :
- there may be multiple supplier prices for one product (multple suppliers and multiple prices per supplier)... which one do you take ?
- there may be no supplier prices for one product
- there may also be free products (vs predefined products) on the order

that's why i put the "buying price" on line input in propale, order, invoice, displaying a combo-box when supplier prices exists or text field if no price defined or free product (i simplify hte actual functionnality for better understanding)

 

Le 20/04/2012 10:25, Olivier Geffroy a écrit :

Hi christophe 

i take the supplier price in llx_facturefourndet. 

I make a module for my commercial margins with regis, this is my source code 

Olivier Geffroy Consultant informatique Jeffinfo SARL 295 rue d'aire 59660 Merville Tel: 06 08 63 27 40 | Fax: 03 62 02 49 29 Le blog  Le site web

Want a signature like mine? CLICK HERE.  

2012/4/20 Christophe Battarel <address@hidden>

Hello,
I dont understand when you want to update a supplier price, you delete it then recreate it in the database.

I'm developing a module for commercial margins and i wanted to memorize the rowid of the supplier price in case it change between propale and order;
but if the rowid change when you update a supplier price, my code is useless.

So my question is : do you have a reason for delete and recreate the supplier price instead of update it ?

Regards,
Christophe

--
Responsable technique
SARL altairis
www.altairis.fr
09 52 71 70 96


_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev

_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev

-- 
Responsable technique
SARL altairis
www.altairis.fr
09 52 71 70 96 

_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev

_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev

-- 
Responsable technique
SARL altairis
www.altairis.fr
09 52 71 70 96 

_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev