How can we help?
All help articles
Refine your search by applying filters to find exactly what you are seeking.
When attempting to log in to SmartConnect On-Premise, you may encounter the following error: could not execute native bulk manipulation query: Delete from TraceHeader Where StartDate < (GETUTCDATE() – 30)[SQL:…
Maintenance Addressing SmartConnect Error “Cannot Delete the Integration” Due to Existing TraceHeader Record.When attempting to delete an integration in SmartConnect On-Premise, you may encounter the following error: “Cannot delete the integration, the following errors has occurred: could not execute native bulk manipulation…
Calculations How to Fix “Invalid Column Name” Error In SmartConnect SQL TaskI have created an integration, and it works fine, but I need to update a SQL Table and an integer status value, so I added an ‘After Document Success‘ SQL…
Data Tech Tuesday: Recurring Payables Batch fails with Record Changed Error when Posting in Microsoft Dynamics GPIf you’d like to watch a video explaining this, see below or click here. We used SmartConnect to create a batch of Payables Transactions. By default, eConnect creates all batches…
Tasks How To Cancel an Email Task in SmartConnectThe Issue with the Email Task In SmartConnect.com, I run a scheduled integration that frequently returns no data from the source. I created an Integration Post Success Email Task that…
Security How to Add a Team for AI Admin in PopdockThis guide provides step-by-step instructions for creating a new team named “AI Admin” in Popdock’s Security settings, adding the MCP (Model Context Protocol) Administrator role to it, and adding users…
Calculations Creating a Filterable Date Value from a Datetime Field in PopdockPopdock can filter on many field types from various data sources. Datetime fields, however, take one extra step to filter precisely. The Equals criterion rarely matches a datetime field, because…
What’s Different in the New SmartConnect: A Comparison with SmartConnect.comIf you’re moving from SmartConnect.com or SmartConnect 21 to the new SmartConnect, or you’re a partner helping your customers make the move, this article walks through what’s changed and what…
Query Builder Query Builder Basics: Best PracticesQuery Builder Basics: Preventing issues with Query Builder Building queries in Microsoft Dynamics 365 Business Central (Business Central) with the Query Builder is straightforward, but knowing a few best practices…
Query Builder Query Builder Basics: Setup and ExecutionQuery Builder is a powerful tool, and a few quick checks along the way help you get the most out of it. This article walks through the basics of setup…
Destination How to resolve error: ‘Cannot insert the value NULL into Column DepAmt’ on GP BankRec Deposit IntegrationI’m using SmartConnect 2018/21 to create a Dynamics GP Bank Reconcilliation Deposit without Receipts integration. The map is pretty simple, but when I run it, it fails with the error:…
Data How to Update Dynamics GP Payables Long Description with SmartConnectIn Dynamics GP, I’ve enabled the option for “Enable Long Description in Payables Transaction Entry”. I’ve created a SmartConnect map for Dynamics GP Payables Transaction; however I don’t see the…
Feeling stuck? Get the support and guidance you need to help you power through any data challenge
Let’s be real. In the tech world we live in, every team has found the perfect app that speaks their language. It fits their needs like a glove, but step back, it’s a bit of a mess to put it all together. This is where eOne comes in, and we back our products and customers to ensure everyone is breaking language barriers (and solving their challenges).
