Analyze inventory by location report

(6) Share

Report

Posted on by giovanni79

211

I just stumble on an interesting report under Inventory and Warehouse -> Inventory -> Reports called "Analyze Inventory by Location" (or inventory by location analysis) that actually has variants! Is this report new?

This report seems very useful, but there are a couple of columns that I don't quite understand. For example, some products in the same inventory location are tagged with different countries and I am not sure where this country comes from (this columns is different from the Location Country/Region).

Also, not sure about the Quantity column, as the quantity I have in the item availability by event is equal to the Remaining Quantity column (or the sum of the countries in that column for each item and variant).

I searched for the documentation on Microsoft learn, but I don't seem to find anything related to this report, can anyone point me in the right direction?

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Nitin Verma 21,794 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you share some screenshot? becuase I have not found such report available in Standard BC except the page "Inventory by location"

Might be the custom report you are looking at.

Thanks.

Was this reply helpful? Yes No
giovanni79 211 on at

Like (1)

Report
Copy link

Link copied!

Hi Nitin,

See attached screenshots of how I access the report and a sample report. The report seems available for another environment that shouldn't have any customizations.

Was this reply helpful? Yes No
giovanni79 211 on at

Like (1)

Report
Copy link

Link copied!

I double checked and the report is available for the environment without customizations. However, I did install the Finance Power BI reports on both environments, could the report come from that?

Was this reply helpful? Yes No
Verified answer

Dhiren Nagar 2,898 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You are correct this is a new one. However this is a query and the link is added in the report section. You can find it in the base application.

Also it is taking data directly from Item ledger entry and location master. So Ideally if you would compare your ILE and this report it would match.

As regards to location, it comes from Purchase Invoice from Vendor into Item ledger entry and then in this report. Or Sales Return shipment comes from Customer and transfers comes from Locations. There is one more column Location country/region that is from location card.

You can check the design here - https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/query/inventory-by-location

Regards,

Dhiren.

Was this reply helpful? Yes No
giovanni79 211 on at

Like (1)

Report
Copy link

Link copied!

Thank you for your answer. This query will be very helpful indeed, glad to see variants get more visibility in the system.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
Copy link

Link copied!
Below is the standard code, which hopefully will give you some hints. This data mainly comes from Item Ledger Entries and Location.

// ------------------------------------------------------------------------------------------------ // Copyright (c) Microsoft Corporation. All rights reserved. // Licensed under the MIT License. See License.txt in the project root for license information. // ------------------------------------------------------------------------------------------------ #pragma warning disable AA0247 query 37015 "Inventory by Location" { QueryType = Normal; DataAccessIntent = ReadOnly; UsageCategory = ReportsAndAnalysis; Caption = 'Inventory by Location Analysis'; AboutTitle = 'About Inventory by Location Analysis'; AboutText = 'The Inventory by Location Analysis is a query that joins data from item ledger entries with location master data.'; elements { dataitem(ItemLedgerEntry; "Item Ledger Entry") { DataItemTableFilter = Open = const(true); column(ItemNo; "Item No.") { Caption = 'Item No.'; } column(VariantCode; "Variant Code") { Caption = 'Variant Code'; } column(LotNo; "Lot No.") { Caption = 'Lot No.'; } column(SerialNo; "Serial No.") { Caption = 'Serial No.'; } column(PackageNo; "Package No.") { Caption = 'Package No.'; } column(ExpirationDate; "Expiration Date") { Caption = 'Expiration Date'; } column(UnitOfMeasureCode; "Unit of Measure Code") { Caption = 'Unit of Measure Code'; } column(QtyPerUnitOfMeasure; "Qty. per Unit of Measure") { Caption = 'Qty. per Unit of Measure'; } column(Quantity; Quantity) { Caption = 'Quantity'; Method = Sum; } column(RemainingQuantity; "Remaining Quantity") { Caption = 'Remaining Quantity'; Method = Sum; } column(ReservedQuantity; "Reserved Quantity") { Caption = 'Reserved Quantity'; Method = Sum; } column(CountryRegionCode; "Country/Region Code") { Caption = 'Country/Region Code'; } dataitem(Location; Location) { DataItemLink = Code = ItemLedgerEntry."Location Code"; column(LocationCode; Code) { Caption = 'Location Code'; } column(LocationName; Name) { Caption = 'Location Name'; } column(LocationCity; City) { Caption = 'Location City'; } column(LocationCounty; County) { Caption = 'Location County'; } column(LocationCountryRegionCode; "Country/Region Code") { Caption = 'Location Country/Region Code'; } } } } }

Was this reply helpful? Yes No