Skip to Content
0
Former Member
Mar 09, 2009 at 04:00 PM

Inventory Report

14 Views

Hi Guys

I am looking into a report where i will display the cumulative qty of the stock in a single cell and then the actual warehouses that have the stock inside them,so i will for example have a value of 5 in the report but the allocation could be 2 in warehouse 1, 2 in warehouse 2 and 1 in warehouse 1.

How can i concatenate the warehouses so the report displays the 3 warehouses in one cell?

Or how can i get the specific item that i call up to display 3 rows(one per warehouse) with the actual qty in each warehouse?

Thanks