# Custom reports **URL:** \ **Category:** Uncategorized\ **Created:** [December 3, 2018, 6:08am UTC](https://forum.manager.io/t/custom-reports/19384 "2018-12-03T06:08:19Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 3, 2018, 6:08am UTC](https://forum.manager.io/t/custom-reports/19384/1 "2018-12-03T06:08:19Z")
when generate custom report, Amount is missing Please check. ![custom%20report](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/1/416eb642f9c6768e74945866df4b5f90c8f9c501.png) ---
**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:** [December 3, 2018, 10:27am UTC](https://forum.manager.io/t/custom-reports/19384/2 "2018-12-03T10:27:33Z")
Without a screen shot of the actual file and fields you have selected for the custom report, it is not possible to work out why you do not get the results you expect. Please post the edit screen for the 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:** [December 3, 2018, 1:19pm UTC](https://forum.manager.io/t/custom-reports/19384/3 "2018-12-03T13:19:50Z")
You also need to post a screen shot of at least one of the transactions that shows a zero amount. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 4, 2018, 7:53pm UTC](https://forum.manager.io/t/custom-reports/19384/4 "2018-12-04T19:53:46Z")
> [@Tut](#): > > screen ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/d/adeb3378ef75a07d96953d33fabdb6bee307dc0a.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:** [December 4, 2018, 9:20pm UTC](https://forum.manager.io/t/custom-reports/19384/5 "2018-12-04T21:20:55Z")
We need to see the custom report definition. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 5, 2018, 12:50pm UTC](https://forum.manager.io/t/custom-reports/19384/6 "2018-12-05T12:50:50Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/7/97519c7edfb31d78a2ca410dad000bb37e371c7b.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:** [December 5, 2018, 2:03pm UTC](https://forum.manager.io/t/custom-reports/19384/7 "2018-12-05T14:03:05Z")
`Amount` is missing because you have not selected it. The custom report definition you show in your last post is not for the report you showed in your first post. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 5, 2018, 2:48pm UTC](https://forum.manager.io/t/custom-reports/19384/8 "2018-12-05T14:48:25Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/f/cfdc8dd9bd1f400385eeef9fb98f04ce64a8fcb9.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/e/9e7b0fc5c63e0f91a6deec3840a702bc72a1fd93.png) please check debit, credit, amount all are missing ---
**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 5, 2018, 6:00pm UTC](https://forum.manager.io/t/custom-reports/19384/9 "2018-12-05T18:00:29Z")
I don’t know what you are doing wrong. Now that I have had time, I have mocked up a custom report with your same inputs (although on a different business, of course, and the date range is different). The results are as follows (in this case, not every transaction has a reference number): ![25%20PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/9/390a26539be2dfd666e76d648cadccac4c4e1752.png) This comes from version 18.11.64. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 6, 2018, 2:06am UTC](https://forum.manager.io/t/custom-reports/19384/10 "2018-12-06T02:06:15Z")
i can send our db if needed i will check with latest version we sell from receipt (cash sales) ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 6, 2018, 2:15am UTC](https://forum.manager.io/t/custom-reports/19384/11 "2018-12-06T02:15:46Z")
can you guide me how to check report i want to know item code, item name, qty, Price, Amount (from Cash Receipt) Thanks checked with latest version same result ---
**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 6, 2018, 2:54am UTC](https://forum.manager.io/t/custom-reports/19384/12 "2018-12-06T02:54:51Z")
No. I cannot suggest how you should check the report. I put in your parameters and got the expected results. Try creating a brand new report. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 6, 2018, 3:20pm UTC](https://forum.manager.io/t/custom-reports/19384/13 "2018-12-06T15:20:13Z")
What I want is single line Sales Price and Amount ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/e/8e9435b0ae14ded5164c6df405c2747b7be4f18d.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:** [December 6, 2018, 5:48pm UTC](https://forum.manager.io/t/custom-reports/19384/14 "2018-12-06T17:48:44Z")
Now you are raising a totally different subject. You originally complained that `Amount` did not show. Then it was `Debit`, `Credit`, and `Amount.` Now, apparently, they all show. But you have not said what solved the problem. But you say you want `Sales Price` and `Amount` on the same line. They are! But that isn’t your problem. Your problem now seems to be that you get one or the other. Obviously, you’ve edited the custom report. So we need to start all over with screen shots of the report definition, a representative transaction, and the report that is generated. This time, everything needs to go together, not have changes from one to the other. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 7, 2018, 2:15am UTC](https://forum.manager.io/t/custom-reports/19384/15 "2018-12-07T02:15:34Z")
hi, i’m not raising a totally different subject. this is my report criteria ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/8/282d20eedbfcf7f20e2560a3bd81e0019a8d1a0c.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/9/99efe2a724ac9506eb622ab0261238e8c3bb357a.png) here is the result ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/8/2856c07f14e9cecee9babeed620c49e1301b5ab9.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:** [December 7, 2018, 3:17am UTC](https://forum.manager.io/t/custom-reports/19384/16 "2018-12-07T03:17:41Z")
@San_Thida_Myo_Latt, I am pulling out of this discussion. I’ve been trying my best to help you, but cannot reproduce any of the problems you describe. Every time you show a report definition or result, it’s different from everything you have shown before. But you never explain the differences or answer my questions. I cannot chase a moving target. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [December 7, 2018, 10:16am UTC](https://forum.manager.io/t/custom-reports/19384/17 "2018-12-07T10:16:14Z")
i don’t clear what you mean on my last screen, i had provided reports definition and output result this is same as my initial post Actually What I want is We made “Cash Sales” from Receipt What I want is I want to see Item Code, Sales Price (from receipt), Sales Price( what we defined at inventory) now i can’t get that result can anyone guide me ---
**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:07pm UTC](https://forum.manager.io/t/custom-reports/19384/18 "2023-01-18T15:07:50Z")