In retail, success relies on a consistent customer experience across web, mobile and physical storefronts. The challenge for omni-channel retailers is ensuring the same level of service and convenience in physical locations as online—from stocking the same variety of inventory to offering personalized recommendations based on browsing and buying behaviour. Dynamics 365 Connected Store is a new application that provides insight into the retail space, helping physical retailers understand and improve the in-store experience by analysing disparate data from video cameras and IoT sensors to providing real-time and predictive insights that help store managers and employees make better decisions. Dynamics 365 Connected Store uses observational data generated as customers move through the store, as well as the status of store equipment and product, to create employee alerts and actionable insights that can improve store efficiency. For instance, Connected Store can improve the checkout experience by triaging extra cashiers via instant notifications, based on sensor or camera data. Fluctuations in the condition of store equipment such as freezers and refrigerators can put product quality at risk. Connected Store, supported by Azure IoT Central, utilizes IoT sensors to monitor temperature and humidity, which can quickly highlight any anomalies to protect inventory. Connected Store also tracks long-term trends in the retail space, illuminating patterns and opportunities across day-to-day, season-to-season activities and occurrences. Teams across the organization can stay updated with automated emails and a web app to review and report data. Whether you’re a regional manager who seeks to increase revenue and reduce cost by optimizing operations, a store manager who seeks to better-utilize their teams, or a store associate who seeks to better-prioritize their daily activities, Connected Store offers you benefits that can help you optimize customer experience. Hope this blog is Helpful.

In this blog we will see how we can convert the default date format of dd-mm-yyyy to mm-dd-yyyy. Step 1: Open power BI and go to relationship view. Step 2: Select the date column that you want to convert into desired date format. Step 3: Now click on custom format Step 4: Enter mm-dd-yyyy in format.  Now your date format is changed to mm-dd-yyyy. Hope this helps

In this blog we will see how to use decomposition tree in power BI The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. This makes it a valuable tool for ad hoc exploration and conducting root cause analysis Step 1: Open Power BI and select decomposition tree visual. Step 2: The visualization requires two types of input. Analyze – the metric you would like to analyze. This has to be a measure or an aggregate.Explain By – one or more dimensions you would like to drill down into. Once you drag your measure into the field well, the visual updates showcasing the aggregated measure Step 3: Add one more dimension from your data to add further drill down. Notice that a plus sign appears next to your root node once you add the field. Step 4: Now if you select forecast Accuracy results in the tree expands and breaks down the measure by the values in the column. This process can be repeated by choosing another node to drill into. If you select a node from the last level will cross-filter the data. Selecting a node from an earlier level changes the path. Hope this helps.

Introduction: In this blog we will see how to remove commas from whole number field. Use case : we were using the whole number field but after creation we noticed that there is comma in numbers. Solution: Step 1 : go to settings ->  click on settings icon -> Options Step 2: After clicking on Options, below screen will be displayed. Click on Formats -> Customizations After clicking on Customizations, in Digit group , select Options and click OK. click OK. Output:

This topic describes a configuration option that is available for the point of sale (POS) application. This configuration option changes the behaviour     for the selection of a mode of delivery when shipment orders are created in POS. When users create customer shipment orders in POS, they can select a mode of delivery for the shipment. This functionality is available regardless of whether the whole order is being shipped or only selected lines. By default, the dialog box where a mode of delivery is selected shows all the valid modes of delivery for the combination of a channel, an item, and a delivery address. These modes of delivery are defined on the Modes of delivery page in Headquarters (Sales and marketing > Setup > Distribution > Modes of delivery). “Non-carrier” modes of delivery, such as Carryout or Pickup, might also appear for selection in the dialog box. However, a feature has been added that lets you hide non-carrier modes of delivery in the dialog box. To turn on this feature, on the Commerce parameters > Customer orders tab, set the Show only carrier mode options for ship orders option to Yes. After you turn on this feature and run the appropriate distribution jobs to sync the information to the channel database, non-carrier modes of delivery won’t appear for selection during the process of creating shipment orders in POS. Hope This helps. Thankyou!

Power BI has some new features and Future Promises for Modern Enterprise applications in Business.

In this blog, we are going to see how to create object detection model which can be used in PowerApps or MS Flow / PowerAutomate Step 1: Log in to portal.office.com. Select the PowerApps, If PowerApps is not visible then click on All Apps then you will able to see the PowerApps. Step 2: Expand the AI Builder Section and click on Build Section in PowerApps. Note: Please ensure that you are select the correct instance. Step 3: Click on the Object Detection Model We are going to create the Object Detection Model which can be used to created PowerApps or In MS Flow / Automate. Step 4: Name the AI Model and click on Create. Step 5: We will select the Domain of Model so we will go with Common Object. And click on Next. Step 6: Before moving forward, we will download the data which will be used to train and test the Model. Kaggle is the best source for the data to train the machine learning model. We will require the fruit images as we are designing the Fruit Detection Model, search fruit images and download the Dataset given in the screenshot. Select the Fruit Image for Object Detection Click on the Download Step 7: After downloading the Zip file extract it. You will see the following two folders — train_zip and test_zip respectively. Now, we will open the train_zip folder and you can see that there will be four categories of images Apple Banana Orange Mixed [Apple, Banana, Orange] Step 8: Let move back to the PowerApps Platform, 2nd step in the creation of Object Model is to define the object that we are going to detect. Here, we have three objects — Apple, Banana & Orange and click on next to move further steps. Step 9: We will require a minimum 15 images of each category to train our Object Detection Model. Now, we will click on Add Images and select Upload from local storage. Step 10: Select the images. Once all images are upload click on Close. Click on Next Step 11: Now, we are in the most important phase of the training where we provide the Tag or Label to the Images which we have uploaded. Click on the uploaded image and select the area where the object is present. Once you will select the area you will get the option to select the object is that present in the selection area. If an image is not suitable for the model to remove that particular image click on the “Don’t use Image ”. Click on remove to remove the image from the model data set. Step 12: Once you are done will the tagging or labeling the image click on the Done tagging. Note: Please ensure that you have a more tagged image for each model so that your model will work accurately. The more the label data more the accurate your machine learning model. Step 13: Click on the Train to start the training your model based on tagged images. Click on Go to Model It will take around 5–10 min to train based on your complexity of images, model and objects. Step 14: Publish the model. Once you model finished with done and you have published the Model. You can use that model to in Power App or MS Flow. We are going to see that in the next part of this blog.

Many retailers, especially high-end specialty retailers, want their sales associates to form long-term relationships with their key customers. The associates are expected to know about these customers’ likes and dislikes, purchase history, product preferences, and important dates, such as anniversaries and birthdays. Associates need a place where they can capture this information and easily find it when it’s required. If this information is available in a single view, the associates can easily target customers who meet specific criteria. For example, they can find all customers who prefer to shop for handbags, or customers who have an important event approaching, such as a birthday or anniversary. Or if a customer had bought a gift for her husband then the cashier/associate can ask the customer if her husband liked the gift. In a nutshell, this will allow the stores to create a relationship with customers on a personal level. This is bound to make customers happy as they will begin to think that they matter and they are being looked after. Such practice will directly impact the sales Here is how you can set up Clienteling in d365 Retail  In the Feature management turn on the clienteling functionality in your environment Turn on the Clienteling feature by selecting Enable now. On the Commerce Parameters page, on the Number sequence tab, select the Client book identifier row. Then, in the Number sequence code field, select a number sequence. The system will use this number sequence to assign an ID to client books. Create a new attribute group that contains the attributes that you want to capture for customers who are managed in client books. Define the required attributes as Can be refined. Sales associates can then use these attributes to filter their client book. On the Commerce parameters page, on the Clienteling tab, in the Client book attribute group field, select the attribute group that you just created. To capture activities that occur at the POS, define the activity types on the Activity types page (Retail and Commerce > Customers > Activity types). Add two buttons to the appropriate POS screen layout, so that sales associates can view their own client book and the store client book. (Store client books include clients from all client books of all associates who share an address book with the store.) The corresponding operations are named View customers in client book and View customers from store client books, respectively. Three additional operations that are related to client books are available. These operations determine which associates can add, remove, and reassign customers from the client book. They are named Add customer to client book, Remove customers from client book, and Reassign customers to a client book, respectively. Run the following distribution schedule jobs: 1040, 1150, 1110, and 1090. After you’ve completed this procedure, sales associates can open the customer details page at the POS, and add customers to their client book, view and capture activities and notes for customers, and target customers by using customer and client book attributes to filter the client book. Hope this helps!

As seen in title when error “Your connection is not private | NET::ERR_CERT_DATE_INVALID” occured which seems as follows in screenshot when you try to open environment link in browser. The reason for above error in my case was that SSL certificate was expired as you can see in following screenshot To solve this issue go to your lcs.dynamics.com with your credentials and open your project now select which ever environment and visit see details/Full details page and click on maintain button and select  Rotate secrets button  Now click on Rotate SSL certificates after which dialogue box will appear click on yes  Now wait till rotating secret symbol is loading as following screenshot after which you will be able to access your D365 Finance and operation link easily. Hope this blog will help you.Thank you

In this blog, we are going to Trigger ADF Pipeline whenever there is insert or update operation is performed on on-premise SQL Server. Steps: Create ADF Pipeline.In this case we have already created Pipeline. And below is Dataflow. Create PowerShell Script (for Authentication and Triggering Pipeline).Below is the code for authentication and triggering of Pipeline, to do so we should have following details: Tenant ID, Application ID ,Client Secret, Subscription ID, Resource group Name, API version and pipeline name. Create Job in SQL and Trigger on Table where Insert update or delete. Make sure that SQL server agent is running. Create a SQL Job with following Job StepEnter step name, select type as PowerShell, select account will be used to run PowerShell script and enter the code in command section. Next we will create trigger on the tablesWe are creating triggers on the tables on which insert, update, delete operations will be performed. Now whenever we will do insert, update or delete in the table the pipeline will automatically get executed.We have following data in Accounts table, Now we updated currency of Account ID 1, the moment we updated the record pipeline gets automatically triggered, After some time check status, Hope above helps!