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	Replies	Views
How to prevent stock from going negative? stock warehouses locations	1 Jul 15	10911
Change Source Location for Delivery Orders stock warehouses locations delivery	0 Oct 24	5196
Warehouse name and company_id violation stock warehouses	2 Dec 23	4310
Show on hand in one warehouse stock warehouses	0 Dec 22	1985
Are there specific advantages in setting up multiple warehouses? Solved warehouses locations	3 Feb 22	4038

This question has been flagged

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