# Customers per item

**URL:** <https://forum.manager.io/t/customers-per-item/24347>\
**Category:** Uncategorized\
**Created:** [September 18, 2019, 7:36pm UTC](https://forum.manager.io/t/customers-per-item/24347 "2019-09-18T19:36:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![WimTim](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@WimTim](https://forum.manager.io/u/WimTim)\
**Post date:** [September 18, 2019, 7:36pm UTC](https://forum.manager.io/t/customers-per-item/24347/1 "2019-09-18T19:36:47Z")

</div>

Hi, I am new to manager. Trying to create report: ‘which customers bought a specific item’. It seems there is no standard report for it, so I created this report:

 ![50](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/1/e14e0c488fb33e832b40e2fd0ab45e1ea405dac3.png), but it doesn’t show up any results. I have created a customer who has bought that item. What am I doing wrong, or how should it be done? Many thanks in advance.

---

<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:** [September 19, 2019, 7:06am UTC](https://forum.manager.io/t/customers-per-item/24347/2 "2019-09-19T07:06:14Z")

</div>

Because these two pieces of information are stored in separate tables. It would be really nice if this query was able to join tables and views, I think it would be a great feature to have.

---

<div class="post-metadata">

**Author:** ![WimTim](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@WimTim](https://forum.manager.io/u/WimTim)\
**Post date:** [September 20, 2019, 10:22am UTC](https://forum.manager.io/t/customers-per-item/24347/3 "2019-09-20T10:22:14Z")

</div>

Thanks. So if I have sold a certain item and something is wrong with it, there is no way to find a list of customers who have bought this? Or if I had sold software and wanted to follow up sometime later with an update, there is no way to track those customers down in a list? Thanks.

---

<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 20, 2019, 11:45am UTC](https://forum.manager.io/t/customers-per-item/24347/4 "2019-09-20T11:45:18Z")

</div>

> [@WimTim](#):
>
> there is no way to track those customers down in a list?

Yes, there is. Generate a Sales Invoice Totals by Item report. Drill down on the total for the item in question. You will see a list of sales invoices where the item was sold. Sort the list by the Contact column, which in this case is the customer. You can then export the list, if required.

---

<div class="post-metadata">

**Author:** ![WimTim](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@WimTim](https://forum.manager.io/u/WimTim)\
**Post date:** [September 20, 2019, 12:20pm UTC](https://forum.manager.io/t/customers-per-item/24347/5 "2019-09-20T12:20:05Z")

</div>

Pretty cool, that works. Thanks!

---

<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, 2:59pm UTC](https://forum.manager.io/t/customers-per-item/24347/6 "2023-01-18T14:59:16Z")

</div>