# Custom Report Customer detailed Statements **URL:** \ **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:** 17\ **Page:** 1
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [December 14, 2020, 9:07pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/1 "2020-12-14T21:07:54Z")
Dear Manager Community, I am an accountant. I am so impressed by Manager. and I want to thank the great developer behind it for the wonderful work done. I tried to convince companies that I deal with to install Manager. and installed Manager in one of them. but I found one important issue stopping them from adopting it which is the detailed customer report. since in the business culture in my county customers frequently requests this report. so I request from you to help me building custom report nearly the same as the available report “Customer detailed Statements (Transactions)” but the details of the invoices show also on it. this will help me a lot to convince many companies to adopt Manager as their main accounting software. Thanks in advance for your support waiting to hear from you ---
**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:** [December 14, 2020, 11:12pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/2 "2020-12-14T23:12:29Z")
Have you tried building a custom report to do this yet? Please do not ask other forum members to do something you are unwilling to first try yourself. If you have problems, then ask specific questions. When you ask, show the definition of the custom report and the result. Tell how you want it to be different from what you have achieved. ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [December 15, 2020, 7:56am UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/3 "2020-12-15T07:56:15Z")
Thanks @Tut for your reply. Yes, I tried many many times but I didn’t succeed. so I asked the community to help me creating a custom report the same as “Customer detailed Statements (Transactions)” but including the details of the sales invoices. I think this report will help many users. since I found it requested many times before in the community. ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [December 15, 2020, 6:01pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/4 "2020-12-15T18:01:30Z")
Dear @lubos I need your help, please ---
**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:** [December 15, 2020, 6:20pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/5 "2020-12-15T18:20:54Z")
> [@aamra](#): > > Yes, I tried many many times but I didn’t succeed. Then please do what I asked. Post a screen shot of the definition of the custom report that came closest to what you want, along with the result. You need to be a participant in the discussion if you want help. ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [December 15, 2020, 6:49pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/6 "2020-12-15T18:49:58Z")
Thanks @Tut for your reply. I tried the following: ![Capturefdf](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/3/c33d9a4cd132932d6a8fff4d3395798aaecbbc16.jpeg) what I want is the below report with the details of the invoices & receipts: ![لقطة الشاشة 2020-12-15 204719](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/9/f93daed1693bc72e24487306ecbce67580b9264a.jpeg) ---
**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\ **Post date:** [December 16, 2020, 9:22am UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/7 "2020-12-16T09:22:44Z")
Are you looking for a customer statement as in how much they have paid, been invoiced and what is outstanding or what do your customer’s use the report for? ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [December 16, 2020, 9:45am UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/8 "2020-12-16T09:45:10Z")
Thanks @dalacor for your reply. 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) hope that you will be able to help me. ---
**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\ **Post date:** [December 16, 2020, 10:19am UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/9 "2020-12-16T10:19:58Z")
Oh I see - you need the details underneath as well. Not something I can advise on as I have never actually used the custom reports as yet. The only thing that I can suggest is to look at the guides to see if there is anything there that might help indicate where the problem is. ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [January 2, 2021, 1:55pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/10 "2021-01-02T13:55:31Z")
Many thanks, @dalacor for your help. I reviewed a lot of guides and searched the forum many times but I didn’t find what I want. because of that, I requested help here. ---
**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:** [January 2, 2021, 2:14pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/11 "2021-01-02T14:14:21Z")
@aamra, here are some quick thoughts: - Your report does not include customer among your selected items. - You have not included quantity. - The sales price is only the price defined for the item, not the price at which you sold it. (That amount is not exposed currently for custom reports.) \*You have left second tier fields empty in your filtering that cannot be empty. - You are ordering and grouping by variables you did not select. ---
**Author:** ![MuttakiNl](https://avatars.discourse-cdn.com/v4/letter/m/a698b9/32.png) [@MuttakiNl](https://forum.manager.io/u/MuttakiNl)\ **Post date:** [February 9, 2021, 11:29pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/12 "2021-02-09T23:29:01Z")
I think if what is suggested here been implemented it would be a great upgrade for Manager. Here in Turkey people expect to see the details of the invoices in a customer statement report. Without the invoice details it is regarded as lacking info. An option to include details would be perfect. ---
**Author:** ![kosten](https://avatars.discourse-cdn.com/v4/letter/k/22d042/32.png) [@kosten](https://forum.manager.io/u/kosten)\ **Post date:** [August 28, 2021, 11:44am UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/13 "2021-08-28T11:44:45Z")
Hello. Have You created this report? Can You show it? ---
**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")
> [@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\     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) ---
**Author:** ![aamra](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/aamra/32/22812_2.png) [@aamra](https://forum.manager.io/u/aamra)\ **Post date:** [October 14, 2021, 10:21am UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/15 "2021-10-14T10:21:01Z")
Many thanks, @dcVest for your usual support. I want to ask why some items have quantity and others not? ---
**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:** [October 14, 2021, 12:22pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/16 "2021-10-14T12:22:47Z")
> [@aamra](#): > > why some items have quantity and others not? Most likely, you did not enter a quantity for that line item on the source transaction. ---
**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:52pm UTC](https://forum.manager.io/t/custom-report-customer-detailed-statements/32028/17 "2023-01-18T14:52:08Z")