How to Export "Items by Location Matrix"?

(1) Share

Report

Posted on by BCgs

470

Under items you can view the "Items by Location Matrix" which is great, however pretty useless as you can't export all of the data.

This is exactly what i want a big export of all of the SKU's Names & Locations with Quantities - however no "open in excel" or export function which is really frustrating.

Or is there another way to get a report of the stock in a specific warehouse?

Thanks in advance!

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

BCgs 470 on at

Like (2)

Report

Actually i have found it there is another option below called "items by location" and you can export a full list from that as SKU + Description + Location + Quantity

Was this reply helpful? Yes No
Andy Sather on at

Like (0)

Report

Thank you for posting this to the community.

Was this reply helpful? Yes No
benovic 350 on at

Like (0)

Report

thats a great find, thanks! i just came across this and your screenshot helped!

did you by any chance discover how to get there, usind a menu item or a direct url?

Was this reply helpful? Yes No
BCgs 470 on at

Like (0)

Report

Just referred back to this as I was struggling to find again!

Just done an inspection on the page and the page query is "Items By Location (2554)"

So the direct URL is something like this (replacing company name)

/production?company=COMPANYNAME&page=2554&datasourcetype=Query&dc=0

Was this reply helpful? Yes No
BCgs 470 on at

Like (0)

Report

Just noticed on the most recent update (v19) the option to be able to export to excel has gone from the "Items By Location" which is really frustrating as i don't get why things are going backwards?

I have noticed it had moved to this section within items for example (as opposed to being on the menu) however this means it has been completely removed from pages like the "Items By Location"? Why on earth are good features being removed, this is a pretty fundamental feature to be able to do a quick export of stock within a location to excel?

The only workaround i can think at the moment is somehow import data like this via the web services into a tab in an excel sheet?

Was this reply helpful? Yes No
BCgs 470 on at

Like (0)

Report

Actually it now looks like that "Items by Location" is now depreciated as you can now use a "Location Filter" directly on the item section and then Open/Edit in excel or share to teams

So that would be the cleanest solution to export a list of stock from a specific location and can now be done within the item section.

Was this reply helpful? Yes No