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	Відповіді	Переглядів
How to prevent stock from going negative? stock warehouses locations	1 лип. 15	10909
Change Source Location for Delivery Orders stock warehouses locations delivery	0 жовт. 24	5196
Warehouse name and company_id violation stock warehouses	2 груд. 23	4306
Show on hand in one warehouse stock warehouses	0 груд. 22	1983
Are there specific advantages in setting up multiple warehouses? Вирішено warehouses locations	3 лют. 22	4035

Це запитання позначене

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