03-Excel integration英語講解課件

ExcelIntegrationQADEnterpriseEdition,AdvancedFinancialsLearnhowtouseExcelintegrationforLoadingandupdatingstaticdataLoadingtransactiondataObjectivesMC-1.4-1-XLS-020StaticdataGLAccounts(25.3.13.5)BusinessRelations(36.1.4.3.5)…TransactionaldataJournalentries(25.13.1.6)OverviewMC-1.4-1-XLS-030LoadLoadexistingdatatotheExcelIntegrationgridExporttoExcelformaintenanceCreateExcelfile(template)SystemViewSystemCodes(36.24.3.3)DisplaydatabasefieldnameExcelIntegrationUsesMC-1.4-1-XLS-040GLAccountExcelIntegration(25.3.13.5)Right-clickingridLoadAccountsExporttoExcelformaintenanceImportfromExcelChartofAccountsMC-1.4-1-XLS-050BusinessRelationExcelIntegration(36.1.4.3.5)Right-clickingridLoadbusinessrelationsExporttoExcelformaintenanceImportfromExcelBusinessRelationsMC-1.4-1-XLS-060CustomerExcelIntegration(27.20.1.5)Right-clickingridLoadCustomersExporttoExcelformaintenanceImportfromExcelCustomerDataMC-1.4-1-XLS-070SupplierExcelIntegration(28.20.1.5)Right-clickingridLoadSuppliersExporttoExcelformaintenanceImportfromExcelSupplierDataMC-1.4-1-XLS-080UptoQAD2009.1EEUploadnewbanknumbersonlyUnsuitableformassupdates(noLoadDataoption)FromQAD2010EENewLoadDataoptionCanbeusedformassupdatesBankNumbersMC-1.4-1-XLS-090MC-1.4-1-XLS-100LoadBankNumbersIndicatewhetheramodifiedrecordloadedusingBankNumberExcelIntegrationUpdatesanexistingrecordCreatesanewbanknumberrecordForloadeddata,thefieldisselectedifthebanknumberisnotyetusedinapaymentOtherwise,thefieldisblankExistingRecordFieldinExcelGridMC-1.4-1-XLS-110Fornewlyimporteddata,thefieldisblank,andthesystemcreatesanewbanknumberExistingRecordFieldinExcelGridMC-1.4-1-XLS-120ExportatemplatefromIncomingBankFileExcelIntegration(31.1.12)CompletethetemplatewithbankfiledataImporttoIncomingBankFileExcelIntegrationSavethefileandprocessitinProcessIncomingBankFiles(31.1.6)IncomingBankFilesMC-1.4-1-XLS-121Customer(27.1.10)/Supplier(28.1.15)TransferaccountCalculateBC/SCInvoicetypeAdjustment,Creditnote,Creditnotecorrection,Invoice,InvoiceCorrectionCustomers:Ship-to/Ship-FromSuppliers:InvoiceStatusCodeAllocationstatus:anyorallocatedOpeningBalanceCreateMC-1.4-1-XLS-130JEExcelIntegrationisdividedintoJournalEntryExcelIntegrationJournalEntryCross-CompanyExcelIntegrationJournalEntryExcelIntegrationRepairJournalEntriesMC-1.4-1-XLS-140JournalEntryExcelIntegration(25.13.1.6)Right-clickingridExporttoExcelformaintenanceImportfromExcelJournalEntryExcelIntegrationMC-1.4-1-XLS-150JECross-CompanyExcelIntegrationMC-1.4-1-XLS-152JournalEntryExcelCrossCoExcelIntegration(25.13.1.10)Right-clickingridExporttoExcelformaintenanceExportUnpostedtoExcelforMaintenanceImportfromExcelMC-1.4-1-XLS-Entity-LevelChildPosting–Entity10USACOLevel3-PostingLineAC10000012DR12,000Level3-PostingLineAC100400CR12,000Entity-LevelChildPosting–Entity11CANCOLevel3-PostingLineAC410001DR12,000Level3-PostingLineAC4100021CR12,000Level1–OverallPostingDetailsDesignedforusebysystemadministratorsandseniorstaffLetsyoubypasssomeofthevalidationsofstandardjournalentryDesignedforrepairactivitiesUsageExamplesManuallyadjustingroundingdifferencesoninventorycontrolaccountsManuallyadjustingerrorsininitialdataloadManuallyadjustinghistoricalARandAPbalancesatinitialdataloadJEExcelIntegrationRepairMC-1.4-1-XLS-160NOTforuseinDay-to-dayaccountingactivitiesCorrectingdiscrepanciesbetweenGLandAR/APThisrequiresinterventionbyQADSupport!JEExcelInteg