OData and multiple dynamic conditions
Hi there, I am trying to filter sales prices from BC that either have a specific end date in BC (0001-01-01) or that are greater than today. In standard OData I can do this: ?$filter=(Ending_Date eq 0001-01-01 or Ending_Date gt 2023-09-18) which work ...
BC endpoints syntax for filtering
Hi guys, I am working on an integration with BC and I am trying to make use for the endpoints functionality. The first question I have is related to using the endpoints in the template (or back-end code) logic. For example, If I want to make a reques ...
Sync queued order - Finished after X minutes - not working
We have recently had some issues with duplicate orders being created in BC and found this is caused by the Live Integration sending the order at the same time as the "Sync queued orders" task. We have found that this caused by the incorrect ...
No replies yet
Update has been canceled
We sometimes see this error when creating orders in D365 F&O. 09-19-2023 01:21:37.255 : ConnectionError: Error CalculateOrder Order Id:'ORDERXXXX' CreateOrder:'True' Message:'The remote server returned an error: (500) Internal ...
Importing product data in multiple languages
Hi, I've created an integration in the default language for the basic product information with the Ecom provider. I need to create these products in 24 other languages. I want to avoid creating 24 more data integrations, and hope it can be done i ...
Intermittent BC14 OrdersPut issue
Hi, At a certain customer every once in a while (few times per month) and order does not arrive in BC14. The log then shows: When the order is then sent to ERP manually via the backend it does get correctly added to ERP. It seems (after a lot of watc ...
Liveintegration. productlist with variants takes a looong time. How to avoid this?
Hi, I have a productlist with variants. When using live intregration and this - the call to the live integration is too big. I have this checked: "Include variants in productinfo request". I cant disable this, because then it wont work when ...
Length of order fields
Hi, We have an issue integrating the order fields from DW to BC. Some DW fields have a length that is too long to be integrated at BC. What is the best solution to solve this issue? Truncating the fields before sending them to BC? Truncating the fiel ...
How to get Order Shipping Status from Business Central to DW
Hi, I am integrating Endpoint to get the order details from Business Central to DW. However, I cannot get the fields required for Shipping Status from Business Central. Please let me know how we can get the Shipping Status from BC to DW. ...
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 ...
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. ...
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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...