Monday, 2 December 2024

Why My Custom Table/Page Isn't Appearing in "Search Company Data" in Business Central – And How to Fix It?

If you've ever added a custom table/Page in Microsoft Dynamics 365 Business Central and found that it doesn't show up in the "Search Company Data" feature to enable, you're not alone. This post will explain why this happens and how to fix it with a simple solution.


The Problem: Custom Table/Page Missing in "Search Company Data"

The "Search Company Data" feature allows users to search across various tables in Business Central. However, if your custom table or page isn’t configured correctly, it won’t appear in the “Enable lists for searching”. This can be frustrating.

Symptoms:

  • Your custom table or page does not appear in the “Enable lists for searching”.
  • Other standard tables/pages show up as expected.
  • You can still manually navigate to your custom table or page, but not through "Search Company Data".

Root Cause: Missing “LookupPageId” Property

In Business Central, tables need to have a LookupPageId property defined to be searchable through the "Search Company Data" feature.

If this property is not set, the system cannot determine how to present the table’s data in the search results, hence excluding it.


The Solution: Setting the LookupPageId Property

To resolve this issue, you need to set the LookupPageId property in your custom table.





Conclusion

By simply setting the LookupPageId property, you ensure your custom table/page is visible in the “Enable lists for searching” list.