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 <[email protected] <mailto:[email protected]>>


    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]  <mailto:[email protected]>
    https://lists.nongnu.org/mailman/listinfo/dolibarr-dev


-- 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 à