# Custom report for items purchased by specific customer

**URL:** <https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158>\
**Category:** Uncategorized\
**Created:** [September 23, 2016, 8:41pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158 "2016-09-23T20:41:24Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shoayb\_Patel](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@Shoayb\_Patel](https://forum.manager.io/u/Shoayb_Patel)\
**Post date:** [September 23, 2016, 8:41pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/1 "2016-09-23T20:41:24Z")

</div>

Hi i am new to this software and in testing stages to see if it suitable for our business.  
We require a report to show all items purchased by a customer in the last 3 months, please can someone advise on how i could generate this report.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [September 23, 2016, 9:30pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/2 "2016-09-23T21:30:39Z")

</div>

This is not available at present. It would be supported by custom reports, but there is no documentation on the schema yet.

---

<div class="post-metadata">

**Author:** ![Shoayb\_Patel](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@Shoayb\_Patel](https://forum.manager.io/u/Shoayb_Patel)\
**Post date:** [September 24, 2016, 8:18am UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/3 "2016-09-24T08:18:45Z")

</div>

Thanks for the quick reply,  
is there any other way i can generate a similar report? to show items purchased by customer in a time period.

I really require a report of this type so our sales reps can have a better understanding of customer purchase trends.

please advise

---

<div class="post-metadata">

**Author:** ![Aart\_van\_Oploo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aart_van_oploo/32/19050_2.png) [@Aart\_van\_Oploo](https://forum.manager.io/u/Aart_van_Oploo)\
**Post date:** [September 24, 2016, 11:33am UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/4 "2016-09-24T11:33:55Z")

</div>

Did you have a look at the customer report? If you choose transactions at the type field, you can specify a start and end date.

---

<div class="post-metadata">

**Author:** ![Shoayb\_Patel](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@Shoayb\_Patel](https://forum.manager.io/u/Shoayb_Patel)\
**Post date:** [September 24, 2016, 11:50am UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/5 "2016-09-24T11:50:44Z")

</div>

Im totally new to this and can not find customer report

Please advise on how to to this @Aart_van_Oploo

---

<div class="post-metadata">

**Author:** ![Aart\_van\_Oploo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aart_van_oploo/32/19050_2.png) [@Aart\_van\_Oploo](https://forum.manager.io/u/Aart_van_Oploo)\
**Post date:** [September 24, 2016, 12:02pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/6 "2016-09-24T12:02:57Z")

</div>

On the main screen choose the “Reports” tab (left side of the screen).  
Then choose “supplier statement” and on the next screen choose transactions in the “statement type” field.

Hope this helps 🙂

---

<div class="post-metadata">

**Author:** ![Shoayb\_Patel](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@Shoayb\_Patel](https://forum.manager.io/u/Shoayb_Patel)\
**Post date:** [September 24, 2016, 12:09pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/7 "2016-09-24T12:09:41Z")

</div>

Ok i have tried this, i checked supplier statement and also customer statement.  
it shows the balances for a specific customer or supplier.

What i am looking for is a report to tell me what products a “customer A” has purchased in the last 2 weeks.

I hope you understand and can help.

---

<div class="post-metadata">

**Author:** ![Shoayb\_Patel](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@Shoayb\_Patel](https://forum.manager.io/u/Shoayb_Patel)\
**Post date:** [September 24, 2016, 12:10pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/8 "2016-09-24T12:10:22Z")

</div>

Ok i have tried this, i checked supplier statement and also customer statement.  
it shows the balances for a specific customer or supplier.

What i am looking for is a report to tell me what products a “customer A” has purchased in the last 2 weeks.

I hope you understand and can help. @Aart_van_Oploo @lubos

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [September 24, 2016, 1:36pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/9 "2016-09-24T13:36:09Z")

</div>

As I already told you, @Shoayb_Patel, the capability you seek is not available.

---

<div class="post-metadata">

**Author:** ![Roze\_Bunker](https://avatars.discourse-cdn.com/v4/letter/r/dbc845/32.png) [@Roze\_Bunker](https://forum.manager.io/u/Roze_Bunker)\
**Post date:** [January 4, 2018, 4:51pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/10 "2018-01-04T16:51:37Z")

</div>

Hi Tut,

Do you know if this option becomes available in the future?

Cheers,  
Kester

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [January 4, 2018, 4:55pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/11 "2018-01-04T16:55:56Z")

</div>

You are looking at a topic more than a year old. There is a new report, Sales Invoice Totals by Item. Run the report for the period of interest, click on the total for the item, then search the results for the customer of interest. Export the list, if desired.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:22pm UTC](https://forum.manager.io/t/custom-report-for-items-purchased-by-specific-customer/7158/12 "2023-01-18T15:22:44Z")

</div>


