# Custom Report

**URL:** <https://forum.manager.io/t/custom-report/4579>\
**Category:** Uncategorized\
**Created:** [January 21, 2016, 1:16pm UTC](https://forum.manager.io/t/custom-report/4579 "2016-01-21T13:16:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AntonisV](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/antonisv/32/6914_2.png) [@AntonisV](https://forum.manager.io/u/AntonisV)\
**Post date:** [January 21, 2016, 1:16pm UTC](https://forum.manager.io/t/custom-report/4579/1 "2016-01-21T13:16:30Z")

</div>

Hi there guys,

Can anyone tell me a how can i achieve a custom report with the following columns:

Sales Invoice Number | Date Issued | Customer Issued | Net Amount | Tax Amount | Total Amount

And at the end of the lines adds the amounts for totals.

Can this report be achievable through “custom reports”? Can i add more columns with custom fields of the customers?

---

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [January 21, 2016, 5:46pm UTC](https://forum.manager.io/t/custom-report/4579/2 "2016-01-21T17:46:40Z")

</div>

I’ve tried almost everything (I think) but no custom fields. Only this works for now:

SELECT reference, issuedate, customername FROM SalesInvoices

**update:**

SELECT reference AS Invoice, issuedate AS Date, customername AS Customer, balancedue AS Balance\_Due FROM SalesInvoices ORDER BY issuedate, reference

no luck with “subtotal” or “total”.

---

<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:35pm UTC](https://forum.manager.io/t/custom-report/4579/3 "2023-01-18T15:35:15Z")

</div>

Closed on January 18, 2023, 3:35pm UTC


