Business Central: Query & Reporting Options

By Chris Carrigee | February 28, 2020

Having just attended my first DirectionsNA in Las Vegas this past week, I really came to better understand Microsoft’s value proposition around providing Dynamics 365 Business Central and extending its capabilities via Office 365 and ISV (Independent Software Vendor) applications. Not that any of this is entirely new, per se, but aligning with that strategy and the direction Microsoft is headed clarified the next level of digital transformation and path forward for customers.

I’ve heard it said that what happens in Vegas stays in Vegas, but playing the rule-breaker, one standout ISV product that shouldn’t stay in Vegas was Popdock published by eOne Solutions: https://www.eonesolutions.com/popdock/ . This is a query and reporting app positioned to be for the User in the trenches actually performing work as opposed to the bougie Analytics/BI or other complex reporting tools for the more contemplative thinkers and strategists:

  1. It can be used as a stand-alone query and reporting tool or within Business Central or any app to increase productivity.
  2. It’s not a data warehouse, but queries live data on the fly (cool, imho, but might not be ideal for extremely large sets of data).
  3. Everything in Business Central is available for queries. It will also work with on-prem versions of BC and anything with an API (D365 Sales, Salesforce, ZenDesk, etc).
  4. It can sort, filter, group, save, share, drill down, and even drill down back into BC itself.
  5. This can all be done by end-users and consultants, with no dev or knowledge of table relations required.
  6. You can embed data from one source into another app, for example, show ZenDesk records in a frame in D365 Sales (CRM), but it will look like CRM – could be invoices, tickets, etc.
  7. You can schedule any report to run and email out.
  8. Sometimes you don’t want to move data, per se, as you would with eOne’s flagship product, SmartConnect https://www.eonesolutions.com/smartconnect/overview/, but rather just show data for fast action.
  9. You could move a Popdock query into Excel (with an add-in) or PowerBI to extend functionality.
  10. Fast to deploy, easy to use, and might even replace the need for SQL Queries.

Related Posts

Recommended Reading:

6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Organize and Prioritize Your Resources with Dynamics 365 Field Service

As a manager, Dynamics 365 Field Service lets you optimize the use of your employees, their skillsets, and other resources […]

Read the Article

Stoneridge Software Cracks the Top 20 on Bob Scott’s Top 100 VARs 2022

Stoneridge Software is ranked at #20 on Bob Scott’s Top 100 VARs for 2022. Each year, industry publisher, Bob Scott, […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X