web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Inventory by Location

(6) ShareShare
ReportReport
Posted on by 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
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    6,554 Super User 2026 Season 1 on at
    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:
    1. Navigate to Reports:
      • Go to Role Explorer in Business Central.
      • Under the Inventory section, select Inventory - Transaction Detail.
    2. Filter by Location:
      • Apply filters to focus on the in-transit location and the specific inventory item you're interested in.
    3. 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!
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,304 Super User 2026 Season 1 on at
    One option is to go to Items page.
    Set Location Filter to the intransit location and the Inventory column will change to intransit inventory.
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,857 Super User 2026 Season 1 on at
    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)
     
    Thanks.
    ZHU
  • Suggested answer
    Jainam M. Kothari Profile Picture
    15,829 Super User 2026 Season 1 on at
    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.
     
     
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    22,287 Super User 2026 Season 1 on at
  • Verified answer
    Khushbu Rajvi. Profile Picture
    22,287 Super User 2026 Season 1 on at
    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
     
     
     
     
     
  • Gerardo Rentería García Profile Picture
    26,082 Most Valuable Professional on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,924 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,169 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 734 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans