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.

Powiązane posty	Odpowiedzi	Widoki
How to prevent stock from going negative? stock warehouses locations	1 lip 15	10911
Change Source Location for Delivery Orders stock warehouses locations delivery	0 paź 24	5196
Warehouse name and company_id violation stock warehouses	2 gru 23	4310
Show on hand in one warehouse stock warehouses	0 gru 22	1987
Are there specific advantages in setting up multiple warehouses? Rozwiązane warehouses locations	3 lut 22	4041

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!