How to get the total of products in all warehouses in a location of type "View"?

102 views
Skip to first unread message

Fabyc

unread,
Oct 27, 2015, 4:11:31 PM10/27/15
to tryton
Hi.

I would like to know how can I get the total of products there are in all warehouses?

I tried this solution [1] but in the new location of type "View" only shows "0" products. 
This new location is parent of all the warehouses.


Thanks in advanced

--
Regards

Cédric Krier

unread,
Oct 29, 2015, 4:40:04 AM10/29/15
to tryton
On 2015-10-27 13:11, Fabyc wrote:
> Hi.
>
> I would like to know how can I get the total of products there are in all
> warehouses?
>
> I tried this solution [1] but in the new location of type "View" only shows
> "0" products.
> This new location is parent of all the warehouses.

This is strange. Is the warehouse has quantities?
Could you check if the MPTT (left, right) are correct? If not the simple
way to fix them is to update the database against stock module.

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

Fabyc

unread,
Oct 29, 2015, 10:25:13 AM10/29/15
to tryton
On Thursday, October 29, 2015 at 3:40:04 AM UTC-5, Cédric Krier wrote:
On 2015-10-27 13:11, Fabyc wrote:
> Hi.
>
> I would like to know how can I get the total of products there are in all
> warehouses?
>
> I tried this solution [1] but in the new location of type "View" only shows
> "0" products.
> This new location is parent of all the warehouses.

This is strange. Is the warehouse has quantities?

Yes, it has. You can see in the images the data I have for testing [1] [2] [3]. The 
location of type view displays "0".
 

Could you check if the MPTT (left, right) are correct?

I did it and it is OK.
 
If not the simple
way to fix them is to update the database against stock module.

I did it and I still have the problem.

Thanks

--
Best regards

Jesús Martín Jiménez

unread,
Oct 29, 2015, 11:27:21 AM10/29/15
to try...@googlegroups.com
2015-10-29 15:25 GMT+01:00 Fabyc <fabi...@gmail.com>:
On Thursday, October 29, 2015 at 3:40:04 AM UTC-5, Cédric Krier wrote:
On 2015-10-27 13:11, Fabyc wrote:
> Hi.
>
> I would like to know how can I get the total of products there are in all
> warehouses?
>
> I tried this solution [1] but in the new location of type "View" only shows
> "0" products.
> This new location is parent of all the warehouses.

This is strange. Is the warehouse has quantities?

Yes, it has. You can see in the images the data I have for testing [1] [2] [3]. The 
location of type view displays "0".
 

Maybe your are adding products of custormer and provider warehouses, and then, it is correct.
 

Could you check if the MPTT (left, right) are correct?

I did it and it is OK.
 
If not the simple
way to fix them is to update the database against stock module.

I did it and I still have the problem.

Thanks

--
Best regards
 

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/



--

Jesús Martín

Zikzakmedia SL
C/ de Sant Jaume, 9, baixos, 2ª
08720 Vilafranca del Penedès
☏ 93 890 21 08

Cédric Krier

unread,
Oct 29, 2015, 12:00:05 PM10/29/15
to try...@googlegroups.com
On 2015-10-29 16:27, Jesús Martín Jiménez wrote:
> 2015-10-29 15:25 GMT+01:00 Fabyc <fabi...@gmail.com>:
>
> > On Thursday, October 29, 2015 at 3:40:04 AM UTC-5, Cédric Krier wrote:
> >
> >> On 2015-10-27 13:11, Fabyc wrote:
> >> > Hi.
> >> >
> >> > I would like to know how can I get the total of products there are in
> >> all
> >> > warehouses?
> >> >
> >> > I tried this solution [1] but in the new location of type "View" only
> >> shows
> >> > "0" products.
> >> > This new location is parent of all the warehouses.
> >>
> >> This is strange. Is the warehouse has quantities?
> >>
> >
> > Yes, it has. You can see in the images the data I have for testing [1] [2]
> > [3]. The
> > location of type view displays "0".
> >
> > [1] http://s28.postimg.org/jcwmf28pp/01_locations.jpg
> > [2] http://s16.postimg.org/4biubhmed/02_products_by_locations.jpg
> > [3] http://s2.postimg.org/53dzejx21/03_product_by_locations.jpg
> >
>
> Maybe your are adding products of custormer and provider warehouses, and
> then, it is correct.

Of course, stock is a double entry accounting so at the top of the tree
there is no quantity.

@fabian put only the warehouse under the view.

Fabyc

unread,
Oct 29, 2015, 12:04:04 PM10/29/15
to tryton
On Thursday, October 29, 2015 at 10:27:21 AM UTC-5, Jesús Martín Jiménez wrote:


2015-10-29 15:25 GMT+01:00 Fabyc <fabi...@gmail.com>:
On Thursday, October 29, 2015 at 3:40:04 AM UTC-5, Cédric Krier wrote:
On 2015-10-27 13:11, Fabyc wrote:
> Hi.
>
> I would like to know how can I get the total of products there are in all
> warehouses?
>
> I tried this solution [1] but in the new location of type "View" only shows
> "0" products.
> This new location is parent of all the warehouses.

This is strange. Is the warehouse has quantities?

Yes, it has. You can see in the images the data I have for testing [1] [2] [3]. The 
location of type view displays "0".
 

Maybe your are adding products of custormer and provider warehouses, and then, it is correct.

You're right. If those warehouses are included, the total of products is "0". I removed both warehouses 
from Parent View and it displays correctly the total of products. :)

Thank you very much Jesús and Cédric.

--
Best regards
Reply all
Reply to author
Forward
0 new messages