Posts Tagged ‘Mapping’

Assigning Default Dimensions

Cards in Nav/Business Central can have default dimensions assigned. These dimensions are not stored on the card, but rather in the Default Dimensions table. Therefore, after the card is created a second mapping will need to be used to add the dimensions.MappingA new web service will need to be published in Business Central, Page 540.…

[Read More]

Creating Payables Transaction with Analytical Accounting (AA)

One of the most confusing pieces of data to integrate into Dynamics GP is anything with Analytical Accounting. The main confusion comes from the fact that the field naming conventions don’t necessarily match the main module. For example, the Document Number field on the AA distribution is not the Payables Document Number but the Payables…

[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]

AP 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 Payables 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 the…

[Read More]

Microsoft Dynamics NAV Purchase Order Line failed to create record with a “readonly” error.

If you are using Microsoft Dynamics NAV 2016 and attempting to integrate Purchase Orders, the following fields from the Purchase Order Line will need to be mapped to a value from your Data Source or you can set them to a value of “False” in the Destination Column:Total Amount Incl VATSpecifiedTotal Amount Excl VATSpecified If any…

[Read More]

Minimum rights for SmartConnect SQL user

What are the minimum rights needed for the SmartConnect SQL user?The minimum rights the SmartConnect SQL user needs are db_owner of the SmartConnect data base. To make the SmartConnect user a db_owner do the following. 1. Login to SQL server management studio as a user with administrative rights. 2. Go to Security – Logins and…

[Read More]

Inventory Multi-bin transactions

Getting duplicate Item number errors when importing Multi-bin transactions.When importing Bin information using eConnect a line sequence number is required in order to create a unique link between the Line Item Insert and the Multi-bin insert. Typically in Great Plains, the line sequences increment by 16384, however this is not a requirement. You can simply…

[Read More]

RECENT POSTS


Failed to create record.: Entity does not support insert
Too Many Fields Defined After Microsoft Update
The operating system is not presently configured to run this application
SmartConnect Service Stops and ServerName==0 Shows in Event Log
No 'Access-Control-Allow-Origin' header is present on the requested resource.

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
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
Shortcuts Template for Extender

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM 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 SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartView SOP SQL Support Tech Tuesday Templates training