Sale statistic - particular customer & product

Support User
1

Hello fellow Trytonies,
I feel a little stupid - but I could not find out how to create data for sales development of one specific product with one specific customer.

Actual: I have one product called “commission”, which I charge quarterly - and would like to see the development over time.
How can I do this?

Thanks a lot in advance, Wolf

2

I guess you could use Product Price List Dates Module — Tryton module to add dates on price list
Or you could just relate from Party → Sale Lines and see the Commission sale line prices from the past.

3

Thank you, dear Dimitrios.

Alright - this sounds like yet another Tryton with lots of research to do.

Thanks for overestimating my abilities again. (;
How would I do this? - At menu > party > sales I cannot search for sale lines, AFAIS…

I’d expect these things at menu > Sales > results, but there I can

  • neither find the number of items sold (which to me is a really severe flaw here),
  • nor can I search for parties if displayed “products” - nor vice versa.

Cheers,
Wolf

4

When you are on a party form, in the lower part of the form you will have an icon to open its sales lines.

Also you can access it using the relate button. See:

imatge

You can achieve the same from the product relate. You can open all the sale lines (of all customers) of the commission product. From there it will be also possible to filter just the sales of a specific product using the standard filter feature.

5

Wow, this is a gem. Thank you so much, grand master @pokoli .
But how sad, that (I guess) Tryton is full of gems - and not even a handful of people know about them.

Cheers,
Wolf

6

Wolf, make a test database and play with it, explore, click on every button there is and see what happens.
BTW, a real gem is the ability to relate from multiple records at the same time!
It took me more than 2 years of using Tryton to discover this, and it completely changed many of my work-flows.

9

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.