Posts Tagged ‘GL Transactions’

SmartList Combining Payables Distributions to General Ledger Transactions

Here at eOne, it seems we get a lot of requests for a SmartList that gives the Payables transactions with their distributions and the corresponding General Ledger transactions.  So many requests in fact that we decided to create one for everyone to use.  If you look in the SmartList Builder template list under the Purchasing…

[Read More]

GL Intercompany Import Setup using SmartConnect

If you are using SmartConnect 20.16 or newer, eOne has automatically included the nodes for creating intercompany distributions. We will walk through the setup of a standard General Ledger Transaction integration with the one additional step of including the Intercompany mapping. Please note, this does not allow for Multi-Currency transactions with Intercompany distributions. To start…

[Read More]

Importing large GL transaction with SmartConnect

When importing single GL transactions with large numbers of distributions, you may encounter timeout issues with the eConnect COM+ component.This can be resolved my manipulating the SmartConnect maps so that individual line items are considered a single transaction. Then the header of the transaction is brought in to complete the transaction. This involves creating 2…

[Read More]


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site



open all | close all


Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training