This part of the documentation contains reference information you can use to set up destination mappings for your integrations that use destinations in the Microsoft Dynamics GP eConnect adapter. The tables that follow describe the properties and restrictions for each destination in the Microsoft Dynamics GP eConnect adapter. The tables also include required fields for each recordset in each destination. You need to select a rule for each of the required fields in the root recordset for the destinations you use. Root recordsets are in bold text.
|
The tables also include the mapping options for each destination. These mapping options are on the Options tab of the Integration Mapping window. Because each child recordset contains the Record Source mapping option, it is not included in the following tables. |
The Receivables Management module in the Microsoft Dynamics GP eConnect adapter contains destinations for Customer.
Customer The Customer destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
The Customer ID should be in all capital letters. The rule property for Case Conversion can be set to Convert to Upper if the source file has the Customer ID in lowercase letters. |
|
Required Fields |
|
|
Customer |
Customer ID |
|
Addresses |
Address ID |
The Inventory module in the Microsoft Dynamics GP eConnect adapter contains destinations for Inventory Item and Inventory Transaction.
Inventory Item The Inventory Item destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
This destination is insert-only. It cannot be used to update existing inventory transactions. |
|
|
Adding components to kit items is not supported. |
|
|
Entry of Internet information specific to each item is not supported. |
|
Required Fields |
|
|
Inventory Item |
Item Number Description U of M Schedule ID |
|
Currency |
Currency ID |
|
Price List/Detail |
Price Level U of M |
|
Vendors |
Vendor ID |
Inventory Transaction The Inventory Transaction has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
This destination is insert-only. It cannot be used to update existing inventory transactions. |
|
|
Transactions for lot-numbered and serial-numbered items are not supported. |
|
Required Fields |
|
|
Inventory Transaction |
Document Type Date Batch ID |
|
Items |
Item Number Quantity |
The Purchasing module in the Microsoft Dynamics GP eConnect adapter contains destinations for Purchasing Order Entry, Receivings Transaction Entry, and Vendor.
Purchasing Order Entry The Purchasing Order Entry destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
This destination is insert-only. It cannot be used to update existing purchase orders. |
|
Multicurrency transactions are not supported. The Currency ID for the transaction must always be the ID of the functional currency. |
|
|
You must use the Item Vendor Maintenance window to link inventory items to vendors before they can be used in a purchase order and received. Automatic linking is not supported. |
|
|
Sales document commitment is not supported. |
|
|
Distributions to unit accounts are not supported. |
|
|
Required Fields |
|
|
Purchase Order Entry |
Vendor ID |
Receivings Transaction Entry The Receivings Transaction Entry destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
Multicurrency transactions are not supported. The Currency ID for the transaction must always be the ID of the functional currency. |
|
Tax on Shipment/Invoice receipts will not be automatically calculated based on the vendor, items and locations. |
|
|
Receipt of inventory items that are lot–numbered or serial–numbered is not supported. |
|
|
You must use the Item Vendor Maintenance window to link inventory items to vendors before they can be used in a purchase order and received. Automatic linking is not supported. |
|
|
Sales Document Commitment is not supported. |
|
|
Required Fields |
|
|
Receivings Transaction Entry |
Batch ID Vendor ID |
|
Distributions |
Account Type Debit Credit |
Vendor The Vendor destination has the following properties.
|
Destination Edit Modes |
Insert Only Update Only Insert and Update |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Vendor |
Vendor ID Name |
|
Addresses |
Address ID |
The Sales Order Processing module in the Microsoft Dynamics GP eConnect adapter contains destinations for Sales Transaction.
Sales Transaction The Sales Transaction destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
This destination is insert-only. It cannot be used to update existing sales order transactions. |
|
Only Order and Invoice document types are supported. Quotes, returns and back orders are not supported. |
|
|
Multicurrency, VAT and Intrastat are not supported. The Currency ID for the transaction must always be the ID of the functional currency. |
|
|
Entering deposits on Order documents is not supported. Entering payments on Invoices is supported. |
|
|
Automatic fulfillment of lot-numbered and serial-numbered items is not supported. These items can be entered on an order or invoice only if the Document ID is set up to use a separate fulfillment process. |
|
|
|
For quantity shortages, only the Override Shortage option is allowed. Users who want to select other options can set up their document types to allocate by document or batch. |
|
|
Entering documents as “repeating” is not supported. |
|
|
Commissions fields and tables cannot be populated. |
|
|
Automatic calculation of sales tax is not supported. Users can specify tax details and tax amounts at the document header level in the integration. |
|
|
Line item taxes are not supported. |
|
|
Process holds are not supported. If document types have been set up for automatic process holds, those process holds will not automatically be applied. |
|
|
Payment terms that have the discount type “EOM” are not supported. When this discount type is used, the document will integrate successfully, but the discount date will be set to 0/0/00. |
|
|
No warning will be issued if the transaction date falls within a period that has been closed. |
|
|
The following SOP functions are always allowed: Markdown, Allow Prices Below Cost, Override Prices, Override Quantity Shortages, and Override Price Levels. |
|
|
Customer credit limits and hold status are not checked during the integration process. |
|
|
General ledger account numbers that contain blank spaces cannot be handled by this adapter. |
|
|
Unit account distributions are not supported. |
|
Required Fields |
|
|
Sales Transaction |
Type Type ID Batch ID Customer ID |
|
Distributions |
Account Number Distribution Type Debit Amount Credit Amount |
|
Items |
Item Number |
|
Sales Tax Detail Summary |
Tax Detail ID |
The Financial module in the Microsoft Dynamics GP eConnect adapter contains destinations for GL Account and GL Transaction.
GL Account The GL Account destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
This destination is insert-only. It cannot be used to update existing General Ledger account records. |
|
|
Only posting accounts are supported. |
|
|
Account Currencies are not supported. |
|
|
Account Analysis Defaults are not supported. |
|
Required Fields |
|
|
GL Account |
Account Number Category |
GL Transaction The GL Transaction destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
|
|
|
This destination is insert-only. It cannot be used to update existing General Ledger account records. |
|
|
Only posting accounts are supported. |
|
|
Account Currencies are not supported. |
|
|
Account Analysis Defaults are not supported. |
|
Required Fields |
|
|
GL Transaction |
Batch ID Transaction Date Reference |
|
Entries |
Account Number Debit Amount Credit Amount |
The company module in the Microsoft Dynamics GP eConnect adapter contains destinations for Shipping Method.
Shipping Method The Shipping Method destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Shipping Method |
Shipping Method Shipping Type |
The Project Accounting module in the Microsoft Dynamics GP eConnect adapter contains destinations for Employee Expense and Timesheet Entry.
Employee Expense The Employee Expense destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Employee Expense |
Transaction Type Document No. Document Date Batch ID Employee ID Address ID Start Date End Date |
|
Line Entries |
Date Project Number Cost Category ID Currency ID Line Seq Num |
|
Tax Details |
Line Seq Num Tax Detail ID Tax Type |
Timesheet Entry The Timesheet Entry destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Timesheet Entry |
Transaction Type Document Number Document Date Batch ID Employee ID Rep Period Period Begin Currency ID |
|
Line Entries |
Date Project Number Cost Category ID |
|
Notes |
The PA Total Quantity field is required when values are entered into the field. |
|
|
The PA Reporting Suffix field is required and must be incremented if there is more than one timesheet for the same employee in the same reporting period. |
The Fixed Asset Manager module in the Microsoft Dynamics GP eConnect adapter contains destinations for Asset Book, Asset General Information, Asset Insurance, Asset Lease, and Asset User Data.
Asset Book The Asset Book destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Asset Book |
Asset ID Book ID |
|
Notes |
There are fields that become required depending on you map to the Asset Book. Depreciate to date Special depreciation allowance:
1=No;
2=Yes Special depreciation allowance percentage Luxury auto:
1=No;
2=Yes Luxury van or truck:
0=No;
1=Yes Luxury electric auto:
0=No;
1=Yes |
Asset General Information The Asset General Information destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Asset General Information |
Asset ID Description Class ID Acquisition Date |
|
Book |
Book ID |
|
Notes |
The Fixed Asset Account Group data is not available to be mapped when you run the FA General eConnect Destination in Integration Manager for Microsoft Dynamics GP. You can use the data from the Fixed Asset setup information in Microsoft Dynamics GP by using one of the following methods.
Method 1 Set up the Fixed Asset Class ID to have a default Account Group ID field in Microsoft Dynamics GP. 1. Open the Class Setup window (Microsoft Dynamics GP menu >> Tools >> Setup >> Fixed Assets >> Class). 2. Set up a class for the new assets or select an existing class. 3. Select an account group ID. 4. Click Save. 5. Map the Class ID field in the Asset General Information destination mapping folder in the Integration Manager Destination Mapping window.
The Asset Account Master (FA00400) table will be updated with the account group data that is associated with the class.
|
|
|
Method 2 Set up the default accounts for the company to have an account group ID in Microsoft Dynamics GP 1. Open the Fixed Assets Company Setup window (Microsoft Dynamics GP menu >> Tools >> Setup >> Fixed Assets >> Company). 2. Choose the Default Accounts expansion button to open the Default Accounts window. 3. Enter an account group ID. 4. Click OK. 5. Choose Save in the Fixed Assets Company Setup window.
You do not have to map any specific field within Integration Manager.
The Asset Account Master (FA00400) table will be updated with the account group data that is associated with the default account information in the Fixed Asset company setup. |
Asset Insurance The Asset Insurance destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Asset Insurance |
Asset ID |
Asset Lease The Asset Lease destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Asset Lease |
Asset ID |
Asset User Data The Asset User Data destination has the following properties.
|
Destination Edit Modes |
Insert Only |
|
Mapping Options |
None |
|
Restrictions |
None |
|
Required Fields |
|
|
Asset User Data |
Asset ID |