# Inventory value movement per location

**URL:** <https://forum.manager.io/t/inventory-value-movement-per-location/20888>\
**Category:** ideas\
**Created:** [March 1, 2019, 11:52am UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888 "2019-03-01T11:52:51Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ejjaadiargo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ejjaadiargo/32/50829_2.png) [@ejjaadiargo](https://forum.manager.io/u/ejjaadiargo)\
**Post date:** [March 1, 2019, 11:52am UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/1 "2019-03-01T11:52:51Z")

</div>

can I have report about inventory value movent per location? When I create inventory value movement report only shows value of inventory in comprehensive whereas I need inventory value per location.

---

<div class="post-metadata">

**Author:** ![Drew\_Mike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/drew_mike/32/23586_2.png) [@Drew\_Mike](https://forum.manager.io/u/Drew_Mike)\
**Post date:** [October 25, 2019, 2:38pm UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/2 "2019-10-25T14:38:43Z")

</div>

@lubos I think this is mandatory addition to Manger. What is the use of having inventory location feature, if you can get inventory movement per location, or stock balance per location. Appreciating implementing this addition as soon as possible.

---

<div class="post-metadata">

**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:** [October 26, 2019, 7:04am UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/3 "2019-10-26T07:04:29Z")

</div>

yes, i agreed that  
inventory module needs improvement  
normally, user wants to search by location or quantity  
now it’s not convenience for user if there 1000 + items or multi location  
hope this features will be implemented very soon in Manager

---

<div class="post-metadata">

**Author:** ![Drew\_Mike](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/drew_mike/32/23586_2.png) [@Drew\_Mike](https://forum.manager.io/u/Drew_Mike)\
**Post date:** [March 17, 2021, 8:23pm UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/4 "2021-03-17T20:23:53Z")

</div>

I want to get Inventory movement for one of inventory location. Since there is no report to provide such yet, I would appreciate an assistance to create a custom report that can be as follow:

Column: Inventory Item Name  
Column: Opening balance quantity  
Column: Total quantity in  
Column: Total quantity out  
Column: Closing balance quantity

---

<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:** [March 17, 2021, 8:37pm UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/5 "2021-03-17T20:37:12Z")

</div>

I would be surprised if someone writes a custom report for you. If you really want that service I suggest you hire a local programmer.

On the other hand if you want some help in using Managers custom report writer, then you will need to read the relevant guide, make a reasonable attempt to write your custom report, then post your report definition screenshot, it’s results, and a description of what else you can’t do.

For an approach to starting custom reports see [Custom Report Not Returning Transaction Type Properly - #12 by Patch](https://forum.manager.io/t/custom-report-not-returning-transaction-type-properly/33737/12)

This would best be done in a different thread

Edit  
Actually custom reports in the accounting program Manager, reports on accounting transactions, something which involves money. These all start with general ledger entries, but custom reports can display all linked data.

What you are describing is a database enquiry not starting at an accounting transaction. That is not possible with Manager’s custom reports. It is possible with Manager’s report transformations however they appear to be in a state of change and given the appetite for programming you have displayed, they may not be your thing.

---

<div class="post-metadata">

**Author:** ![WALEEDROSHDY](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/waleedroshdy/32/35544_2.png) [@WALEEDROSHDY](https://forum.manager.io/u/WALEEDROSHDY)\
**Post date:** [October 1, 2021, 7:18pm UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/6 "2021-10-01T19:18:15Z")

</div>

I’m still waiting for that report.  
But not just for stock value.  
For stock value and quantities.

---

<div class="post-metadata">

**Author:** ![sonicgroup](https://avatars.discourse-cdn.com/v4/letter/s/ccd318/32.png) [@sonicgroup](https://forum.manager.io/u/sonicgroup)\
**Post date:** [October 2, 2021, 9:00pm UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/7 "2021-10-02T21:00:02Z")

</div>

> [@Drew\_Mike](#):
>
> want to get Inventory movement for one of inventory location. Since there is no report to provide such yet, I would appreciate an assistance to create a custom report that can be as follow:
> 
> Column: Inventory Item Name  
> Column: Opening balance quantity  
> Column: Total quantity in  
> Column: Total quantity out  
> Column: Closing balance quantity

Good idea 👌. Such a report location wise would be very helpful to track if any inventory item were swapped by mistake to another location when making goods receipt.

---

<div class="post-metadata">

**Author:** ![Najrash](https://avatars.discourse-cdn.com/v4/letter/n/898d66/32.png) [@Najrash](https://forum.manager.io/u/Najrash)\
**Post date:** [August 22, 2024, 11:05am UTC](https://forum.manager.io/t/inventory-value-movement-per-location/20888/8 "2024-08-22T11:05:32Z")

</div>

Nice idea, this will be helpful to the inventory modules for business with many locations
