Knowing your Business Central data using the Page Inspection

With the promotion of Microsoft’s ERP Dynamics NAV as the only SMB Microsoft ERP in the cloud, the community gained a significant number of new users coming from other products.

Introduction of Cloud Migration feature or Data Migration in Business Central allowed delivery teams in the Partners space to bring in BC SaaS many end-users from Dynamics GP or SL, as well as from other non-Microsoft ERPs, like QuickBooks.

Those that consider themselves new to Business Central might find difficult to navigate and find what they need in their daily work with the new ERP.

This is when knowing about the Page Inspection page comes handy.

To enable the Page Inspection pane, you can use these keys:

  • CTRL + ALT + F1
  • navigating to “?” on the top right corner -> click on Help and Support -> look for “Inspect Pages and Data” link:

Once enabled, Page Inspection appears as a vertical frame in the browser window and allows users to see the components of each page.

Click on various page components and notice how the Page Inspection updates. Look for:

  • the fields included in that component
  • the extensions that touched the current page/component
  • existing filters for that component/page

Example:

Enabling Page Inspection on the Business Manager Role Center and selecting the frame in the middle uncovers valuable information:

The frame is actually a Card Page based on a BC table “Activities Cue” and the card page itself is Page 1310 “O365 Activities”.

Some users might ask:

  1. What are the records stored in this table?

For seeing the records there are a few options:

In the page inspection pane, click on “View Table” link:

This will open up the default page for table 1313

  • Another way of displaying all records in a table is to go to Table Information page, Search for table 1313, and click on the flow field “No. Of Records”
  • Ultimately, the users can run the table from the URL. Copy the link up to and inluding the environment name (in my example below, include everything up to “Production” then add “/?table=1313”

2. What data is available for each record?

There are three Tabs at the top:

  • Table Fields
    • use the magnifying loop(under Page Filters) to filter the fields by name or value
    • not all fields available in the table are displayed on the page. You can try to Personalize your page or ask your Partner to help you. To enable a field for all users within one profile you might want to ask your admin to customize the page.
  • Extensions
    • Custom code affects tables and pages. You can easily see what extensions have touched the current table/page

Note: you can easily detect which fields belong to which extension as new extensions need to include a suffix or prefix for each field/action/page/table.

  • Page Filter: filters are often used to display the data in Business Central. This tab gives good clues into how the data has been filtered:

If you do not see the details you’re expecting to see in the Page Inspection page, you probably do not have the right permission. Talk to your admin and ask them to give you D365 Troubleshoot permission set or user group.

For some Microsoft official documentation on the Page Inspection read this.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s