In my last LinkedIn Post (Cash Position Report), I talked about the strategic importance of Cash on hand for a Professional Services Organization. In this post, I want to talk about the importance of the Overdue Accounts Receivable (AR) Report. As a Professional Services firm, most of our revenue comes from Project based delivery of Services. … Continue reading Bill on Time, Get Paid on Time – Importance of the AR Report for a Professional Services Organization →

One of the issues with Dynamics 365 Retail is the way the errors are displayed to end users. I have come across many instances where it becomes very difficult to investigate and get to the root cause of an error message. The lack of clarity becomes an issue when you are not very familiar with … Continue reading Server side/DB related issues,errors in D365 Commerce Retail POS →

Hi everyone in this blog we will see the different DAX that are used to define or use the relationship between two tables. In Power BI there are two type of relationships                 1. One to One  (1:1)                 2. One to Many   (1:*) Now lets look at the DAX functions that we can use … Continue reading DAX For Relationships in Power BI →

In D365 there are several option to export/Import data like Data Entities, BYOD, Aggregate measurements/Entity store. In this blog we will learn How to create entity store in D365 Finance and operations. Aggregate Measurements/Entity Stores are use to create Power Bi reports with nearly Live data where user have option to set its recurrence that … Continue reading Create new aggregate measurement / Entity store in D365 Finance and Operation to be consumed in Power BI report in D365 Finance and Operations →

Introduction: We are aware of dynamics 365 CRM’s Document template functionality. However document templates do not need XML Mapping which limit the fields that we can populate in template. SO here’s a way to use Power Automate and SharePoint and implement the Document template functionality. Steps: Create Word Template with content controls and Upload to … Continue reading Create and Populate Word Template Using Power Automate →

Introduction: Power Automate makes it easy to populate word template, we can have table (Repeating control) that can be populated using Power Automate, For information on how to create and Populate Word Template- Refer my Blog: Create and Populate Word Template Using Power Automate Steps: Create a table and add content controls for each cell. … Continue reading Populate Repeating Control of Word Template using Power Automate →

Below is a simple example for importing data from CSV file in D365 FO using X++: /// <summary> /// import color code /// </summary> class CFSImportColorCode {     /// <summary>     /// main     /// </summary>     /// <param name = “_args”>_args</param>     public static void main(Args _args)     {         AsciiStreamIo                       file;         Array                               … Continue reading Import CSV file in D365 for Finance and Operation using X++ →

Introduction: In this blog we will see how to add/insert images in Canvas App. Step 1: Click on Media icon as shown below: Step 2: Select Upload -> Upload images Uploaded images will be shown under the “Images”. Step 3: Click on ellipsis -> Select Add to Canvas Output Screen: Hope this helps !

In this blog will see custom cards in Power Apps Use Case: I wanted to separate fields on form by label and it was looking like below:  here what i am came up with add custom card on form and try adding label on the Card. Add Custom Card Select form -> Click on edit … Continue reading Custom Card in Canvas Power Apps →

Introduction: Shortcuts are used to place child nodes(child links) throughout the portal’s sitemap(navigation) which simply points to other nodes that exist in your sitemap, or to URLs external to your portal. Use Case: We have two parent pages- “Hardware” and “Support”.  Both are child pages of another page- “Home”.  “Support” page has a child page … Continue reading What are Short Cuts in PowerApps Portal →