# Sales Invoice by Date Range with Details Items **URL:** \ **Category:** Uncategorized\ **Created:** [March 18, 2019, 8:41am UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175 "2019-03-18T08:41:56Z")\ **Posts on this page:** 12\ **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:** [March 18, 2019, 8:41am UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/1 "2019-03-18T08:41:56Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/0/e017b92acbd53ed8e7357f27551718eb31d2b2fb.png) how can i extract above report from customized report thanks ---
**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:** [July 2, 2019, 4:59am UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/2 "2019-07-02T04:59:00Z")
can someone help me how to generate that 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:** [July 2, 2019, 11:54am UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/3 "2019-07-02T11:54:47Z")
You can’t get the report you want, because the unit price field is not exposed in the general ledger transactions table. (I assume from your screen shot that is what you mean by “Amount,” although the `Amount` field is actually something else in Manager. The closest you can get is to use the sales price for the inventory item. Note, however, that number will come from the inventory item definition, not the sales invoice. If you edit it or discount it, the change will not show up on your custom report. See below: ![41%20AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/8/888a33f6a9e384053a3f6eeb150320585c884f46.png) ---
**Author:** ![Sanif\_Sentosa](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sanif_sentosa/32/24169_2.png) [@Sanif\_Sentosa](https://forum.manager.io/u/Sanif_Sentosa)\ **Post date:** [July 9, 2020, 1:29pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/4 "2020-07-09T13:29:45Z")
hi, how do we do it in the current version of Manager? it’s almost totally different now. Could you please give me example using the latest version custom report? I roughly do like this. And why is there are repeated / double entry came out, one with (+) and another with (-). ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/1/31465d495534e0909a4ea6f8e1f721167aeb0915.png) ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/c/2c1811435ff429134ab5739919389ce79341d14a.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:** [July 9, 2020, 1:53pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/5 "2020-07-09T13:53:41Z")
> [@Sanif\_Sentosa](#): > > how do we do it in the current version of Manager? How do you do what? This year-old thread asked how to do something that could not be done. I showed the other user a report I already had that was related, but not the same thing. > [@Sanif\_Sentosa](#): > > Could you please give me example using the latest version custom report? I do not have one. > [@Sanif\_Sentosa](#): > > why is there are repeated / double entry came out Because Manager is a double-entry accounting system, so every transaction includes at least two account postings. ---
**Author:** ![Sanif\_Sentosa](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sanif_sentosa/32/24169_2.png) [@Sanif\_Sentosa](https://forum.manager.io/u/Sanif_Sentosa)\ **Post date:** [July 9, 2020, 2:02pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/6 "2020-07-09T14:02:33Z")
> How do you do what? This year-old thread asked how to do something that could not be done. I showed the other user a report I already had that was related, but not the same thing. I mean the “Sales Invoice by Date Range with Details Item Report”. > Because Manager is a double-entry accounting system, so every transaction includes at least two account postings. so how do I limit / filter the report to just only showing one instead of two? ---
**Author:** ![Sanif\_Sentosa](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sanif_sentosa/32/24169_2.png) [@Sanif\_Sentosa](https://forum.manager.io/u/Sanif_Sentosa)\ **Post date:** [July 9, 2020, 2:05pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/7 "2020-07-09T14:05:33Z")
> ![41%20AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/8/888a33f6a9e384053a3f6eeb150320585c884f46.png) Actually I was referring to this setting in the Custom Report, it’s the old version, so what are the equivalent settings for the new Custom Report? Thank you ---
**Author:** ![Sanif\_Sentosa](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sanif_sentosa/32/24169_2.png) [@Sanif\_Sentosa](https://forum.manager.io/u/Sanif_Sentosa)\ **Post date:** [July 9, 2020, 2:15pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/8 "2020-07-09T14:15:18Z")
I was trying to make the following report: ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/6/361b03e601a204f8c655a343d5d3812b7671d9ec.png) The Sales Invoice Totals by Customer is good enough but lack of details, it’s just show the total of each customer, which is can be easily seen in the Customer menu. ---
**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:** [July 9, 2020, 4:11pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/9 "2020-07-09T16:11:48Z")
> [@Sanif\_Sentosa](#): > > how do I limit / filter the report to just only showing one instead of two? By filtering for the desired account, such as _Inventory - sales_, for one posting from each transaction. ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [July 9, 2020, 5:08pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/10 "2020-07-09T17:08:59Z")
> [@Sanif\_Sentosa](#): > > so how do I limit / filter the report to just only showing one instead of two? Where General Ledger Account - isAccountRecivable - is not checked ---
**Author:** ![Sanif\_Sentosa](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sanif_sentosa/32/24169_2.png) [@Sanif\_Sentosa](https://forum.manager.io/u/Sanif_Sentosa)\ **Post date:** [July 10, 2020, 2:08am UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/11 "2020-07-10T02:08:23Z")
> Where General Ledger Account - isAccountRecivable - is not checked to be exact is Where General Ledger Account \> IsInventoryOnHand \> is not checked. Anyway thanks for the heads up. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/8/a8feba9efb2f17ddec670c59c80aab61e4d5405c.png) With this I’m closest to what I need, but I can’t get the amount for the Sales Invoice, not the Inventory Item price. Any idea? Thank you ---
**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:54pm UTC](https://forum.manager.io/t/sales-invoice-by-date-range-with-details-items/21175/12 "2023-01-18T14:54:53Z")