问题描述
DynamicsAX2012Ledgertransactions/balancesImportusingExcelAdd-inDynamicsAX2012ExcelAdd-in–Ledgertransactions/balancesImportPurpose:ThepurposeofthisdocumentistoillustratehowtouseMicrosoftDynamicsAX2012ExcelAdd-inforimportofledgertransactions.Challenge:DatamodelchangesinMicrosoftDynamicsrelatedtohighnormalizationandintroductionofsurrogatekeysmadesomeimportsmorecomplex.InfactthedatamodelformingGeneralJournalwasnotdramaticallychangedandimportprincipleremainsthesame–populatethejournalandthenpostthejournal.HoweversomeinformationwhichisusuallyautomaticallygeneratedinMicrosoftDynamicsAX2012RichClientbymeansofnumbersequencessuchasvouchernumberwillhavetobeprovided.Solution:MicrosoftDynamicsAX2012shipswithGeneralJournalAIFWebService(LedgerGeneralJournalService)whichcanbeusedinintegrationscenarios.AlsoGeneralJournalAIFWebServicecanbeusedinExcelforimportofledgertransactions.InordertoimportledgertransactionsusingExcelthementionedAIFWebServicewillbeused.Assumption:Theassumptionisthatappropriatereferencedatasuchasmainaccounts,etc.wascreatedinadvance.DataModel:TableNameTableDescriptionLedgerJournalTableTheLedgerJournalTabletablecontainsallthedefaultingandstateinformationpertainingtoasinglejournal.ThetransactiondetailsofajournalaremanagedintheLedgerJournalTranstable.LedgerJournalTransTheLedgerJournalTranstablecontainsthetransactiondetailinformationthatpertainstoasinglejournal.Theindividualtransactionlinesarealsoreferredtoasvoucherlines.ThejournalisarecordintheLedgerJournalTabletable.DataModelDiagram:Walkthrough:ConnectionAddDataFieldChooserAccountingstructureLedgerJournalTableFieldNameFieldDescriptionJournalbatchnumberNameDescriptionLedgerJournalTransFieldNameFieldDescriptionJournalbatchnumberVoucherDateCompanyaccountsAccounttypeLedgerDimensionLedgerDimension.MainAccountLedgerDimension.DepartmentDescriptionDebitCreditCurrencySequence:1.PublishAllResult:DynamicsAX–GeneralJournalDynamicsAX–GeneralJournallinesDynamicsAX-PostingSQLTrace:Summary:Forthepurposesofsmallormediumdatamigration(dataconversion)whereperformanceisnotaconcernExcelcanbeusedforimportofledgertransactionsintoMicrosoftDynamicsAX2012.GeneralJournalAIFWebService(LedgerGeneralJournalService)canbeusedinExcelforimportofledgertransactions.Exceltemplatecanbecreatedandusedforimportofledgertransactions.Author:AlexAnikiev,PhD,MCPTags:DynamicsERP,DynamicsAX2012,Excel,DynamicsAX2012ExcelAdd-in,DataImport,DataConversion,DataMigration,ApplicationIntegrationFramework,Ledgerbalances.Note:Thisdocumentisintendedforinformationpurposesonly,presentedasitiswithnowarrantiesfromtheauthor.Thisdocumentmaybeupdatedwithmorecontenttobetteroutlinetheconceptsanddescribetheexamples.It’srecommendedthatallDataModelchangesintroducedasapartofthisdemonstrationwillberemovedonceyoucompletedataimportexercise.