Viewing Inventory By Warehouse/Bin Location

Kinetic ERP
1

I’m not finding a “standard” report in Kinetic to view our inventory by bin location. Which is what we would like to be able to do in real time. An overall picture of what we have and where it is at any given moment.

I’m sure this isn’t the first time this has been asked but does anyone have any suggestions for me?

Do I just need to create a simple BAQ to be able to view in a dashboard in real time?

If so, we have (1) Part Class that will be selected for this dashboard
Then:
Part Number
Part Description
Total Inventory On Hand
Qty in each Warehouse
Qty in each Bin Location

2

We went the BAQ route for this as well when we couldn’t find a stock one that met our needs.

image
image1141×483 34.3 KB

You can use the Part On Hand Status dashboard, but it will only get you qty details for a single part at a time.

1 Like
3

Did the same, PartBin table

1 Like
4

We did a BAQ/dash setup too…prompt for partclass and warehouse, rolled up quantities with a bunch of other data points (open SOs, pending POs, firm MFG jobs, forecast, etc).

3 Likes
5

I’m assuming you can sort by bin or by part in the dashboard correct?

6

Correct, all the same functionality as any other dashboard in the system. just click on a column to sort or right click/overflow menu for group by, filter, etc. As lindsayc said above the PartBin table is where you want to start.

1 Like