The Power Query OData.Feed function has an option called IncludeAnnotations that allows you to return annotation values from an OData data source. It’s not obvious how to use it though – even if you use this option when connecting, you won’t see the annotation values by default because they are returned as metadata.
How to add Filter Tokens in Microsoft Dynamics 365 Business Central
Filter Tokens is an interesting functionality in Business Central. Many of us do not know about this functionality. Using this functionality, you can add Filter Tokens like Tomorrow, Yesterday, ThisMonth, PrevMonth, FiscalYear, PrevFiscalYear, NextFiscalYear etc. so that User can use them just like Today and WorkDate Filter Tokens to apply date filters.
WhatsApp messaging with Business Central
WhatsApp is the one of the most used messaging systems so I thought it would be a good idea to have the chance to send messages from BC.
Source : picazin things on NAV & Dynamics Business Central
Read more…
Adding Tooltips To Column Headers In The Power Query Editor In Power BI And Excel
Here’s something that will excite all you M nerds out there! Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query Editor in either Power BI Desktop or Excel?
Visual Studio Code Snippets: User Personalization, Shortcuts, Keybinding
Visual Studio Code lets you perform most tasks directly from your keyboard as well as utilize code templates, known as snippets, to drastically increase the speed of your work. In this article, I will outline how to modify and create your own shortcuts and Visual Studio Code snippets to suit your workflow and save you some time spent on repetitive tasks.
SagePay Integration
User can take the Payment from customers directly from D365BC and Refund for the same. It can also create a Payment Receipt General Journal and user can apply the payment with the Invoice or Credit Memo. You can also download the statements from Sagepay
Source : Ajay Jain
Read more…
Tip: Evaluating DateTime with Type Helper
Dates. What a nightmare. Day/Month/Year? Month/Day/Year? 24 hour time? 12 hour time? It’s almost enough to make you sympathetic to the idea of decimal time…almost.