On 30 Mar 05:35, Ossi Viljakainen wrote: > > I am trying to figure out how to get following reports: > > 1) Sales of particular product, or group of products daily / weekly / > montlhly / yearly > 2) Sales of particluar product categories daily / weekly / montlhly / yearly > 3) Sales per customer daily / weekly / montlhly / yearly > 4) Sales to particular customer divided per product or category, daily / > weekly / montlhly / yearly > 5) Total sales daily / weekly / montlhly / yearly > > Tryton reporting features are quite undocumented and reports in tryton are > difficult to find. We need improvement there. > Maybe I'm stupid and can't find the data, or it is actually not easily > available, or maybe I'm stupid in the brain.. > > > In any case, I found some documentation on this [1-3] > > [1] Reports — Documentation 1.4 > http://doc.tryton.org/1.4/trytond/doc/reports.html > > [2] Basic Configuration — Tryton Administration Manual 2.0 documentation > http://tryton-administration-manual.readthedocs.org/en/latest/basic_config.html > > [3] There is also something in the spanish tryton manual - one can google > translate to english: > http://doc.tryton-erp.es/trytond_doc/tryton_informes.html > > But still, this does not really give me the answer that I'm looking for.
Because what is named as Report in Tryton is the generation of ready to print document. Here what you are looking for are dynamric reports. We have some of them in account, sale_opportunity and timesheet modules. The basic idea is to create ModelSQL based on a sql queries [2]. > Are there ready-made modules that would add more reports? There are no such module in the standard but of course such module will be welcomed once we have a short list of useful, generic. But the biggest difficulty is to have such report to scale correctly so often we (B2CK) find that it requires pre-computing. That's why we started to write hebi [1] but I'm not yet personnaly satisfied of the result. [1] https://codereview.appspot.com/9943044/ [2] http://doc.tryton.org/3.4/trytond/doc/ref/models/models.html?highlight=table#trytond.model.ModelSQL.table_query -- Cédric Krier - B2CK SPRL Email/Jabber: [email protected] Tel: +32 472 54 46 59 Website: http://www.b2ck.com/
