# Report Showing Different Purchasing Value of an inventory Item

**URL:** <https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955>\
**Category:** Uncategorized\
**Created:** [March 22, 2021, 7:52am UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955 "2021-03-22T07:52:47Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 22, 2021, 7:52am UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/1 "2021-03-22T07:52:47Z")

</div>

Hello There  
is there a way to show Different Purchasing Values & quantities of an inventory Item in each purchase invoice in one single report ?

---

<div class="post-metadata">

**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 22, 2021, 12:48pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/2 "2021-03-22T12:48:25Z")

</div>

The easiest way to obtain that information is to drill down on the average cost column in the Inventory Items tab. Then search for transaction type, copy to clipboard, and paste into a spreadsheet. Otherwise, design a custom report.

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 22, 2021, 1:08pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/3 "2021-03-22T13:08:53Z")

</div>

Average cost is not clickable , also it shows me the purchase invoices where this item has been purchased not the price inside , so i have to view each invoice to check the prices

I couldnt reach a custom report to make it happen …

---

<div class="post-metadata">

**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 22, 2021, 1:42pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/4 "2021-03-22T13:42:25Z")

</div>

My mistake, @Mark_Tatossian. It is the `Total cost` column.

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 22, 2021, 2:14pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/5 "2021-03-22T14:14:48Z")

</div>

I see !

Thanks a lot 🙂

Now , may i know why when making a custom report , why alwyas lines are doubld as credit / debit

I make a custom report for Sales invoice with total amount , and customers name , address & phone , so what i choose is customer name , credit , address & phone  
It always doubles the result

---

<div class="post-metadata">

**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 22, 2021, 2:54pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/6 "2021-03-22T14:54:16Z")

</div>

Because Manager is a double entry accounting system. You need to filter for debits or credits, or for a specific account.

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 24, 2021, 10:57am UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/7 "2021-03-24T10:57:07Z")

</div>

I already choose Credit , but still no issues  
can u give me an hint how to ?

---

<div class="post-metadata">

**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:** [March 24, 2021, 10:59am UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/8 "2021-03-24T10:59:06Z")

</div>

Please post an edit screen image of your custom report

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 24, 2021, 11:28am UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/9 "2021-03-24T11:28:15Z")

</div>

![SS](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/8/f8b162c6fa0c953633b4926b87959eb1204bf8c9.jpeg)

---

<div class="post-metadata">

**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:** [March 24, 2021, 12:08pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/10 "2021-03-24T12:08:17Z")

</div>

You need to add a line in the Where section to only select one of two lines  
.  
For example select a particular account

Add the account to the Select section so that you can see which one to select.

You can remove it once you are happy with the final result

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 24, 2021, 1:19pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/11 "2021-03-24T13:19:53Z")

</div>

Its not working …

---

<div class="post-metadata">

**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:** [March 24, 2021, 1:23pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/12 "2021-03-24T13:23:44Z")

</div>

What’s not working?

I can not see your screen so I little or no idea of what you mean by “It’s not working”

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 24, 2021, 1:36pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/13 "2021-03-24T13:36:44Z")

</div>

The hint you told me gave me multiple not needed extra lines …

Well , I will let you know the report i need , may be its easier to let me know what to choose

I need the report to show , Customer , Adress , Phone Number , Custom Field & Sales Invoice Amount on specific date

---

<div class="post-metadata">

**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:** [March 24, 2021, 1:50pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/14 "2021-03-24T13:50:48Z")

</div>

No that is not easier

I need to **see** what you have put into your report edit screen and a copy of the first few lines of the report

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 24, 2021, 2:04pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/15 "2021-03-24T14:04:13Z")

</div>

![11](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/9/39effc9ee0b3fbfc53eea511e184d67616d28eab.jpeg) ![222](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/e/8ec6caad929ce468f0025f03869c475246e6e53f.jpeg)

Lines are always duplicated , one with an amount , the other without

---

<div class="post-metadata">

**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:** [March 24, 2021, 2:07pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/16 "2021-03-24T14:07:16Z")

</div>

You need to add a line into Select group with the Account

You need to unlock the Group by and show me the result

As accounting is a double entry process it is normal to have two entries

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 24, 2021, 2:11pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/17 "2021-03-24T14:11:29Z")

</div>

![33333](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/b/ab808a7a9a5dc64d69758cc8b479f51c374795cd.jpeg)

I Check the Group by to group customers by AREA , but for now i uncheck it for you

All i want now is to hide Account Receivable line

---

<div class="post-metadata">

**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:** [March 24, 2021, 2:16pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/18 "2021-03-24T14:16:42Z")

</div>

Thank you

Now add a line into the Where section with the Account and select the option “contains” Online Boutique

This will select only lines with Online Boutique

Post the result again

---

<div class="post-metadata">

**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:** [March 24, 2021, 2:18pm UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/19 "2021-03-24T14:18:19Z")

</div>

If that is good, you can remove the line Account from the Select section and reselect the Group By

It is always easier to add many columns in the Select section to start with a d which ones you need to use in the Where section

You can always remove them from the Select section once you have got what you want

---

<div class="post-metadata">

**Author:** ![Mark\_Tatossian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mark_tatossian/32/15424_2.png) [@Mark\_Tatossian](https://forum.manager.io/u/Mark_Tatossian)\
**Post date:** [March 25, 2021, 10:34am UTC](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955/20 "2021-03-25T10:34:41Z")

</div>

Thanks a million !!!  
It worked great 🙂

[Next page](https://forum.manager.io/t/report-showing-different-purchasing-value-of-an-inventory-item/33955.md?page=2)
