Phase 2/4: SSIS Integration Map for Invoice Header from SQL Server to Microsoft CRM: The Map after Completion will look as follows. Step 1: Add an OLEDB Source and configure it as follows: Click on Parameters and configure it as follows: Step 2: Add a derived column transformation to specify the Customer Type i.e 2 … Continue reading Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 2 →

Part 3/4 SSIS Integration Map for Invoice Details from SQL Server to Microsoft CRM Step 1: Add a DFT to Integrate the Invoice Details in the Control Flow. The Map after Completion looks as follows: Step 2: Add an OLEDB Source and configure it as following: In our case we are Inner Joining Invoice and … Continue reading Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 3 →

Part 4/4 Delete Logic for Invoice in case of Incomplete Integration of Invoice details Logic Introduction: To handle the scenario where the Invoice Details fail to get Integrated or Incomplete Integration of Invoice Lines the Invoice itself should get deleted from CRM as we don’t want to Integrate Incomplete records. Step 1: Add a DFT … Continue reading Using For Each Loop in SSIS for Invoice Integration from SQL Server to Microsoft D365 Sales Using KingswaySoft Connector for CRM: Part 4 →

We are quickly transitioning over from Organization Insights which came as a managed solution inside D365 to CDS For Apps Analytics on the PowerPlatform Admin Center. And now, the same is revamped as Capacity in PowerPlatform Admin Center. So, if you go to Storage in CDS For Apps analytics, you’ll see this – Capacity You … Continue reading Capacity type storage on PowerPlatform Admin Center →

Maintaining a retail store is not an easy task. You have to take care of several aspects. Unfortunately, not many retailers know how to do it. They struggle to take care of things such as retail store management, providing customer experience and support etc. It is wise to get Microsoft Dynamics 365 for Retail Management … Continue reading Benefits of implementing Cloud POS in Microsoft Dynamics 365 for Retail →

1. Lock-free number series (Allow gaps in Number Series). Users can choose to mark number series to allow gaps in the series. These number series will be non-blocking, which will boost performance. Add notes and links to data Users can quickly add a note to the data they are currently viewing on the Business Central, … Continue reading Business Central Wave 2 Features – Section 2 →

Two departments that are most important in a business is finance and operations. Unless they are efficient and perform well, you as a company are going to struggle a lot. Hence, you need to plan on using Dynamics 365 for Finance and Operations to streamline your business. It is yet another product from Microsoft that … Continue reading How to Delete Model/Package in Finance and Operations →

Hello guys, The two types of point of sale or POS in Microsoft Dynamics 365 for Retail Management Solution are MPOS and CPOS. MPOS is Modern Point of Sale and CPOS is Cloud Point of Sale. There is no offline functionality when it comes to Cloud POS. It has a unique design that allows you to … Continue reading MPOS to CPOS in Dynamics 365 for Retail →

Let’s say you need to create a new store with multiple registers on CPOS.   It is now possible to have a retail store with multiple registers each running CPOS and each having their own dedicated hardware.   For example: A store with two registers both running CPOS and both having their own receipt printer, … Continue reading ProTip: Running Multiple Registers on CPOS →

Hi, In this blog I am going to illustrate how to get past the printing issues when you are trying to print Customer order, Quotation etc. Let’s consider a scenario: You are using a POS printer which is connected to your CPOS system. After finishing a transaction you want to print the receipt again from … Continue reading Customer order printing issue in Microsoft Dynamics D365 For Retail →