# Calculate inventory rotation per day from sales

**URL:** https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072
**Category:** User
**Created:** [July 26, 2020, 10:52pm UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072 "2020-07-26T22:52:39Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![iehoshia](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/iehoshia/32/243_2.png) [@iehoshia](https://discuss.tryton.org/u/iehoshia)
#### Post date: [July 26, 2020, 10:52pm UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/1 "2020-07-26T22:52:39Z")

</div>

Hi,

I would like to know if tryton can give the total amount of sales and an inventory rotation per dates. Something llike these:

Start Date: 2020/07/01  
End Date: 2020/07/31

| Product | Quantity | Unit Price | Total |
| --- | --- | --- | --- |
| Product 1 | 3 | 1.50 | 4.50 |
| Product 2 | 4 | 2.00 | 8.00 |
| Product 3 | 5 | 3.00 | 15.00 |
| | | | |
| | | | 27.50 |

It is very useful to see which product sells the most.

Thanks in advance!

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [July 26, 2020, 11:10pm UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/2 "2020-07-26T23:10:46Z")

</div>

There is the [sale reporting per product](https://demo5.6.tryton.org/#demo5.6/model/sale.reporting.product;context=%7B%22context_model%22%3A%22sale.reporting.context%22%2C%22company%22%3A1%2C%22from_date%22%3A%7B%22 __class__ %22%3A%22date%22%2C%22year%22%3A2019%2C%22month%22%3A7%2C%22day%22%3A26%7D%2C%22period%22%3A%22month%22%2C%22to_date%22%3A%7B%22 __class__ %22%3A%22date%22%2C%22year%22%3A2020%2C%22month%22%3A7%2C%22day%22%3A26%7D%2C%22warehouse%22%3Anull%7D&context_model=sale.reporting.context&name=%22Sales%20per%20Product%22&views=%5B534%2C535%2C536%5D).

---

<div class="post-metadata">

### Author: ![iehoshia](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/iehoshia/32/243_2.png) [@iehoshia](https://discuss.tryton.org/u/iehoshia)
#### Post date: [July 27, 2020, 12:10am UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/3 "2020-07-27T00:10:47Z")

</div>

Thanks @ced,

Do I need to do some config to activate it?

I’m trying it in trytond 5.6 version but without success.

Thanks in advance!

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [July 27, 2020, 6:31am UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/4 "2020-07-27T06:31:08Z")

</div>

The user must be in the sale group and have pygal installed on the server to have the trend charts.

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [July 27, 2020, 6:50am UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/5 "2020-07-27T06:50:42Z")

</div>

You also need to set a exchange rate for the company currency with a date before the first sale, otherwise the report is empty

---

<div class="post-metadata">

### Author: ![iehoshia](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/iehoshia/32/243_2.png) [@iehoshia](https://discuss.tryton.org/u/iehoshia)
#### Post date: [July 27, 2020, 4:12pm UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/6 "2020-07-27T16:12:42Z")

</div>

> [@pokoli](#):
>
> before

Thanks, it works like a charm!

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [August 26, 2020, 4:12pm UTC](https://discuss.tryton.org/t/calculate-inventory-rotation-per-day-from-sales/3072/7 "2020-08-26T16:12:43Z")

</div>

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