# Custom Reports - Amounts Field

**URL:** <https://forum.manager.io/t/custom-reports-amounts-field/21166>\
**Category:** Uncategorized\
**Created:** [March 17, 2019, 4:12pm UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166 "2019-03-17T16:12:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ProDev](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/prodev/32/1036_2.png) [@ProDev](https://forum.manager.io/u/ProDev)\
**Post date:** [March 17, 2019, 4:12pm UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166/1 "2019-03-17T16:12:50Z")

</div>

@Tut  
In Custom Reports I’ve noticed that in some reports there is no option to select the Amount field. For example, custom report From… ‘Purchase Invoices’ allows the selection of 3 items ’ Description’, ‘IssueDate’, and ‘Reference’.  
I cannot see why anyone would want a report of Purchase Invoices if it’s not possible to select and show the invoice amount?  
This seems to be the case with all custom reports I’ve looked at except for ‘General Ledger’ where ‘Amount’ is a selectable option.

---

<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:** [March 17, 2019, 5:07pm UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166/2 "2019-03-17T17:07:32Z")

</div>

What you point out occurs because, when you query the purchase invoices table, you get information about the purchase invoices themselves: supplier, date, and so forth. But amounts are not part of that table. Amounts are recorded as line by line transactions posted to the general ledger. So any time you want amounts, credits, or debits, you must query the general ledger transactions table.

---

<div class="post-metadata">

**Author:** ![ProDev](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/prodev/32/1036_2.png) [@ProDev](https://forum.manager.io/u/ProDev)\
**Post date:** [March 20, 2019, 10:49am UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166/3 "2019-03-20T10:49:07Z")

</div>

Tut, On Custom Reports of General Ledger Transactions, Supplier name does not appear where the Transaction is an invoice or an expense. It only appears for payments.

---

<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:** [March 20, 2019, 2:05pm UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166/4 "2019-03-20T14:05:20Z")

</div>

As has been written many times in the forum and newsletter, custom reports are still being worked on.

---

<div class="post-metadata">

**Author:** ![ProDev](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/prodev/32/1036_2.png) [@ProDev](https://forum.manager.io/u/ProDev)\
**Post date:** [March 20, 2019, 3:38pm UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166/5 "2019-03-20T15:38:57Z")

</div>

Noted. I did search the forum but didn’t find anything and I don’t read everything that gets posted.

I’m guessing it will be a simple fix.

Ciao  
Neil

---

<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:49pm UTC](https://forum.manager.io/t/custom-reports-amounts-field/21166/6 "2023-01-18T14:49:38Z")

</div>