Introduction In a recent project involving Power BI, our focus was on establishing connections to an on-premise Business Central instance. To access the business sandbox, customer opened sandbox service port for us. Additionally, for production purposes, we configured a Data Gateway within the Power BI service. However, upon completion of development, we encountered an issue during the deployment of the… Read more »
Requirement Let’s say we want to fetch incremental data from BC for CRM using Kingswaysoft. Details While working with CRM and BC integration using Kingswaysoft, let’s say we want to get incremental data from Navision, for example records modified in last 2 minutes or so. In that case we need to have a datetime field in the NAV table which… Read more »
Requirement Integrating Dynamics 365 CE and BC with Business Central v2.0 API endpoints using KingswaySoft Details Recently I was working on a POC for Dynamics 365 CE and BC integration where we wanted to test integration using BC V2.0 endpoints. Based on Microsoft documentation Following is the standard BC V2.0 API URL format: https://api.businesscentral.dynamics.com/v2.0/tenant/environmenet/api/v2.0 Where environment represent dev,test or production environment… Read more »
Issue Recently we faced date issue while sending invoice data from Dynamics 365 to Business Central. Details We have implemented Dynamics 365 and Business Central integration using KingswaySoft toolkit. While testing invoice details created in Business central, we found issue with the date, it was one day behind the CRM date sent to BC. Earlier same SSIS packages with Azure… Read more »
Issue Recently I was working on scheduling SSIS packages developed using Kingswaysoft toolkit for Dynamics 365 CRM, while testing my job I encountered following error: “Source: Data Flow Task Dynamics CRM Destination [11] Description: The runtime connection manager with the ID “{…}” cannot be found. Verify that the connection manager collection has a connection manager with that ID..” Solution Based on the error message, it… Read more »
Issue Recently we started getting error in CRM to BC integration where we have used SSIS Integration toolkit for Microsoft Dynamics 365 from KingswaySoft and we have hosted this in Azure Data Factory. We were getting following error: “SsisDBOperationGuid”: “0ea2f07f-56ee-404d-8762-8d38851f7cb7”, “SsisDBOperationId”: 64741, “OperationErrorMessages”: “2/9/2021 7:33:27 AM +00:00 : Data Flow Task:Error: Dynamics CRM Destination.Inputs[Input].Columns[invoiceid] has lineage ID 1611 that was… Read more »
Issue Recently while working in one of the customer environment we found sales order is automatically submitted to BC without pricing details as we soon as order is created like below: I am going to share some details how I fixed this issue. Details This environment has Sales order integration enabled and we have developed a custom workflow for customer… Read more »