# Purchase reporting of aggregated data **URL:** \ **Category:** Feature\ **Tags:** purchasing\ **Created:** [October 26, 2020, 12:21pm UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397 "2020-10-26T12:21:11Z")\ **Posts on this page:** 10\ **Page:** 1
**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:** [October 26, 2020, 12:21pm UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/1 "2020-10-26T12:21:12Z")
## Rational It’s been a while since Tryton [has some aggreggated reporting of sales data](https://discuss.tryton.org/t/sale-reporting-of-aggregated-data/438) but we are missing the features to analize purchase data. ## Proposal Add a Reporting tab on purchases which include similar reports as currently available on sales action. This will include: - Purchases per supplier - Purchases per product - Purchases per category I do not think it makes sense to include the “Purchase per region” as purchases does not have any direct correlation with the region (but this may be the case on sales). ## Implementation [issue9831](https://bugs.tryton.org/issue9831) ---
**Author:** ![Alnus](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/alnus/32/1009_2.png) [@Alnus](https://discuss.tryton.org/u/Alnus)\ **Post date:** [October 26, 2020, 1:55pm UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/2 "2020-10-26T13:55:42Z")
I celebrate this new effort 😀 > [@pokoli](#): > > I do not think it makes sense to include the “Purchase per region” as purchases does not have any direct correlation with the region (but this may be the case on sales). The business logic is not the same as for sales, but this report would be useful for purchases, for example: It may be necessary for a company to know what its suppliers are and whether they are local, regional or otherwise, this type of information is common in management reports. I think it would be a necessary report. ---
**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:** [October 26, 2020, 2:00pm UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/3 "2020-10-26T14:00:43Z")
> [@Alnus](#): > > It may be necessary for a company to know what its suppliers are and whether they are local, regional or otherwise, this type of information is common in management reports. As you normally choose the suppliers you buy from you will be able to know if the supplier is local or regional from the purchases by supplier list. This is not the case on the customers as they choose you. If you prefer to have this information availalble on the list is just a mather of adding a functional field that depends on the supplier to compute it. Depending on the company you should consider as local supplier the ones from the same subdivision or from the same country. So this makes me think this should not be part of standard but something implemented as customization. ---
**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:** [October 26, 2020, 8:50pm UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/4 "2020-10-26T20:50:54Z")
> [@pokoli](#): > > Add a Reporting tab on purchases which include similar reports as currently available on sales action. What is the purpose? What kind of action a purchaser could take from such data? For me these are not the needed reports. Indeed I think the information a purchaser wants is to evaluate the effectiveness of the suppliers like: - the average delay (and standard deviation) between the planned date and the effective date of the shipment - the average delivery time per product, supplier and product-supplier - the frequency of back-order - the quality of the products received - the correctness of the order etc. > [@Alnus](#): > > It may be necessary for a company to know what its suppliers are and whether they are local, regional or otherwise, this type of information is common in management reports. Indeed it is probably good to have a picture of where the supply is. I think this can be done per region based on the amount. > [@pokoli](#): > > Purchases per supplier This is probably also good to have to negotiate discount with supplier. I think it will also be good to have under it the breakdown per category and finally per product. ---
**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:** [October 27, 2020, 7:47am UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/5 "2020-10-27T07:47:46Z")
> [@ced](#): > > - the average delay (and standard deviation) between the planned date and the effective date of the shipment > - the average delivery time per product, supplier and product-supplier > - the frequency of back-order I think this reports are also interesting for customer shipments. So I’m wondering if it won’t make more sense to include them on the stock module. > [@ced](#): > > - the quality of the products received > - the correctness of the order We are still missing some modules to track the quality/correctness of the products. > [@ced](#): > > What is the purpose? What kind of action a purchaser could take from such data? Main reason is to negotiate prices with the supplier. But also it is interesting to search for amount and quantities of a specific product/category to be able to search for new supplier that can provide a better price or supply time for them. ---
**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:** [October 27, 2020, 8:10am UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/6 "2020-10-27T08:10:15Z")
> [@pokoli](#): > > I think this reports are also interesting for customer shipments. So I’m wondering if it won’t make more sense to include them on the stock module. The information is mainly on the purchase (you can not do it with only stock module). > [@pokoli](#): > > But also it is interesting to search for amount and quantities of a specific product/category to be able to search for new supplier that can provide a better price or supply time for them. Reporting the quantity can only be done efficiently with stock moves. And just like for the margin reports, I think it better suit in the product menu. So for me on the purchase module you can only have the number of order and the amount. Which makes reporting per product and category not very useful as you are mixing different supplier prices (and they sound like a poor margin report). ---
**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:** [October 27, 2020, 8:25am UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/7 "2020-10-27T08:25:49Z")
> [@ced](#): > > Reporting the quantity can only be done efficiently with stock moves. And just like for the margin reports, I think it better suit in the product menu. So you are proposing to add a quantity reporting to know which quantities of each product has been delivered/received? I think this should be interesting but I do not know how to structure it. > [@ced](#): > > reporting per product and category not very useful as you are mixing different supplier prices I think it is interesting to see such information not mixed by supplier. I mean if I know that I purchased XXXX€ to a supplier I should be able to know the amounts for each product. So I think we should add a tree\_open action that opends the detail per timeseries but also another that opens the detail per product/category. This is one of the requested features from our users. They mainly work with a single supplier for each product, so they want to know the details of purchases per product. ---
**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:** [October 27, 2020, 8:59am UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/8 "2020-10-27T08:59:21Z")
> [@pokoli](#): > > So you are proposing to add a quantity reporting to know which quantities of each product has been delivered/received? I think this should be interesting but I do not know how to structure it. I think it should be quite similar to the margin report but focused only on the quantity (and maybe the cost price) and using the supplier location. > [@pokoli](#): > > I think it is interesting to see such information not mixed by supplier. I mean if I know that I purchased XXXX€ to a supplier I should be able to know the amounts for each product. So I think we should add a tree\_open action that opends the detail per timeseries but also another that opens the detail per product/category. 👌 ---
**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:** [November 13, 2020, 3:47pm UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/9 "2020-11-13T15:47:00Z")
If filled [Aggregated reporting for purchase data (#9831) · Issues · Tryton / Tryton · GitLab](https://bugs.tryton.org/issue9831) which implements the discussed functionalities. ---
**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:** [October 24, 2022, 6:00am UTC](https://discuss.tryton.org/t/purchase-reporting-of-aggregated-data/3397/10 "2022-10-24T06:00:11Z")
This topic was automatically closed after 12 days. New replies are no longer allowed.