ax2012 导入产品的方法

《ax2012 导入产品的方法》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、DynamicsAX2012ExcelAdd-in–ProductsImportPurpose: ThepurposeofthisdocumentistoillustratehowtouseMicrosoftDynamicsAX2012ExcelAdd-inforimportofproducts.Challenge:DatamodelchangesinMicrosoftDynamicsrelatedtohighnormalizationandintroductionofsurrogatekeysmadeimportofprodu

2、ctsmorecomplex.InordertocreateaproductinMicrosoftDynamicsAX2012bothproductdefinitionandreleasedproductinformationwillhavetobeprovided.PleasenotethatinDynamicsAX2012RichClientproductdefinitionisautomaticallycreatedwhenreleasedproductiscreatedusingdecentralizedapproach

3、.Solution:MicrosoftDynamicsAX2012shipswithItemAIFWebService(InventItemService)whichcanbeusedinintegrationscenarios.HoweverItemAIFWebServicecan’tbeusedinExcelatthemomentforimportofproducts.InordertoimportaproductwithproductdefinitioninformationusingExceltheappropriate

4、tableswillbeused.Assumption:Theassumptionisthatappropriatereferencedatasuchasitemgroups,etc.wascreatedinadvance.DataModel:TableNameTableDescriptionEcoResProductTheEcoResProducttablestoresproductsandisthebasetableintheproductshierarchy.EcoResProductMasterTheEcoResProd

5、uctMastertablestoresproductmasters.EcoResProductIdentifierTheEcoResProductIdentifiertablecontainsaproductidentificationthatisavailableforusers.EcoResDistinctProductTheEcoResDistinctProducttablestoresproducts.EcoResDistinctProductVariantTheEcoResDistinctProductVariant

6、tablestoresproductvariants.EcoResProductDimensionGroupTheEcoResProductDimensionGrouptablecontainsinformationaboutadimensiongroup.EcoResProductDimensionGroupProductTheEcoResProductDimensionGroupProducttablestoresinformationaboutrelationshipsbetweenproductsanddimension

7、groups.EcoResColorTheEcoResColortablestorescolornames.EcoResSizeTheEcoResSizetablestoressizenames.EcoResConfigurationTheEcoResConfigurationtablestoresconfigurationnames.EcoResProductMasterColorTheEcoResProductMasterColortablestoresinformationaboutcolorsassignedtoprod

8、uctmasters.EcoResProductMasterSizeTheEcoResProductMasterSizetablestoresinformationaboutsizesthatareassignedtoproductmasters.EcoResP