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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Reg. Add field to Loca...
Microsoft Dynamics NAV (Archived)

Reg. Add field to Location code in item by location MAtrix form

(0) ShareShare
ReportReport
Posted on by bharathkarunakaran 475

Hi guys,

Can anyone suggest me how to add a new location that i have created in the Item by location form and i also want to remove the unused location in that form.

Please advice.

Warm Regards,

Bharath K

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Bharath,

    If you have created a location then it will show up in the Items By Location, there is no specific setup to create one in that page. If you running an issue, please share more details and screenshot

  • bharathkarunakaran Profile Picture
    bharathkarunakaran 475 on at

    Thanks Suresh,

    Can you Suggest me how to hide the unused locations in the item by location card.

    Please advice.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    I don't think there is a standard way to hide, you need to customize. But try setting the In-Transit on the Location card and see if that hides it, if not you need to customize.

  • bharathkarunakaran Profile Picture
    bharathkarunakaran 475 on at

    Thanks suresh,

    I have tried that,

    But i need to do that by code.

    I have created a boolean field in location card and whenever i click that it should be blocked or hidden.

    Can you suggest some steps for that.

    Warm Regards

    Bharath K

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Add the boolean called Hidden and then in the table Location there is a function called GetLocationsIncludingUnspecifiedLocation in that add your filter to show only locations where hidden is False.

    Before IF Location.FINDSET THEN statement in that function add the filter

    Location.SETRANGE(Hidden,FALSE);

  • bharathkarunakaran Profile Picture
    bharathkarunakaran 475 on at

    2018_2D00_06_2D00_04-17_5F00_57_5F00_43_2D00_CRONUS-USA_2C00_-Inc.-_2D00_-Microsoft-Dynamics-NAV-Classic-_2D00_-_5B00_Table-14-Location-_2D00_-C_5F00_AL-Ed.png

    Hi suresh,

    Thanks for your reply,

    I have tried what you have suggest in the above steps,but it doesn't seem to work.I have attached the screenshot of what i have done.

    Please advice.

    Regards,

    Bharath

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    That is not the function I have referred. Check the function it is calling in the items by location page.

  • bharathkarunakaran Profile Picture
    bharathkarunakaran 475 on at

    I couldn't find any function like that.

    I am using nav 2009 r2.

    bharath

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Open the Page/Form Items By Location and check which function it is calling in the OnInit Trigger

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans