Hi all: But... does it make sense to group by month all those results? I mean, if I'm filtering the report from january to april, I may want the total invoiced to that client/supplier, not use the calculator to know the total amount, right?
What do you think? Regards, *Marcos García* marcos...@gmail.com 2014-05-07 20:08 GMT+02:00 Doursenaud, Raphaël <rdoursen...@gpcsolutions.fr> : > Everything is grouped by dm in this file except the customer invoices and > social contributions (which appear twice in develop BTW). > Looks like a developer mistake to me. > @marcos Go ahead and add it, it won't hurt anyone . > > > 2014-05-07 19:35 GMT+02:00 Destailleur Laurent <e...@destailleur.fr>: > > Not yet, is there an opend bug for that in doliforge ? >> >> >> 2014-05-06 22:08 GMT+02:00 Marcos García <marcos...@gmail.com>: >> >> Hi Laurent, >>> >>> Did you came to a conclusion on this? >>> >>> Regards, >>> >>> >>> *Marcos García* >>> >>> marcos...@gmail.com >>> >>> >>> >>> 2014-05-02 20:35 GMT+02:00 Marcos García <marcos...@gmail.com>: >>> >>> Sure, it is >>>> http://dev.dolibarr.org/compta/resultat/clientfourn.php?leftmenu=ca >>>> >>>> Regards, >>>> >>>> >>>> *Marcos García* >>>> >>>> marcos...@gmail.com >>>> >>>> >>>> >>>> 2014-05-02 20:34 GMT+02:00 Destailleur Laurent <e...@destailleur.fr>: >>>> >>>> Can you point me which page (url) your are speaking about ? >>>>> >>>>> >>>>> 2014-05-02 19:41 GMT+02:00 Marcos García <marcos...@gmail.com>: >>>>> >>>>>> Hi all: >>>>>> >>>>>> An user complained in dolibarr.es forum about the results report by >>>>>> company in Dolibarr 3.5.2 because the supplier invoices are grouped by >>>>>> month and the customers invoices are not. He thought it was a bug but I >>>>>> am >>>>>> not really sure what should be the appropiate behaviour. >>>>>> >>>>>> The query of the supplier invoices groups by month ", >>>>>> date_format(f.datef,'%Y-%m') as dm, [...] GROUP BY s.nom, s.rowid, dm" >>>>>> and >>>>>> the customer invoices not "GROUP BY s.nom, s.rowid" >>>>>> >>>>>> What is the correct behaviour? >>>>>> >>>>>> Thanks. >>>>>> >>>>>> Regards, >>>>>> >>>>>> >>>>>> *Marcos García* >>>>>> >>>>>> marcos...@gmail.com >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Dolibarr-dev mailing list >>>>>> Dolibarr-dev@nongnu.org >>>>>> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Laurent Destailleur (alias Eldy) >>>>> >>>>> ------------------------------------------------------------------------------------ >>>>> Social networks of my OpenSource projects: >>>>> Dolibarr Google+: https://plus.google.com/+DolibarrOrg/ >>>>> Dolibarr Facebook: https://www.facebook.com/dolibarr >>>>> Dolibarr Twitter: http://www.twitter.com/dolibarr >>>>> AWStats Google+: https://plus.google.com/+AWStatsOrgPoject/ >>>>> AWStats Facebook: https://www.facebook.com/awstats.org >>>>> AWStats Twitter: http://www.twitter.com/awstats_project >>>>> >>>>> >>>>> _______________________________________________ >>>>> Dolibarr-dev mailing list >>>>> Dolibarr-dev@nongnu.org >>>>> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Dolibarr-dev mailing list >>> Dolibarr-dev@nongnu.org >>> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >>> >>> >> >> >> -- >> Laurent Destailleur (alias Eldy) >> >> ------------------------------------------------------------------------------------ >> Social networks of my OpenSource projects: >> Dolibarr Google+: https://plus.google.com/+DolibarrOrg/ >> Dolibarr Facebook: https://www.facebook.com/dolibarr >> Dolibarr Twitter: http://www.twitter.com/dolibarr >> AWStats Google+: https://plus.google.com/+AWStatsOrgPoject/ >> AWStats Facebook: https://www.facebook.com/awstats.org >> AWStats Twitter: http://www.twitter.com/awstats_project >> >> >> _______________________________________________ >> Dolibarr-dev mailing list >> Dolibarr-dev@nongnu.org >> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> >> > > > -- > *Raphaël Doursenaud* > Directeur technique (CTO) > Expert certifié en déploiement Google > Apps<https://gpcsolutions.fr/raphael-doursenaud-google-apps-certified-deployment-specialist> > +33 (0)5 35 53 97 13 - +33 (0)6 68 48 20 10 > > <http://gpcsolutions.fr> > http://gpcsolutions.fr > Technopole Hélioparc > 2 avenue du Président Pierre Angot > 64053 PAU CEDEX 9 > SARL GPC.solutions au capital de 7 500 € - R.C.S. PAU 528 995 921 > <https://www.google.com/a/partnersearch/#partner?partner_id=46687933_a0n60000000sqpWAAQ><http://wiki.dolibarr.org/index.php/Dolibarr_suppliers_France#GPC.solutions> > > _______________________________________________ > Dolibarr-dev mailing list > Dolibarr-dev@nongnu.org > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev > >
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev