Microsoft Dynamics GP eConnect destination mappings for Analytical Accounting

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.

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



Documentation Feedback