# Custom report help

**URL:** <https://forum.manager.io/t/custom-report-help/36224>\
**Category:** Uncategorized\
**Created:** [July 23, 2021, 7:32am UTC](https://forum.manager.io/t/custom-report-help/36224 "2021-07-23T07:32:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Handfish](https://avatars.discourse-cdn.com/v4/letter/h/7ea924/32.png) [@Handfish](https://forum.manager.io/u/Handfish)\
**Post date:** [July 23, 2021, 7:32am UTC](https://forum.manager.io/t/custom-report-help/36224/1 "2021-07-23T07:32:27Z")

</div>

Hi guys  
i need help in custom report  
i have a small shoe industries  
and i want to make a yearly report every of every customer includes all sale detail , debit . credit and balance. i am having difficulty in have item detail in report . we have item code (Gents , ladies ,Boys , kids) etc.  
i want report like:  
**(Date ; Customer ; sale Reference ; item code ; item code ; item code ; total item ; debit ; credit ; total balance)**  
i would appreciate if anyone help.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [July 23, 2021, 10:59am UTC](https://forum.manager.io/t/custom-report-help/36224/2 "2021-07-23T10:59:36Z")

</div>

> [@Handfish](#):
>
> item code ; item code ; item code

Do you mean a list of all the sold items grouped in the same line? The way custom reports work don’t permit you to achieve the summary that you need. You cannot have opening balance, you cannot pivot tables, you cannot make calculations.

Maybe, it works for you, you better export a raw list and than do the transformation under excel with pivot tables connected to the export table.

---

<div class="post-metadata">

**Author:** ![Handfish](https://avatars.discourse-cdn.com/v4/letter/h/7ea924/32.png) [@Handfish](https://forum.manager.io/u/Handfish)\
**Post date:** [July 23, 2021, 3:44pm UTC](https://forum.manager.io/t/custom-report-help/36224/3 "2021-07-23T15:44:59Z")

</div>

i think i didnt explain that well.  
I have many selling item under this code say  
Under  
Gents - 50 item  
Ladies -48 item  
Boys - 50 item  
so in each sale invoice many item are sold from **Gents , ladies , boys** and so on.

 ![Screenshot (5)](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/b/4be052d8d76b2d21b3705fa381ace31c1e3a863f.png)  
Report like this  
each line is for each invoice or receipt

---

<div class="post-metadata">

**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [July 23, 2021, 7:30pm UTC](https://forum.manager.io/t/custom-report-help/36224/4 "2021-07-23T19:30:24Z")

</div>

So how did you set this up as inventory items in Manager? What I mean is did you create Gents, Ladies, etc. Inventory items?

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 23, 2021, 11:04pm UTC](https://forum.manager.io/t/custom-report-help/36224/6 "2021-07-23T23:04:22Z")

</div>

> [@Handfish](#):
>
> I have many selling item under this code say  
> Under  
> Gents - 50 item  
> Ladies -48 item  
> Boys - 50 item

> [@eko](#):
>
> did you create Gents, Ladies, etc. Inventory items

Or list their group in a custom field?

Or to put the question another way, what identifies a shoe as a “Gents” shoe to the Manager software?

---

<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:** [July 5, 2026, 8:19pm UTC](https://forum.manager.io/t/custom-report-help/36224/7 "2026-07-05T20:19:23Z")

</div>

Uncategorized topics older than 3 years with no recent activity