How do I see what stock I have in a warehouse location?

Afternoon all, I want to see what stock I have in a particular location in the warehouse, anyone know how to do this? There are multiple different parts in the location.

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

You could:
· Go to Inventory – Ware House Maintenance. Select the Warehouse and then highlight the location, select Edit – Location/Parts and this will provide you a complete list of all the parts that can be stored in that location and their current Quantity on Hand.
· If you have actual cost and FIFO by Part Location set in the Application Global Maintenance you could dump the inventory valuation report to a file and then filter for a specific location.
· From the Inventory Transaction Entry you can select Print Transactions, set the sequence to Warehouse/Location, enter the warehouse and location information and set the starting date to before go live and ending date as of today. There will be a list of all transactions per part and total the on-hand for each part.

However, in my opinion all these options stink. I would create a report with the following SQL:

SELECT P.ID, P.DESCRIPTION, P.STOCK_UM, L.WAREHOUSE_ID, L.LOCATION_ID, L.QTY
FROM PART P INNER JOIN
PART_LOCATION L ON P.ID = L.PART_ID
WHERE (L.WAREHOUSE_ID = 'WAREHOUSE') AND (L.LOCATION_ID = 'LOCATION') AND (L.QTY > 0)

This will give you all the parts with a Quantity on Hand for a specific Warehouse ID and Location (as entered in the SQL). Not sure what permissions you have within the system or your knowledge, but this SQL can be run in SQL Server Management Studio if you have backend access or from Admin - Query Tool within Visual.

Hope this helps.

Scott

unknown

Alex,
you can access your warehouse location inventory under materials planning/info/warehouse location. let me know if that helps.

Myrna Bennett

unknown

Myrna,
Wasn’t the question all the parts for a specific location? I thought that Materials Planning/Info/Warehouse Location just like Inventory/Part Maintenance/Info/Location For This Part only provide you with part specific information or is there something I never knew about in the Planning Window?

Scott

unknown

This would be easy with a report writer like Synoptix, which I use. Crystal, SmartView, Query & Analysis (Infor Excel-based ad-hoc report creator) are other options for creating ad-hoc reports like this.

jcrooks

There is a longer way if you don't have ways to create reports with 3rd party programs.

Part Maintenance (all blank fields)>search button at the end of Part ID field.

In the new pop up window:

Data>Edit Columns.

Find and select location i.e Primary/Backflush (depends how your parts are set up, backflush works for me)

Hit OK (check mark in upper left of window)

Select the binoculars and in the field for location type you selected, enter the code/name of the location you want to filter for. Hit OK.

You should now have a filtered list of the parts in that location. You can export to Excel from there and work with it.

Hope that helps

VISUAL Roadmap - July 2020-Seminar Series.pdf

unknown

That method would not necessarily give all the locations holding inventory depending on how they are structured. If you are set up more like a warehouse – having multiple locations holding product – your best bet is option #1 from Scott:
· Go to Inventory – Ware House Maintenance. Select the Warehouse and then highlight the location, select Edit – Location/Parts and this will provide you a complete list of all the parts that can be stored in that location and their current Quantity on Hand.
Or, write a simple report in Crystal or something. It would be very straight forward to make. Let me know if you need help with that.

Whats_New-GLobalFeatures-Workflow-12.0.9.mp4

marvin-schultz

Not sure if this is what you're after, but it's a simple query I wrote that can be run from Admin> Query Tool:

Select pl.part_id, p.description, pl.warehouse_id, pl.location_id, pl.qty from part_location pl, part p where p.id = pl.part_id and pl.qty > 0 and pl.warehouse_id = 'WAREHOUSE' and pl.location_id = 'LOCATION'

unknown

Thanks very much to you all, I'll give them all a go see what works best for me.

Thanks again

Copyright © 2025 Infor. All rights reserved.