# Custom Reports **URL:** \ **Category:** Uncategorized\ **Created:** [August 11, 2015, 4:56pm UTC](https://forum.manager.io/t/custom-reports/3530 "2015-08-11T16:56:05Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![Kevin\_Gan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/kevin_gan/32/18629_2.png) [@Kevin\_Gan](https://forum.manager.io/u/Kevin_Gan)\ **Post date:** [July 19, 2016, 3:22am UTC](https://forum.manager.io/t/custom-reports/3530/41 "2016-07-19T03:22:53Z")
Hi Lubos Can custom report make the following: 1. combine profit and loss and balance sheet along with director declaration, accountants report, content, note to account, cover page, etc ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [July 19, 2016, 3:46am UTC](https://forum.manager.io/t/custom-reports/3530/42 "2016-07-19T03:46:59Z")
Custom reports won’t be able to do this. I think there will be new report type called `Complete report` which will allow to combine all financial statements including some static documents and cover page to produce single complete report for business. ---
**Author:** ![Kevin\_Gan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/kevin_gan/32/18629_2.png) [@Kevin\_Gan](https://forum.manager.io/u/Kevin_Gan)\ **Post date:** [July 19, 2016, 4:44am UTC](https://forum.manager.io/t/custom-reports/3530/43 "2016-07-19T04:44:33Z")
Hi Lubos that’s a good news. I hope that this would have implemented soon. As for static documents - it can be edited to suite each entity purpose and also different country have a different reporting format. In Australia, I need a director declaration or trustee declaration, accountant compilation report and note to financial. I hope that the complete report can be in this orders: Cover page Content page Balance Sheet Profit and Loss Note to accounts (can be edited) Declaration page (can be edited) Accountant page (can be edited) ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [August 23, 2016, 1:40am UTC](https://forum.manager.io/t/custom-reports/3530/44 "2016-08-23T01:40:41Z")
I all ways have the P&L before the balance sheet ---
**Author:** ![davew](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@davew](https://forum.manager.io/u/davew)\ **Post date:** [August 24, 2016, 9:39am UTC](https://forum.manager.io/t/custom-reports/3530/45 "2016-08-24T09:39:40Z")
Hi. I’ve just installed Manager and am very impressed - including that it has an SQL database. I am an IT professional and see many mainstream business applications that are not using the global database standard. That said, I look forward to having the table details made available for customer reporting. ---
**Author:** ![bespoka](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/bespoka/32/4491_2.png) [@bespoka](https://forum.manager.io/u/bespoka)\ **Post date:** [September 7, 2016, 9:29pm UTC](https://forum.manager.io/t/custom-reports/3530/46 "2016-09-07T21:29:23Z")
Hi Lubos, Firstly I think this software is amazing! It does everything that I need. Do you know when the data structure for the customer reports is going to be made available? Thanks again, Paul ---
**Author:** ![Hang\_Vo](https://avatars.discourse-cdn.com/v4/letter/h/8dc957/32.png) [@Hang\_Vo](https://forum.manager.io/u/Hang_Vo)\ **Post date:** [September 16, 2016, 3:30am UTC](https://forum.manager.io/t/custom-reports/3530/47 "2016-09-16T03:30:42Z")
Hi guys - Great tool! Does anybody know where i can find documentation on this feature? Thanks! ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [September 16, 2016, 4:33am UTC](https://forum.manager.io/t/custom-reports/3530/48 "2016-09-16T04:33:18Z")
Not yet implemented, #6 on the roadmap > [@Roadmap](https://forum.manager.io/t/roadmap/5913): > > This is a list of features which are going to be implemented in Manager in upcoming weeks or months. Features are sorted in order in which they are most likely going to be implemented. Audit trail For cloud edition and server edition it’s important to see what users accessing the system are doing. Job costing Currently, if you need to measure profitability by job, you can use Tracking codes concept. However tracking codes are more appropriate for divisions rather than short-lived jobs. New tab… ---
**Author:** ![fahadalarab](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/fahadalarab/32/49040_2.png) [@fahadalarab](https://forum.manager.io/u/fahadalarab)\ **Post date:** [September 22, 2016, 6:15am UTC](https://forum.manager.io/t/custom-reports/3530/49 "2016-09-22T06:15:52Z")
Love to see that warehousing and these features are going to be added. Also can you suggest anything like is it possible from manager to proceed a quick check out in retail sale. I mean i want to generate on the spot invoices for customers in our physical store. Like the barcode one but. Since I’m using cloud edition now i was thinking if any third application could be integrated? ---
**Author:** ![ahmadsetioaji](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmadsetioaji/32/663_2.png) [@ahmadsetioaji](https://forum.manager.io/u/ahmadsetioaji)\ **Post date:** [September 22, 2016, 6:34am UTC](https://forum.manager.io/t/custom-reports/3530/50 "2016-09-22T06:34:13Z")
Yes it is, i have been waiting for long time. Hello @lubos when its done?? ---
**Author:** ![Barmenturthe](https://avatars.discourse-cdn.com/v4/letter/b/8edcca/32.png) [@Barmenturthe](https://forum.manager.io/u/Barmenturthe)\ **Post date:** [October 17, 2016, 2:28pm UTC](https://forum.manager.io/t/custom-reports/3530/51 "2016-10-17T14:28:53Z")
Thanks, lots of useful information! it helped me a lot! thanks, I was getting anxious that I won’t be able to do it all. thanks to you I did. ---
**Author:** ![BaldeSeca](https://avatars.discourse-cdn.com/v4/letter/b/ec9cab/32.png) [@BaldeSeca](https://forum.manager.io/u/BaldeSeca)\ **Post date:** [February 8, 2017, 11:57pm UTC](https://forum.manager.io/t/custom-reports/3530/53 "2017-02-08T23:57:34Z")
Any documentation on database tables and relations is available? so that we can query using custom report. ---
**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:** [February 9, 2017, 12:09am UTC](https://forum.manager.io/t/custom-reports/3530/54 "2017-02-09T00:09:34Z")
Not yet. ---
**Author:** ![vaibhav\_kapoor](https://avatars.discourse-cdn.com/v4/letter/v/4491bb/32.png) [@vaibhav\_kapoor](https://forum.manager.io/u/vaibhav_kapoor)\ **Post date:** [March 4, 2017, 1:06pm UTC](https://forum.manager.io/t/custom-reports/3530/56 "2017-03-04T13:06:37Z")
How to get custom report for1. Customer wise last invoice date2. In Last 1 year how many customers bought product “A”… KINDLY SUGGEST ---
**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 4, 2017, 2:20pm UTC](https://forum.manager.io/t/custom-reports/3530/57 "2017-03-04T14:20:05Z")
> [@vaibhav\_kapoor](#): > > How to get custom report for1. Customer wise last invoice date In `Customers` tab, click on the blue number under Sales Invoices for that customer. The default order for the drill-down report is by status, with overdue invoices first. But you can click on the Invoice Date column heading to sort by date. The first click puts them in chronological order. A second click reverses their order. > [@vaibhav\_kapoor](#): > > 1. In Last 1 year how many customers bought product “A”… Under `Reports`, the Inventory Quantity Movement and Inventory Value Movement reports will tell you how much of a product you sold and what the sales value was for a defined period. They do not, however, tell you which customers purchased it. ---
**Author:** ![Taher\_Nomani](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/taher_nomani/32/11557_2.png) [@Taher\_Nomani](https://forum.manager.io/u/Taher_Nomani)\ **Post date:** [July 2, 2017, 8:31am UTC](https://forum.manager.io/t/custom-reports/3530/58 "2017-07-02T08:31:14Z")
Dear Sir, How to we get a customer wise inventory sold report. I mean what query can we put in custom reports to get this report ? Best Regards, Taher Nomani ---
**Author:** ![BaldeSeca](https://avatars.discourse-cdn.com/v4/letter/b/ec9cab/32.png) [@BaldeSeca](https://forum.manager.io/u/BaldeSeca)\ **Post date:** [September 9, 2017, 1:51am UTC](https://forum.manager.io/t/custom-reports/3530/59 "2017-09-09T01:51:57Z")
Any change on the status of custom reports ? I would like a report of Production oders and the associated cost. Any way I can get the database schema. ---
**Author:** ![ShaneAU](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shaneau/32/10122_2.png) [@ShaneAU](https://forum.manager.io/u/ShaneAU)\ **Post date:** [September 9, 2017, 2:10am UTC](https://forum.manager.io/t/custom-reports/3530/60 "2017-09-09T02:10:34Z")
> [@BaldeSeca](#): > > Any change on the status of custom reports ? Sorry, I haven’t noticed any update on this (have done a few searches myself). > [@BaldeSeca](#): > > Any way I can get the database schema. There are some posts further up in this topic that explain parts of the schema (certain table names, and that joins aren’t necessary). Nothing more than that. ---
**Author:** ![BaldeSeca](https://avatars.discourse-cdn.com/v4/letter/b/ec9cab/32.png) [@BaldeSeca](https://forum.manager.io/u/BaldeSeca)\ **Post date:** [September 9, 2017, 2:16am UTC](https://forum.manager.io/t/custom-reports/3530/61 "2017-09-09T02:16:18Z")
Thank You. I don’t understand the mystery as the custom Reports is available, why not give the information. Users could create reports and share this will greatly enhance the program. By the way I think it is among the best of the best. ---
**Author:** ![irfankhatri](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/irfankhatri/32/18907_2.png) [@irfankhatri](https://forum.manager.io/u/irfankhatri)\ **Post date:** [October 8, 2017, 5:35am UTC](https://forum.manager.io/t/custom-reports/3530/62 "2017-10-08T05:35:04Z")
> [@lubos](#): > > SELECT SalesInvoice.Customer.Name > FROM SalesInvoiceLines > WHERE SalesInvoice.Date \> DateTime.Today.AddMonths(-6) AND InventoryItem.Code = “ABC0001” DEAR SIR, Kindly do share structure of database to utilized custom report facility. [Previous page](https://forum.manager.io/t/custom-reports/3530.md?page=2) [Next page](https://forum.manager.io/t/custom-reports/3530.md?page=4)