You can set up destination mappings for Analytical Accounting integrations that use destinations in the Microsoft Dynamics GP eConnect adapter. The following mapping tables describe each field in each recordset of the Analytical Accounting destinations. Each table contains the following information.
Field
Name The name of the field in the
Integration Mapping window.
Data
Type The type of data in each
field.
Length The number
of characters that can be stored in the field.
Required States
whether the field is required.
Be sure that you have atransaction/document number when you map your destinations.
You can map Analytical Accounting integrations for the following destinations: Inventory Transaction, Receivings Transaction Entry, Sales Transaction, and GL Transaction. Each of these destinations contain the following recordsets.
Analytics recordset |
|||
Field Name |
Data Type |
Length |
Required |
Account Number |
string |
75 |
No |
Assign ID* |
long integer |
4 |
No |
Amount* |
numeric |
14 |
No |
Assigned Percent* |
numeric |
14 |
No |
Reference |
string |
30 |
No |
Note |
string |
32768 |
No |
*Not available in the Inventory Transaction Destination |
Dimensions recordset |
|||
Field Name |
Data Type |
Length |
Required |
Transaction Dimension |
string |
30 |
No |
Transaction Dimension AlphaNumeric Code |
string |
30 |
No |
Transaction Dimension Numeric |
numeric |
14 |
No |
Transaction Dimension Boolean |
boolean |
2 |
No |
Transaction Dimension Date |
date |
8 |
No |
Transaction Dimension ID |
long integer |
4 |
No |
Transaction Dimension Code ID |
long integer |
4 |
No |