The EcoResProductVariantSize table stores information about the sizes that are assigned to product variants. The EcoResProductVariantColor table stores information about the colors that are assigned to product variants. The EcoResProductMasterConfiguration table stores information about configurations assigned to product masters. The EcoResProductMasterSize table stores information about sizes that are assigned to product masters. The EcoResProductMasterColor table stores information about colors assigned to product masters. The EcoResConfiguration table stores configuration names. The EcoResColor table stores color names. The EcoResProductDimensionGroupProduct table stores information about relationships between products and dimension groups.
The EcoResProductDimensionGroup table contains information about a dimension group. The EcoResDistinctProductVariant table stores product variants. The EcoResDistinctProduct table stores products. The EcoResProductIdentifier table contains a product identification that is available for users. The EcoResProductMaster table stores product masters. The EcoResProduct table stores products and is the base table in the products hierarchy. In order to import a product with product definition information using Excel the appropriate tables will be used.Īssumption: The assumption is that appropriate reference data such as item groups, etc. However Item AIF Web Service can’t be used in Excel at the moment for import of products.
Solution: Microsoft Dynamics AX 2012 ships with Item AIF Web Service (InventItemService) which can be used in integration scenarios. Please note that in Dynamics AX 2012 Rich Client product definition is automatically created when released product is created using decentralized approach. In order to create a product in Microsoft Dynamics AX 2012 both product definition and released product information will have to be provided.
#Microsoft dynamics pos excel integration how to
Purpose: The purpose of this document is to illustrate how to use Microsoft Dynamics AX 2012 Excel Add-in for import of products.Ĭhallenge: Data model changes in Microsoft Dynamics related to high normalization and introduction of surrogate keys made import of products more complex.