Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Reg. Add field to Location code in item by location MAtrix form

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

  • bharathkarunakaran Profile Picture
    bharathkarunakaran 475 on at
    RE: Reg. Add field to Location code in item by location MAtrix form

    I couldn't find any function like that.

    I am using nav 2009 r2.

    bharath

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Reg. Add field to Location code in item by location MAtrix form

    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
    RE: Reg. Add field to Location code in item by location MAtrix form

    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 43,745 on at
    RE: Reg. Add field to Location code in item by location MAtrix form

    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
    RE: Reg. Add field to Location code in item by location MAtrix form

    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 43,745 on at
    RE: Reg. Add field to Location code in item by location MAtrix form

    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
    RE: Reg. Add field to Location code in item by location MAtrix form

    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 43,745 on at
    RE: Reg. Add field to Location code in item by location MAtrix form

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans