Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
OData and live calls
Hi there, I have a project that uses OData for products and orders but am now also looking into options to do live calls. The business case is RMAs: the customer likes to use BC RMA functionality and not use our build-in features. The flow is somewha ...
Imar Spaanjaars
08/09/2023 13:58:42
Last post: 08/09/2023 14:43:09
VAT rounding issues in BC
Hi there, I am using OData to send orders into BC. I got most of it working but I am now facing some rounding issues. I am sending the order line price with VAT (with the "Prices Including VAT" turned on) as the unit price for each product. ...
Imar Spaanjaars
06/09/2023 21:38:43
Last post: 07/09/2023 17:08:57
Multible customer numbers on one user and Live Integration
Hi, We have a customer who is importing users to their Dynamicweb solution. The users live in Navision with same email but can have multible customer numbers. As of right now the username is the email, which gives issues when we launch more websites  ...
Marie Louise Veigert
30/08/2023 13:35:35
Last post: 05/09/2023 13:12:37
Changing a Ecom Groups name does not refresh the navigation (friendly url)
Using a standard integration with XML provider/Ecom provider. When an Ecom group changes its name, the Ecom navigation change the name on the item, but the friendly url doesn't refresh, and still uses the previous. Is there a way to force the fri ...
Christian Ginnerup
01/09/2021 10:49:47
Last post: 04/09/2023 18:44:31
Multiple Product Units combined with a simple stock import
Hi , I have defined and imported different product units. As you can see in the screenshot below, the defined 'Sales unit' is always the base unit: "always 1 piece". My source file with the stock quantities only has 1 line per produ ...
Davy Capiau
28/08/2023 17:11:35
Last post: 01/09/2023 15:09:06
EcomDiscount best practices
Hi, I'm using the DynamicwebProvider to import different discount rules. I have some questions: What is the best practice to import the translations of the rules in the EcomDiscountTranslations table? I want to avoid needing to export the rule id ...
Davy Capiau
10/08/2023 09:40:09
Last post: 29/08/2023 16:20:01
Liveintegration and manipulating salesline price via BC plugin custom unit
Hi, we are trying to extend the BC plugin unit on Cloud. We have looked a little at this thread: https://doc.dynamicweb.com/forum?PID=1605&ThreadID=87816 We are trying to manipulate it, and when we do, we sometimes get an error. Look at my attach ...
Jan Sangill
05/07/2023 08:08:21
Last post: 26/08/2023 09:07:04
BC Integration - Invoice discount including shipping fee
I have found an issue when trying to apply a full credit/discount to an order. This issue is related to the shipping fee. I want to apply an invoice discount amount of the full value of the order including the shipping fee. In the BC code unit the sh ...
Jon Thorne
23/08/2023 04:34:39
Last post: 23/08/2023 16:01:00
XML error when sending a request to Live Int
I try to get live prices but get a error that says: "Fjärrservern returnerade ett fel: (500) Internt serverfel. Response: The following exception was encountered when processing XML data: 'Data at the root level is invalid. Line 6, posi ...
Fredrik
23/08/2023 13:14:57
Last post: 23/08/2023 15:09:43
Connecting to BC gives error "Most Times"
Hello, I'm dealing with a difficult issue here, as the Plugin in BC seems to be installed correctly, I have a DynamicWebService installed locally that is configured correct;y, and I can use the testtool to get resuts from BC. However the response ...
Justin Sjouw
13/07/2023 15:32:12
Last post: 22/08/2023 15:58:34
Power BI integration
We have a client that wants to be able to access certain data from DW and use into Power BI. Is there any "easy" way of doing this? Or maybe its done before? We are thinking to expose data through and API endpoint, but thought it would be g ...
Anders Thoresen
22/08/2023 12:21:46
Last post: 22/08/2023 14:58:28
Changing input files result in full re-mapping
Hi, Is the behaviour seen here considered normal? or is there a way to preserve mapping from a previous version of a file i.e we have a new CSV file, with some fields added, and want to add these fields in the import job, it seems we need to redefine ...
Justin Sjouw
27/07/2023 10:40:11
Last post: 22/08/2023 14:25:06
Differences results between using Connector Test Tool and Liveintegration in backoffice
Hi, Im experience some differences between using the "DynamicwebConnectorTestTool (2.5.0)" and the liveintegrationen in Dynamicweb Admin backoffice. Both are set up to use the same Web service URL from the server. Any suggestions to why thi ...
Marie Louise Veigert
21/08/2023 10:36:42
Last post: 21/08/2023 12:01:40
Generate Passwords overwrites edited passwords
Hi guys, I have an integration job with NAV, we retrieve users from NAV and save them in DW or update their details. In the process, we are using the "Generate password for users". But I have noticed that if a user changes their password, t ...
Adrian Ursu
10/08/2023 14:09:13
Last post: 14/08/2023 11:23:22
Complete data in Business Central: Sales Header and Sales Line
Hello everyone, I have had a problem in the integration of orders between DW and BC 14.0 OnPrem, I must complement some data from the SalesHeader and SalesLine tables, for this I added the code in the OnBeforeUpdateSalesHeader event and the data is a ...
John Cristian Villamar Cueva
20/07/2023 01:21:50
Last post: 11/08/2023 16:31:50
Remove missing rows after import
Hi, I'm using the Ecom Provider on a DW 9.15.3 solution, to update products. Each language layer has its own integration job. When updating the Groups on a product, new product group relations are created, but the old and no longer active relatio ...
Kurt Moskjær Andersen
04/08/2023 14:08:18
Last post: 10/08/2023 08:07:09
User additional address import incorrect overwrite
Hi, I have created users via the user provider. Now I'm trying to add extra addresses via the user providers' AccessUserAddress table. During the first import my 2 additional (not-identical) addresses are imported. But then when reimporting,  ...
Davy Capiau
08/08/2023 14:58:33
Last post: 08/08/2023 15:33:40
Handling of DateTIme during import
Hi, Is there documentation about the handling of DateTiem fields in the import? I'm dealing with several possbile formats from a source and would like to know If there is anything I can/should do during import to make sure the source format is co ...
Justin Sjouw
26/07/2023 13:41:09
Last post: 07/08/2023 08:29:19
Conditionals not working while importing
Hi, When trying to skip rows where a value is null or empty I set this conditional, but it doesn't work: The result: the import behaves as if there was no conditional. I also tried with !@NULLOREMPTY My specific case: - CSV import - AccessUser Ta ...
Davy Capiau
02/08/2023 13:14:14
Last post: 02/08/2023 15:19:34
Need filtering of data and custom fields response from Business Central
We use the "Integration Customer Centre" to get data from Business Central and show it on the front end. While getting data from Business Central we have created End Point which communicates with Business Central. The End Point is configure ...
Girish Kamble
01/08/2023 16:34:21
Last post: 01/08/2023 17:34:19