Create view that shows stock by location

Question

Is it possible to create a tree view that shows the following information:

_______________________________________________________________________

-----------------------------------------------------------------------------------------------------------------------

| 320Gb HDD       | 30.00                     | 22.00                | 9.00                      | 61.00             |

-----------

Mudi Vand · Answer

Hello Jorge, did you try this?

Warehouse -> Configuration -> Locations -> (select the locations from the check boxes) -> Print -> Location Inventory Overview

Or if you want to see the stock distribution of one single product:

Warehouse -> Products -> Products -> (go to the form view of the particular product) -> More -> Stock by Location

Bharat Devnani · Answer

Currently which version you are using ?

If V8, that is possible without customization.

Regards,

Bharat

Ivan · Answer

It would be possible but chalenging as you need to dynamically change your model to adapt to the change in the (number of) Locations.  If you can somehow "fix" the Locations, you might want to try to develop a fix model with cross-tab query view as the source.

Related Posts	Odgovori	Prikazi
How to prevent stock from going negative? stock warehouses locations	1 jul. 15	10909
Change Source Location for Delivery Orders stock warehouses locations delivery	0 okt. 24	5196
Warehouse name and company_id violation stock warehouses	2 dec. 23	4306
Show on hand in one warehouse stock warehouses	0 dec. 22	1984
Are there specific advantages in setting up multiple warehouses? Solved warehouses locations	3 feb. 22	4035

This question has been flagged

Enjoying the discussion? Don't just read, join in!