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 <http://www.jeffinfo.com> Le site web <http://www.zendsi.com>

Want a signature like mine? <http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> CLICK HERE. <http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21>


2012/4/20 Christophe Battarel <[email protected] <mailto:[email protected]>>

    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 <http://www.altairis.fr>
    09 52 71 70 96


    _______________________________________________
    Dolibarr-dev mailing list
    [email protected] <mailto:[email protected]>
    https://lists.nongnu.org/mailman/listinfo/dolibarr-dev




_______________________________________________
Dolibarr-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev


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

_______________________________________________
Dolibarr-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev

Répondre à