web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Inventory Valuation by...

Small and medium business | Business Central, N...

Unanswered

Inventory Valuation by warehouse location /zone

(0) Share

Report

Report

Posted on by Phil0867

162

Hi

Is there a way that you can get an inventory valuation for a specific warehouse location/zone? For a particular location/zone I can easily pick up the inventory that is in that location. I am struggling to find how to get a valuation against this. In the item ledger tables I can see the entries that give me the cost details, just by manually comparing quantities and lot numbers, but I do not know the relationship link between the inventory that exists in the warehouse entry table and the costs in the item ledger tables.

Can anyone help with how I can achieve this please?

Thanks

Phil

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

BCgs 470 on at

Like (0)

Report
Copy link

Link copied!

Hi Phil

There is this "items by location" table (you have to be under items to be able to search it) you can filter by location but this does not show and of the pricing details on just the inventory. I usually filter by warehouse > export to excel and then lookup the pricing. Possibly would need to get a developer to modify this table to extend the available data.

Would be interested to know if there was an easier way to do this as this is my current solution and a bit long winded

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,933 Super User 2026 Season 1

#2

YUN ZHU 1,055 Super User 2026 Season 1

#3

Teagen Boll 640 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans