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...
Answered

Hide Inactive Locations / Customers in Lists and Drop Downs

(1) ShareShare
ReportReport
Posted on by 24
Hello! 
 
My company's business model is complex and we consign goods to many store locations. This led to our developer to use both "Customers" and "Locations" as a means of managing all of our stores that hold or have held at some point inventory. Over the years many of these locations are now inactive, however the store/location/customers lists are full of these inactive stores. Unfortunately we cannot just delete these old locations due to sales and transfer history. 
 
Is it possible to hide these inactive locations by means of a filter that works in reducing the store/locations/customers lists in Business Central 365 as well as the associated drop downs where these lists are being called up from?
 
Thanks so much!
I have the same question (0)
  • Verified answer
    Valentin Castravet Profile Picture
    32,157 Super User 2026 Season 1 on at
    Out of the box there's no functionality that does this. However, you have several options regarding locations:
     
    1. If these location codes don't have any inventory, you can delete the location card. The historical information will still remain in all the ledgers and display the corresponding location code, its just the location card itself that is deleted. 
     
    2. You can use security filters in permission sets to hide these inactive locations.
     
    3. You can rename these locations to add a Z, ZZ, or ZZZ at the beginning of the location code, this way you know they're inactive and will sit at the bottom of the location list. 
     
    4. You can create a customization that adds a blocked field to the location card. Then you can add a filter to the location dropdown to not show any blocked locations.
     
    Regarding customers, there is also no out of the box solution as well. You can block them on the customer card and then either hide them using customization, however, you will need to customize quite a few areas of the system. Or, similarly to locations, you can rename them to add a Z at the beginning of the name, or use security filters to hide them. 
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,084 Super User 2026 Season 1 on at
    Just adding some information,
    Security filter: https://yzhums.com/10133/
    Customization: https://yzhums.com/8427/
    Also, Location does not include the block function. . . . You can also submit this idea to Microsoft.
    Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas
     
    Thanks.
    ZHU

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,946 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,177 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans