User Guide : Map Connectors : Source and Target Map Connectors : Microsoft Dynamics AX 4
 
Share this page                  
Microsoft Dynamics AX 4
Microsoft Dynamics AX is an enterprise resource planning software product. This connector reads and writes data from and to Dynamics AX 4 as a web service.
Limitations
Upserts are not supported at this time.
Property Options
You can set the following source (S) and target (T) properties.
Property
ST
Version
Description
BatchResponse
T
4
Optional. Creates a Batch Response file, which is a reporting mechanism for the connector. The file provides detailed results for each object in a batch where the batch size is greater than 1. Obtaining detailed results is useful in the following cases:
• You need to capture system-generated object IDs for use in future updates.
• You need to correlate an error with its object and have enough information about the error for exception handling and error diagnosis.
• For more information, see "Batch Response File".
BatchSize
S
4
Optional. Number of source records the connector caches before processing them in a map. Default is zero.
Flush Frequency
T
4
Leave setting as default, since you cannot change this setting.
Page Size
S
4
The number of records stored in memory.
DestinationEndpoint
ST
4
The receiver of the message.
SourceEndpoint
ST
4
The sender of the message.
SourceEndpointUser
ST
4
The user who sends the message. The endpoint user is defined by the Windows account of the endpoint user in a Domain\User format.
ShowChildren
ST
4
Determines whether to add the child record types to the list of available record types.
• False – List only the parent-level record types.
• True – Include child record types.
The following table lists all Microsoft Dynamics AX 4 entities and the supported and unsupported actions.
Entity Name
Create
Read
Update
Delete
ASN
No
Yes
No
No
Address
Yes
Yes
Yes
Yes
CashDisc
No
Yes
No
No
ChartofAccounts
Yes
Yes
No
No
ConfigTable
No
Yes
No
No
ContactPersons
Yes
Yes
No
Yes
Customer
Yes
Yes
Yes
Yes
CustomerGroups
No
Yes
No
No
DeliveryModes
No
Yes
No
No
Dimensions
Yes
Yes
No
No
ExchangeRates
No
Yes
No
No
InventColor
No
Yes
No
No
InventDimCombination
No
Yes
No
No
InventItemGroup
No
Yes
No
No
InventLocation
No
Yes
No
No
InventSize
No
Yes
No
No
InventoryOnhand
No
Yes
No
No
InventoryTransactions
No
Yes
No
No
Item
Yes
Yes
No
No
PaymentTerms
No
Yes
No
No
PurchaseRequisition
No
Yes
No
No
SalesInvoice
No
Yes
No
No
SalesOrder
Yes
Yes
No
No
Unit
No
Yes
No
No
UnitConvert
No
Yes
No
No
Debugging Tips
See the Microsoft Dynamics AX exception log, a valuable resource to consult when something does not work as expected, under Basic > Periodic > Application Integration Framework > Exceptions.
Source Schema
To view the structured schema of a Microsoft Dynamics AX 4 source table, select the Source Schema icon in the toolbar.
Target Schema
To set up the structured schema of a Microsoft Dynamics AX 4 target table, select the Target Schema icon in the toolbar.
Type
These are the data types of the fields in a table. If you are appending data to an existing table, the data type of each field uses the data type in the selected table by default.
The data types displayed for the fields of tables available in Microsoft Dynamics AX are the defaults specified by the web service interface.
• boolean
• byte
• date
• datetime
• decimal
• double
• float
• int
• short
• string
Note:  To insert or update a date value in a Microsoft Dynamics CRM application: On the application server, open the Microsoft Dynamics Exceptions Console. If there are any exception errors related to date fields, enter zeroes for the hour, minute, and second values.