Inventory by Location

(6) Share

Report

Posted on by JE-20081519-0

3,789

Hi:

We need to know about an inventory item at an intransit location.

What's a good report to generate for items by location in Business Central without having to install and configure Power BI?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Suggested answer

Holly Huffman 6,554 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
Good morning, afternoon, or evening :) depending on your location!

For inventory items at an in-transit location in Business Central, you can use the Inventory - Transaction Detail report. This report provides insights into inventory movements, including stock transfers, purchases, and sales, for specific items and locations. Here's how you can access it:

Navigate to Reports:

Go to Role Explorer in Business Central.

Under the Inventory section, select Inventory - Transaction Detail.

Filter by Location:

Apply filters to focus on the in-transit location and the specific inventory item you're interested in.

Generate the Report:

Run the report to view detailed transaction data for the selected item and location.

This report is built into Business Central, so you don't need Power BI to access it.

Hope this helps!

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,304 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

One option is to go to Items page.

Set Location Filter to the intransit location and the Inventory column will change to intransit inventory.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,857 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: How to quickly check inventory quantity for locations at Item-Variant level (Variant inventory per location)

https://yzhums.com/54104/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,829 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello,

In Business Central, you can use the Inventory - Transaction Detail report to get information about inventory items at an in-transit location.

This report provides detailed insights into inventory movements, including stock transfers, purchases, and sales for specific items and locations.

You can access it through the Role Explorer under the Inventory section and apply filters to focus on the in-transit location.

https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-wms-reports

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,287 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Please check this: https://valentincastravet.com/4-ways-to-view-how-much-inventory-you-have-in-dynamics-365-business-central/

https://www.youtube.com/watch?v=YOllUcuEXbA

https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-availability-overview

Was this reply helpful? Yes No
Verified answer

Khushbu Rajvi. 22,287 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Check if this report helps: 705 - Inventory availibility. & 10139: Inventory Valuation

If you need something more specific or simplified, creating a custom report with item and location filters on the request page is a quick and flexible solution—no need for Power BI setup.

Inventory Availability

Inventory Valuation

Was this reply helpful? Yes No
Gerardo Rentería Ga... 26,082 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

How to check item availability by location in Business Central

4 Ways to View How Much Inventory You Have in Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Best Regards
Gerardo

Was this reply helpful? Yes No