Hi in this blog we will see how we can add rows to power bi dataset for a given date range. For example if you have a dataset which has start and end date and you want rows for each date between this range then this blog will help you. Step 1: Open Power BI … Continue reading Add rows to Power BI dataset for date range →

Introduction: Business Central provides us an easy method of modifying our data from within Excel using Web Services commonly found in the Edit in Excel action. This can be seen in the commonly used List Pages for example Payment Terms. However this functionality can be missing for certain pages or you might want to have … Continue reading Adding Edit in Excel for List Parts or Custom Pages →

On some instances, there are Managed fields in Dynamics 365 CRM (or CE if you want to call it) where we can’t change the required level of the field from Fields i.e. on the database level. And you get the below error – Here’s an alternative way to do it. Scenario Let’s consider this scenario. … Continue reading Making Managed fields required dynamically in Dynamics 365 →

In this blog, we will see how we can show activities on Notes in D365 CRM.  Step 1 – Click on Entity and check marked Activities. Save and publish the Entity. Step 2 – Open Main form where you have added timeline, Double click on timeline notes and mark filter by as Show all. Save … Continue reading Quick Tip – Enable/Show Activities on Notes in D365 CRM →

Introduction: Business Central provides us with Change Log which helps us in keeping track of the changes made to a particular field in a particular table. References: Auditing changes – Business Central | Microsoft Docs Configuration: Search for Change Log in Business Central.  Select the tables you want to enable the change log for.  You … Continue reading Enabling Change Log in Business Central →

Hello, everyone! We know that Recommendations are created using Business Rules, but that only works on Model Driven Apps. As a result, we’ll develop Custom Recommendations that are flexible and customizable to our needs and enhance our App. This is how the Custom Recommendation looks, Let’s start with a simple use case, I want to … Continue reading Create Custom Recommendation on Form within Canvas Power Apps →

Introduction: A “shared shift” configuration lets retailers have a single shift across multiple registers, cash drawers, and users. A shared shift has a single starting amount and a single closing amount that are summarized across all cash drawers. In this scenario, a separate cash drawer isn’t reserved for each register. Instead, all registers can share … Continue reading Use of shared shift in a store with two or more terminals in D365 for Retail →

Introduction: In this blog, we’ll be looking at how to reduce manual work in creating Sales Line in Business Central. For this, we’ll be using the Out of the Box feature of “Recurring Sales Lines” References: Standard Recurring Sales and Purchase Lines – Business Central | Microsoft Docs Configuration: Search for Recurring Sales Lines in … Continue reading Recurring Sales in Business Central →

Introduction:  Leadfeeder provides details of companies visiting your website, you can integrate the same to D365 CRM. STEP 1: Login to LeadFeeder; On the right corner click on your Account and then on Settings. You will see the below screen, click on Account to see all possible integrations. Click on Dynamics 365 STEP 2: Follow … Continue reading Integrate LeadFeeder with Dynamics 365 CRM →

Introduction: Based on certain values dynamically show and hide the fields in the request page of the report. Ideally, we cannot directly use visible property to fields. we can do this by enabling the visibility of fields using groups. Steps to achieve the goal: Create a groups and add the fields which you want to … Continue reading How to dynamically show and hide the fields in the Request page of Business Central? →