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

Announcements

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 4,005
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,306 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
    101,995 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
    17,024 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,818 Super User 2026 Season 1 on at
  • Verified answer
    Khushbu Rajvi. Profile Picture
    22,818 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
    27,280 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May 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,869 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,182 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,109 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans