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...
Suggested Answer

Items by Location Matrix

(0) ShareShare
ReportReport
Posted on by 417

Hi all,

I am running the above Item by location Matrix, but my headers(Locations) are not showing anymore, can settings be reset????? or an I missing something in set up???

Thanks

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    442 on at

    Hi,

    Check two things.

    1. Do you have locations in Location table.

    2. Check by choose columns on the Item by Location Matrix. May be those columns are hidden.

  • marley milo Profile Picture
    417 on at

    Hi, Locations are set up and in the table, if choose columns, it says all available columns are being shown, but they just say Field1, 2, 3, 4 etc not the actual location names, and also the name Field1 does not show as the header

  • Suggested answer
    Bilal Haider Profile Picture
    442 on at

    Hi,

    Please check if you have any customizations on pages 491 or 9231.

  • Suggested answer
    Bilal Haider Profile Picture
    442 on at

    One more thing, check if your locations are marked as Use As InTransit. If yes then you need to checkmark the flag Show Items In-Transit on the Items by location header page to get inventory from those locations.

  • marley milo Profile Picture
    417 on at

    Hi, no customizations, this used to work fine, now all of a sudden the headers do not show

  • Suggested answer
    Community Member Profile Picture
    on at

    Marley,

    Adding to Bilal's reply... So on the Item by Location page, you check the column 'Show Column Name'. This display the literal Name of the Location, not Location Code. Your Column Set should display the Names range and if you click Show Matrix, it will display the Item by Location with Location Names as the column headings.  If this still is not stable, my gut tells me if you have another CRONUS NAV database you can check if the Items by Location works. If yes, have a developer take that report from that database and import into your current database.

    Hope this helps.

    Thanks,

    Steve

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans