# Custom Report - Sales Order **URL:** \ **Category:** Uncategorized\ **Created:** [January 16, 2023, 2:07pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031 "2023-01-16T14:07:08Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 16, 2023, 2:07pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/1 "2023-01-16T14:07:08Z")
I am so not expert in custom reporting, but i need a quick fix right now if anyone can help me. 1. Sales order report - just like AR report, showing all sales order with total amount, and amount which has been invoiced, not yet invoiced, and partially invoiced. sorted based on customer name. 2. report based on project name, listing all income’s sources (invoices) and direct costs’s sources (payments) thanks in advance! ---
**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 16, 2023, 2:17pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/2 "2023-01-16T14:17:07Z")
Hi @yhart, You need to submit your best attempt at the report so other users can assist. Please refer to forum’s [community guidelines](https://forum.manager.io/faq) for more information. ---
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 17, 2023, 2:34am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/3 "2023-01-17T02:34:33Z")
Hi @Ealfardan, To be honest I really have no clue yet as to how the custom reports work. I have been reading many pages in the forum but still couldn’t reproduce what i needed. i hope someone can help me here. ![Screenshot 2023-01-17 093311](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/1/71bae767ee08e020006d4596fcbad08a44ed19b9.png) ---
**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 17, 2023, 4:31am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/4 "2023-01-17T04:31:38Z")
As per the guidelines, post result, too. ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [January 17, 2023, 6:15am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/5 "2023-01-17T06:15:58Z")
> [@yhart](#): > > To be honest I really have no clue yet as to how the custom reports work. Then why not stick to the standard reports available? If you want a custom report you will need to experiment with it and learn the ins and outs. Show your best attempts, etc. ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [January 17, 2023, 1:06pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/6 "2023-01-17T13:06:48Z")
> [@eko](#): > > Then why not stick to the standard reports available? There is no standard reports to print sales orders. I was looking for one earlier on when I wanted to track orders that have been partially invoiced. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [January 17, 2023, 1:14pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/7 "2023-01-17T13:14:50Z")
The custom reports only report on financial transactions, as far as I am aware Sales Orders are not financial transactions ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [January 17, 2023, 1:38pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/8 "2023-01-17T13:38:03Z")
My comment related to the fact that @yhart explained that he has no clue how customs report work. Without putting effort into experimenting and learning to create these then one should consider what essential accounting info one can get reports on and these are like P&L, Balance Sheet and Cash-flow at a minimum and available under reports. So you either dig in or settle for what exists. ---
**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 17, 2023, 1:41pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/9 "2023-01-17T13:41:31Z")
> [@Panashe\_Mlambo](#): > > I was looking for one earlier on when I wanted to track orders that have been partially invoiced. The **Sales Orders** tab is designed for exactly that. @Panashe_Mlambo could you please explain what is that the Sales Orders tab is missing? ---
**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 17, 2023, 1:44pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/10 "2023-01-17T13:44:26Z")
Having tried it. I don’t think there’s a way to get all this information from a single Custom Report: > [@yhart](#): > > Sales order report - just like AR report, showing all sales order with total amount, and amount which has been invoiced, not yet invoiced, and partially invoiced. sorted based on customer name. Also, why not simply drill down the **Projects** tab for this: > [@yhart](#): > > report based on project name, listing all income’s sources (invoices) and direct costs’s sources (payments) ---
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 17, 2023, 1:44pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/11 "2023-01-17T13:44:28Z")
@eko i dont think you realized what i need. what i need is a sales order report. can you find it in the currently available report? As im aware there is no standard reports for sales order, and as you can see above i have tried experimenting with custom reports. (see above my screenshot on my attempt on custom reports). i just need someone to correct what i’ve been doing wrong. to produce the result that i want. ---
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 17, 2023, 1:48pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/12 "2023-01-17T13:48:03Z")
@Ealfardan thanks for the reply. so basically can’t do it with all that information in 1 page yes. On the projects, it only shows all the projects summary. Project A, B, C, D, E. I need: Project A- income sources - invoice A, B, C , D, E cost - payment A, B, C, D, E Project B, and so on ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [January 17, 2023, 2:05pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/13 "2023-01-17T14:05:17Z")
> [@Ealfardan](#): > > could you please explain what is that the Sales Orders tab is missing The Sales Order Tab has the **STATUS** column but I can not see how much is not yet invoiced. I have to manually calculate the amount that has not yet been invoiced. ---
**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 17, 2023, 5:22pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/14 "2023-01-17T17:22:16Z")
This is on Cloud Version 23.1.11.592, there’s a column for `Amount` and another column for `Invoiced`: ![Screenshot_20230117-201530~2](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/2/d2cc4a910bfb3eaacaec94bbfc62457e2016affe.png) I remember at one point, `Unit Price` field was removed from **Sales Orders** but, thankfully, now it’s back again which means that tracking invoiced amounts against sales orders is now possible. ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [January 17, 2023, 7:48pm UTC](https://forum.manager.io/t/custom-report-sales-order/45031/15 "2023-01-17T19:48:41Z")
> [@yhart](#): > > i dont think you realized what i need I did realize what you needed and did not like you to ask us to do the job for you which is against the forum rules. Up till now you did not show the results screen of your “attempt” as requested by @tut. I think that you just want us to do your job hence my response. ---
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 18, 2023, 1:52am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/16 "2023-01-18T01:52:41Z")
i am just merely asking for help here, i don’t see why do you have to be so critic about it. I did some work myself. i don’t think result screen of the “attempt” is what you’re after anyways. Oh well, let’s agree to end the argue here. ---
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 18, 2023, 1:56am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/17 "2023-01-18T01:56:24Z")
@Ealfardan i had this too. copying to clipboard should do the job, but with the currency on, the spreadsheet couldn’t detect the numbers. ---
**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 18, 2023, 5:25am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/18 "2023-01-18T05:25:57Z")
> [@yhart](#): > > i don’t see why do you have to be so critic about it…i don’t think result screen of the “attempt” is what you’re after anyways. On the contrary, @yhart, @eko was completely correct to ask for the result of your attempt. Telling forum members via a post what you want in vague terms without engaging in the process yourself is, indeed, asking others to do your own work. That is why the forum rule exists: > “ **If your question is related to custom themes or custom reports, always post the code or report definition you have developed and the results it produces.** ” ---
**Author:** ![yhart](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yhart/32/42719_2.png) [@yhart](https://forum.manager.io/u/yhart)\ **Post date:** [January 18, 2023, 10:33am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/19 "2023-01-18T10:33:09Z")
@Tut i perfectly understood and don’t mind you or him asking for the results of the attempt part. i haven’t posted the result yet because it will expose my company data. But as you can see i was being criticized way before he asked for the results though. But anyways let’s agree to stop here. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [January 18, 2023, 10:57am UTC](https://forum.manager.io/t/custom-report-sales-order/45031/20 "2023-01-18T10:57:47Z")
> [@yhart](#): > > i haven’t posted the result yet because it will expose my company data. A reasonable concern. The simplest solution to which is create a test business with dummy data then use that to post illustrations on the forum. A test business can be created from scratch with just a few illustrative transactions (which often makes the reports easier to understand/ debug). Alternatively you can backup your real business, re import it, rename it, batch delete confidential data, then use the residual as a test business for posting examples. [Next page](https://forum.manager.io/t/custom-report-sales-order/45031.md?page=2)