12 Tips of D365 F&O - SysTableBrowser

December 7, 2023

🎶 In the fourth tip of D365 F&O, D365 with Brittany shared with me--SysTableBrowser functionality! 🎶

What Is SysTableBrowser?

In Dynamics 365 Finance and Operations (D365 F&O), SysTableBrowser is a tool that allows users to explore and analyze data within the system tables. The SysTableBrowser tool is particularly useful for examining the structure and content of system tables, making it easier to understand the data model and troubleshoot issues.

Access to SysTableBrowser is typically restricted to users with appropriate security roles and permissions, mainly System Administrators.  This does not give you access to modify any data, but you can sort and export the data just like any other form, but with the benefit of seeing the whole table, including system generated fields.

Keep in mind that the usage of SysTableBrowser requires a good understanding of the D365 F&O data model and is generally intended for advanced users involved in development, customization, and troubleshooting tasks within the system.

How To Access SysTableBrowser

Simply replace the value in your search bar after mi= with SysTableBrowser&TableName= followed by the table you wish to view the data for. Your resulting URL may go from looking something like

www.mycompanyD365.com/?cmp=DAT&mi=ProjSalesItemReq 

to

www.mycompanyD365.com/?cmp=DAT&mi=SysTableBrowser&TableName=InventTrans


This does not give you access to modify any data, but you can sort and export the data just like any other form, but with the benefit of seeing the whole table, including system generated fields.

Benefits of Using SysTableBrowser

Here are some key points about SysTableBrowser in D365 F&O:

Viewing Table Data: SysTableBrowser allows you to view the data of system tables in a tabular format. You can choose a table and examine its records and fields.

Filtering and Sorting: The tool provides filtering and sorting options, making it easy to focus on specific records or arrange data in a preferred order.

Exporting Data: Users can export data from SysTableBrowser for further analysis. This is particularly useful for creating custom reports or conducting detailed data analysis outside of the system.

Understanding Table Relationships: SysTableBrowser helps users understand the relationships between different tables in the system. This is crucial for comprehending the data model and designing integrations or customizations.

Development and Debugging: Developers and QA Testers can use SysTableBrowser during the development/QA and debugging process to verify data changes, check field values, and troubleshoot issues related to data manipulation.

Have questions about how to use the integration with excel?  Send me a message and I will be in touch!


Don't forget to subscribe to my newsletter to get exclusive content and stay up to date with all my latest posts.Â