Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Dude, Where’s My Field? How to Find Your Business Central Tables.


One of the many reasons to use Popdock’s Query Builder for Business Central is the ability to create efficient reports that join multiple tables together. You can join your tables, including all your third-party extensions, into nice single tables that you can use for reporting. We do this by creating extensions for queries on the underlying table data. This is great because you can combine anything, and it’s the fastest way to get real-time data.

However, you may not know exactly what tables your data resides in.

To figure out the underlying table and extension for something you can see on a page, you can utilize D365 Business Central’s “inspect pages and data” feature.

Start by opening your Business Central instance, and click the question mark in the header.



Under troubleshooting, choose “Inspect pages and data.”


This will bring up the inspection pane. Initially, it will show the data from your main section. You can click on other page sections or fact boxes on the page to view data about their fields. In the header of the page inspection sidebar, you will see the source table (if it exists). In the table fields section, you’ll see the fields referenced from the table on the page section. Each field will display its name, value on the page, the extension it originates from, and some other additional information. The name of the table field may not be the same as the name on the page, although it usually is. You can use the combination of the value displayed and the fact the names should be something similar to figure out any differences.



Additionally, when publishing a Query Builder list using third-party extensions or any extensions outside of the base application, you need to manually manage the extension that your reports depend on. If you want to use tables or fields outside the base application, you will need to add the source extensions to your Business Central connector. To add extensions to your connector, sign in to Popdock and edit your Business Central connector. Then, in the extension section, you can add any required extensions.



If you don’t add the extension when you are publishing a new extension for the Business Central sandbox, you will receive an error message like: “Table ‘XXX’ is missing. The source of a Column or Filter must be defined on the table referenced by its parent DataItem. A column must have a valid data source or have the ‘Method’ property set to ‘Count’.”



Here, the ‘XXX’ placeholder signifies the name of a specific table you’re attempting to utilize and you’re making references to columns from a table that isn’t included in the standard application. This is because you haven’t designated the extension as a dependency. So, find the required extensions for the tables you are using, and add them to your connector.

We hope this helps in trying to locate your Business Central tables. If you have any other questions, contact one of our Popdock experts at sales@eonesolutions.com or 888-319-3663 ext. 1.

Leave a Comment





RECENT POSTS


Tech Tuesday: New Clear Field Options in SmartConnect
Join Us in Chicago at the Zendesk Showcase!
Tech Tuesday: Popdock - Joining the tale of two States
Meet eOne Solutions at Directions EMEA 2023!
Connect with eOne Solutions at SuiteWorld 2023!

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce Salesforce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.