Business Central Tables and Fields Information

In Dynamics 365 Business Central (BC), while you are on a window or a section of a window, you can display table and field information related to that window by selecting Inspect pages and data. There are a few ways to find the table and fields:

• Select “?”
• Select “Help & Support”
• Select “Inspect Pages and data”

Page Inspection will display table and field data related to the page (and section) that you are displaying & have selected.

Also, table information can be found in Business Central by searching for:

• Configuration Worksheet
• Table Information can be filtered and exported to Excel.

Jet Reports Browser

In Jet Reports, the Browser can be used to view table and field information. Select  “Show Details” to see more information about the selected tables and fields. As you can see in the following, the Jet Browser Details show the same information as the Business Central Page Inspection, above.

In the table details, view the table number, drill down to view table data and view Keys.

View field details and sample values.

Additional Jet Browser Features include the Drilldown to view table data from Business Central. Also, use the ability to drag and drop selected fields from the Browser into your report.  Use Rows and Records Drag & Drop Output to define the dropped field formulae.

For more information about Jet Reports and to see if it is the right fit for your company, contact Support@BondConsultingServices.com or Schedule a Free Consultation with one of our experts here.