# Custom Report Customer detailed Statements

**URL:** <https://forum.manager.io/t/custom-report-customer-detailed-statements/32028>\
**Category:** Uncategorized\
**Created:** [December 14, 2020, 9:07pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028 "2020-12-14T21:07:54Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![dcVest](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@dcVest](https://forum.manager.io/u/dcVest)\
**Post date:** [October 11, 2021, 11:52pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/14 "2021-10-11T23:52:02Z")

</div>

> [@aamra](#):
>
> I am locking form custom report the same as the available report “Customer detailed Statements (Transactions)” with the invoice details under each invoice (Item name, unit, price, the quantity bought and amount)

@aamra, here’s an attempt at your custom report. First a Customer Statement (Transactions) from a modified Northwind file for the customer Alfreds Futterkiste:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/1/3111eac08278bc3e39b10f4ece0c5ea981ce75f3.png)

It is not possible to reproduce the running total, but the following custom report, as a supplementary statement, may be helpful:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/b/cb4f85736b5381312af7553dac2053855b7f4e5d.png)

The edit screen:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/8/2881d990ea72c043058e490cbc973164e2c11337.png)

Because it does not show completely in the above, the Alias for the TransactionName is: Date\<br\>&nbsp&nbsp&nbsp&nbsp Description - Reference - Date

**Notes on the Where section:**  
For the custom report, data is needed from these accounts:  
Cash at bank  
Cash on hand  
GST payable  
Inventory - sales

The Where filter does not have “or” logic to get data only from the above accounts. So, “does not contain” is used to exclude other accounts and their unwanted data. Only you know your Chart of Accounts so if necessary exclude additional accounts by adding additional “does not contain” lines.

In the Where filter the line “Contact” is used to generate a report for a single customer. I’ve seen [elsewhere](https://forum.manager.io/t/most-important-3-improvements-suggested/37349/11) that you have tried “Customer code”. That should work in place of Contact.

If you have multiple sales invoices to the same customer on the same day you may want to add another line to the “Group by” section:  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/4/e40b15a679ac9c34acdb620efb7fc4d58d09b69e.png)

---

_[View the full topic](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028)._