# Custom report for inventory sales and purchase price

**URL:** <https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207>\
**Category:** Uncategorized\
**Created:** [July 21, 2021, 11:41am UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207 "2021-07-21T11:41:29Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 11:41am UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/1 "2021-07-21T11:41:29Z")

</div>

hello,  
i have create custom report but i problem on sales and purchase price amount issue  
check this screen shot

1. custom report creation for issue in inventory purchase price inventory sales price

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/d/2d4829b9feb9183e2ff7dd67ac3261e78e274029.png)

its purhcase price is 21000 and sales price is 33000  
but report shown 42000 and 66000 why can display double amount  
also cant show average cost filed available

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/5/258442e6c94b7f849cad806b73a2879b590b5156.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/2/628769173bd718d3638b6ad06ba11ad862469161.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/d/cd78b645b2c3596010e37091229e215a00abcef6.png)

another hightlite sv805 and sv 806 is showing correct amount  
what is issue please fix my problem

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 21, 2021, 12:02pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/2 "2021-07-21T12:02:39Z")

</div>

During development show more data about each item in the general ledger (which is what custom reports show).

In particular at least show the general ledger account name. For more details see the start of this post [Custom Report Not Returning Transaction Type Properly - #12 by Patch](https://forum.manager.io/t/custom-report-not-returning-transaction-type-properly/33737/12)

The most likely reason to show double the expected amount is Manager is a double entry accounting system so everything is entered twice.

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 12:10pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/3 "2021-07-21T12:10:53Z")

</div>

but its just normal inventroy item  
with sales and purchase price

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 21, 2021, 12:14pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/4 "2021-07-21T12:14:51Z")

</div>

It is a normal double entry accounting transaction so it is entered twice in the general ledger.

Show more information on each transaction and the answers will make more sense.

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 12:15pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/5 "2021-07-21T12:15:48Z")

</div>

ok but how can correct my report any way ?

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 21, 2021, 12:23pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/6 "2021-07-21T12:23:28Z")

</div>

1. Show the details as suggested
2. Filter the part of the general ledger you actually want in your report by adding where clauses

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 21, 2021, 12:30pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/7 "2021-07-21T12:30:51Z")

</div>

> [@On another topic](https://forum.manager.io/t/36208/1):
>
> please help me i already did multiple find way …but same issue

You have to do step 1 before you can do step 2

By the way  
Programming is a bit like doing a crossword. No one just writes out the crossword answer, it is solved by doing the easy bits and seeing what that tells you.

Step 1. above is information gathering. Use Manager “Select…” section to show you what is actually happening.

The step 2. us choose what you actually want to see using Manager’ “Where …” section.

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 12:38pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/8 "2021-07-21T12:38:10Z")

</div>

i cant understand

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 21, 2021, 12:46pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/9 "2021-07-21T12:46:30Z")

</div>

That is because you are asking the wrong question.

- You are asking what is the answer.

- You need ask your self, how could I find out what I need to know to work out the answer.

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 12:51pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/10 "2021-07-21T12:51:45Z")

</div>

bro i display every thing on first post  
its showing wrong record show…just show my mistake

---

<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:** [July 21, 2021, 1:37pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/11 "2021-07-21T13:37:13Z")

</div>

Remove the **Group by** bit of your custom report and you will see quickly enough

You can put it back when you have corrected the select

---

<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:** [July 21, 2021, 1:38pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/12 "2021-07-21T13:38:56Z")

</div>

@hussainiii, let me try to explain what @Patch is telling you a different way. You are confused by what shows in your custom report. But you have no idea where the information is coming from. @Patch is suggesting that you add the general ledger account name to your Select criteria. That will tell you what general ledger transaction you are seeing on each line. Once you know that, you can use Where filters to exclude the accounts whose transactions you do not want to see.

For example, a simple sales invoice involving an inventory item will post transactions to:

- _Inventory - sales_
- _Inventory - cost_
- _inventory on hand_
- _Accounts receivable_

A purchase invoice will post transactions to:

- _Inventory on hand_
- _Accounts payable_

Your current custom report design will show all of those. Depending on the purpose for your report, it is doubtful you want to see all of those postings. So you must exclude the ones you don’t want. After you have determined the necessary filters (the Where entries), you can remove the unwanted columns from the report.

> [@hussainiii](#):
>
> also cant show average cost filed available

Average cost is not a field in general ledger transaction records. It is something calculated and displayed in the inventory item ledgers. So you will not get it in a custom report.

Also, the sales price and purchase price fields you have selected are unrelated to any actual sales or purchases. Those are just the default values you defined for the inventory items.

@Joe91 also offers good advice. You are trying to do everything at once, before you understand what the program is returning in your custom report. Grouping is the last thing you should add.

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 2:53pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/13 "2021-07-21T14:53:47Z")

</div>

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/5/258f552481bbf57eae703c115b2bb4c1295d2792.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/a/9a352111271999e9e3c887da0ba63bbeda9468d9.png)

ok will filtter description is not empty  
but i how can show prurhcase price its caluted price shown

---

<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:** [July 21, 2021, 2:59pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/14 "2021-07-21T14:59:35Z")

</div>

> [@hussainiii](#):
>
> ok will filtter description is not empty  
> but i how can show prurhcase price its caluted price shown

I do not understand either statement/question. (I do not know whether you are asking or telling.) And what information are you actually trying obtain?

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 3:25pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/15 "2021-07-21T15:25:05Z")

</div>

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/4/441706961a9bcee2235c3ffb4e535a5fbd03807e.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/f/7f8806bac0882a6d33adf6d7f2c94312f8985557.png)

now what can i do please suggest

if i remove transaction in select same result shown

![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/9/b9e6a21365cdc20426c929ca577b0b9e1a4b65cc.png)

---

<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:** [July 21, 2021, 3:28pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/16 "2021-07-21T15:28:26Z")

</div>

As Tut said, it isn’t clear what exactly you are trying to get a report on.

And have you looked at the built-in reports?

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 3:29pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/17 "2021-07-21T15:29:38Z")

</div>

not availble in buitlin report

just need

item code , item name , Purchase price , sales price and qty in hand

---

<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:** [July 21, 2021, 3:35pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/18 "2021-07-21T15:35:43Z")

</div>

Just copy the information in your inventory tab to the clipboard, import it to Excel and delete the columns you don’t want

---

<div class="post-metadata">

**Author:** ![hussainiii](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hussainiii](https://forum.manager.io/u/hussainiii)\
**Post date:** [July 21, 2021, 3:36pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/19 "2021-07-21T15:36:43Z")

</div>

this is not a solution  
i need report via custom report

---

<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:** [July 21, 2021, 3:40pm UTC](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207/20 "2021-07-21T15:40:01Z")

</div>

The custom report can only read transactions not the master file so I do not think that you will be able to get this information from a custom report, sorry

[Next page](https://forum.manager.io/t/custom-report-for-inventory-sales-and-purchase-price/36207.md?page=2)
