Filtering is a very powerful feature in Microsoft Dynamics 365 Business Central. It lets you create custom filters on list pages and save these as views so that you can go back to the filter without recreating it. In the screenshot above, we have filtered the Vendor Ledger Entries. To see the filter pane, click […]
Microsoft Power BI Reporting in Microsoft Dynamics 365 Business Central
Previously, we have covered the Custom Report Layouts and Odata Reporting in Microsoft Dynamics 365 Business Central. One of the other powerful ways of reporting Dynamics 365 Business Central information is Microsoft Power BI. Power BI is a cost-effective web API tool with robust data analytics type functions. It’s very structured and does make good […]
Reporting With OData Queries in Business Central – Part 2
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 […]