Armanino Blog
Article

Tip: How to See Database Tables in D365 for Finance and Operations―Without VSTS

June 18, 2018

In AX2012 and prior, users could just go into the Application Object Tree (AOT) to see database tables, but the AOT is not available in D365. So the reason this tip is really cool is that up until this point, we all thought it was necessary to have Visual Studio Team Services (VSTS) installed in order to see D365 database tables. This requires a license for each user, so it is an additional expense. However, by installing a Chrome extension, it is possible to view and even edit table data without VSTS.

Here are some quick steps:

  1. Go to: https://chrome.google.com/webstore/detail/table-browser-caller-for/nahbldacmaibopfiiaoboloegpobpccn  and install it.
  2. This adds a Table Browser Caller shortcut. Screenshot of the new Table Browser Shortcut
  3. Launch the shortcut.
  4. Select the Config tab. Launch the Config Tab in D365 Screenshot
  5. Click the plus (+) sign to add a new D365 URL. Adding a new D365 URL under Config Screenshot
  6. Back on the Table Browser Caller tab, enter the table name for which you want to view data and then click the lookup/magnifying glass icon.  Alternatively, if you don't know the table name, you can click Table List and select a table that way. Enter table name in the Table Browser Caller Tab Screenshot
  7. This will launch a new browser tab displaying the data for the selected table. New Browser Tab that Displays Data for the Selected Table in D365 Screenshot
  8. At this point, the data is view-only.  However, if you change "true" to "false" in the URL, the data is then editable... except in a production environment.
-package-in-powerapps.png" alt="Track a package in PowerApps for D365 Finance and Operations" style="width:100%">

Here the tracking number shows the status of the order lifecycle with real-time information on the delivery, where it can pull in the delivery status from the logistics provider. Pretty cool!

Package Tracker Popup in PowerApps for Dynamics 365

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
Costco Travel Webinar
Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022