In this video, I’ll demonstrate how to use some of the advanced functionality in the power query editor to query things from Microsoft Dynamics 365 Business Central/Tensoft SemiOps/ DemandOps or any OData source. Firstly, I’ll cover how to combine queries together in two different ways – Merge and Append. Merge is joining two related datasets […]
Reporting With OData Queries in Business Central – Part 1
OData queries are URLs that can expose any table or any piece of data that’s in Microsoft Dynamics 365 Business Central via the Web Services Page. It comes with a bunch of already delivered web services, but you can add new sources as needed by clicking on ‘New’ and then referencing either the Page that […]
Overview of Purchasing Cycle in Microsoft Dynamics 365 Business Central
In this blog post, I’ll show you how to create a quote, convert it to an order and then create the invoice from the order. 4:10: Quick walk-through on the two ways to process an invoice There are two documents on the Purchasing side – purchase quote and a purchase order. Based on your approval […]
New Features in Microsoft Dynamics 365 Business Central
The April release of Microsoft Dynamics 365 Business Central is now generally available. This release brings a lot of new features and improvements to existing functionality that promise to really increase productivity. I’ll discuss a few of my favorites here. Some of the features that Microsoft considers more impactful can be enabled ahead of time […]
New Features in Business Central 2022 Wave 1 Release: Account Schedules
With the new release of Microsoft Dynamics 365 Business Central, Microsoft has improved Account Schedules and added new capabilities for financial reporting. Now you can control what you want to show when you’re skipping zeros. There is a configuration setting that allows you to select how you want to display zero. Commonly used ways to […]