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 <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]> > 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]> > >> >> 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]> >> >>> 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 >>> [email protected] >>> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >>> >> >> >> >> _______________________________________________ >> Dolibarr-dev mailing >> [email protected]https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> >> >> >> -- >> Responsable technique >> SARL altairiswww.altairis.fr >> 09 52 71 70 96 >> >> >> _______________________________________________ >> Dolibarr-dev mailing list >> [email protected] >> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> >> > > > _______________________________________________ > Dolibarr-dev mailing > [email protected]https://lists.nongnu.org/mailman/listinfo/dolibarr-dev > > > > -- > Responsable technique > SARL altairiswww.altairis.fr > 09 52 71 70 96 > > > _______________________________________________ > Dolibarr-dev mailing list > [email protected] > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev > >
_______________________________________________ Dolibarr-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
