UserManualforKingdeeK/3WISEConsolidatedStatementStatementThecopyrightofthisdocumentresidesinKingdeeSoftware(China)Co.,Ltd.WithoutpriorwrittenpermissionobtainedfromKingdee,thisdocumentshallnotinanyformorbyanymeansbemodified,adapted,excerpted,translatedintootherlanguages,reproducedorrewritteninpartorinwholebyanyorganizationorindividual.KingdeeSoftware(China)Co.,Ltd.Preface.Theusermanualmainlycoversthefollowingcontents: Systemoverview Operationinstructions Detailedoperationprocesses Systemfunctionsandfeatures SystemsettingsThe“Preface”partofthismanualprovidesyouwiththeapproachofacquisitionofotherhelpfulinformationandtheagreementofcompilation.TargetReadersThismanualassumesthatyouhaverichworkexperienceandgoodmasteryofthefielditmentions,andhavecomprehensiveunderstandingoftheelementaryknowledgeofKingdeeK/3product.Ifyouhavenotusedthissystembefore,youarerecommendedtoreceiveoneormoresubsystem-trainingprogram(pleasecontactKingdee’sbranchofficesindifferentzone,soastogetmoretraininginformation).Ifyouhopetoacquirein-depthknowledgeaboutthesystem,forexample,systeminterface,etc.,pleasefamiliarizeKingdeeK/3systemarchitecture,MSSQLSERVERknowledgeandreadthetechnicaldocumentsofKingdeeK/3system.SourceofAssociatedInformationYoucanacquaintwithoursystemthroughthefollowingapproachesandacquirenecessaryserviceandassistance.1.OnlineInformationIfyouneedtoknowdynamicdevelopmentofKingdeeK/3productandexchangeproductapplicationsolution,pleasevisitourwebsiteatUhttp://www.kingdee.com/U.2.Pre-saleConsultingServiceForthesakeofenterprisedevelopmentandmanagementrequirement,Kingdeeprovidesmanagementconsultationandsolutionandhelpenterprisemakequickcorrectdecisions.3.ProductTrainingBasedontheprincipleoftechnicalinnovationandmanagementinnovation,Kingdeecontinuallyprovidescustomerswithcompleteindustrialsolution.Besidesexcellentproduct,Kingdeealsooffersassociatedtrainingservice,soastohelpusersgettwicetheresultwithhalftheeffortinsoftwareapplication.4.ExecutionofConsultingServiceAbsorbingtheexperienceofmorethan40,000customers,incombinationwithdomesticandforeignadvancedmanagementideaandapplicationmethodofmanagementsoftware,KingdeeintroducesthestandardsoftwareapplicationmethodincompliancewiththeactualsituationofChina—GoldFingerExecutionMethod.KingdeeiswillingtoutilizeourexperienceinenterprisemanagementandITtechnologytohelpyouscorecompletesuccess!5.FieldSupportServiceOurqualifiedprofessionalswillcommunicatewithyoufacetoface,makeprofoundfieldresearchandanalysisoftheissuesandfindoutasolutionimmediately.6.CRMServiceWiththeaidofcustomerrelationshipmanagementsystem(KingdeeEAS-CRM),Kingdeeestablishescustomercomprehensiveinformationmanagementlibrary,thusKingdeecansolvecustomers'problemsimmediatelyandkeepahistoricalrecordandprovidelong-term,sustainable,highefficientservice.7.CSPServiceSupportByintegratingyearsofexperienceandforeignadvancedmanagementidea,KingdeeabstractstheintegratedCSPservicethatiscommonlyusedandfrequentlyrequiredbycustomers,whichisthemostcompletesystematicserviceproductoftheindustrywithomni-bearingfunctionbasedonKingdee’sadvancedscientificandtechnologicalinstrumentandprofessionalserviceteam.8.CallCenterThroughcustomercallcenterservice(CallCenter),Kingdeecanprovideyouwithcompleteattentiveserviceandsolveyourapplicationproblemimmediately.9.IndividualizedServiceWithregardtothedemandofindividualizedservice,Kingdeeprovides“customized”serviceandutilizeallpossibleresourcestoprovideyouwithcomprehensiveapplicationsolutiontogetherwithpartners.10.ConvenientServiceKingdeeisnotonlyaproviderofsolution,butalsoaproviderofrelatedauxiliaryproduct.Kingdeeprovidestheconvenientservicethatexcludesyourdifficultyandanxietyofselectionandguaranteesthecompatibilityandconformityofrelatedproductandsystem.11.CooperationAllianceServiceKingdeeactivelycarriesoutstrategiccooperationwithotherleadingenterprisesofITindustryandprovideyouwithomni-bearingservice,forexample,enterprisemanagementconsulting,systemintegration,associatedtraining,etc.YoucannotonlygetKingdee’sserviceresourcehere,butalsohavethepriorityforsharingtheresourceofKingdee’spartners.12.VersionUpgradeServiceTheupgradeserviceenablesyoutomakeinflationproofandvalue-addedinvestmentwiththeprogressofthetimeandrealizethepurposeof“old-for-new”atpreferentialprice.KingdeeK/3ProductDesignIdeaKingdeeK/3takesbasicmanagementascoredesignidea,carriesoutoverallplanning,organizationandcoordinationofthebusinessflowthatcoversproduct(service)valuechain,aswellastheeffectivehandlingofbusinessandtheeffectivemanagementcontrol.Inlightofthecharacteristicsofstrategicmanagement,itemphasizesenterprise’smasterdata,basicbusinessflow,internalcontrol,knowledgemanagement,employee’sconductandsoon,integratesandprovidesalldecision-makinginformationrequiredinthewholecourseofstrategicmanagementthroughampleinstrumentandmethods,real-timemonitorstheproblemsoccurringinthecourseofstrategyimplementation,andhelpenterprisescreatecontinuallyincreasingcompetitivepower.Basemanagementisacornerstoneoftheenterprise'scontinuousmanagementpractice.Theeffectofbasemanagementdetermineswhethertheenterprise’sstrategicobjectivecanberealizedornotandalsodetermineswhethertheenterprise’ssustainabledevelopmenthasasolidfoundation.Itstressesthatprocessmanagementisthecharacteristicofbasemanagement,becauseitisthefirst-handmostdetaileddocumentthatcantrulyreflectbusinessprocessingprocedureandmaketheenterprise’sbusinessdecisionandstrategicdecisionbaseitselfupon“rationalknowledge”.AboutKingdeeKingdeeInternationalSoftwareGroupCompanyLimitedisaleadingproviderofbusinesssoftwareande-businessapplicationsolutionintheAsia-Pacificregion,andoneofthefast-growingISVinglobalsoftwaremarket,andaleadingcompanyofChinesesoftwareindustry.ThesoftwareproductdevelopedandsoldbyKingdeeincludesthebusinessmanagementsoftwarethatmeetsthedemandofbusinessmanagementofthefast-growingnewmarket,thee-businessapplicationsoftwarethatoffersserviceviaInternet,aswellasthemiddlewaresoftwareusedbyenterprisestoestablishe-businessplatform.Besides,Kingdeealsoprovidescustomersworldwidewithsoftware-relatedmanagementconsulting,implementationandtechnicalservice.Kingdee’sunique“fastconfiguration,fastimplementation,fastapplication,fasteffect”globalizedproductandservicepositioningcanhelpcustomersmeetthechallengeofever-changingcommercialenvironmentcalmly,realizetheperfectcombinationofbusinessflowandITtechnology,carryouteffectivemanagementinnovationandensuresustainablehealthygrowthoftheorganization.KingdeeInternationalSoftwareGroupCompanyLimitedisthecreatorofChina’sfirstaccountingsoftwarebasedonWINDOWS,firstpureJAVAmiddlewaresoftware,andfirstthree-tierERPsystembasedonInternetplatform.KingdeeK/3isthebusinesssoftwarewiththehighestoccupationratiointheERPmarketamongChinesesmallandmedium-sizedenterprises.InOctober2004,Kingdeeformallyreleasedthenewgenerationproduct—KingdeeEAS4.0(KingdeeEnterpriseApplicationSuite).KingdeeEASbasesitselfuponKingdeeBOS—thecommercialoperationsystemindependentlyresearchedanddevelopedbyKingdee.Ittargetsatlargeandsmall-sizedenterprises,adoptsthenewestERPIImanagementideaandintegrateddesign.Itiscomposedofover50applicationmodulesandcoversenterprise’sinternalresourcemanagement,supplychainmanagement,customerrelationshipmanagement,knowledgemanagement,commercialintelligence,etc.andrealizesthebusinesscoordinationamongenterprisesandtheapplicationintegrationofe-business.CompilationAgreement AgreementofGeneralFormatFormatDescriptionArialCharacterTextUnderlineInputinformationItalicsPromptingmessage AgreementofGraphicalInterfaceFormatFormatDescriptionWindownameGeneralmenuitemordendritestructuremenuitemButtoninthewindowBold,capitalinitialofsubstantiveOptionsinthewindow->Continuousselectionofmenuanditssubmenuordendritestructure AgreementofKeyboardOperationFormatDescriptionKey1KeynameonthekeyboardKey1+Key2Presstwokeyssimultaneously AgreementofMouseActionFormatDescriptionClickPressleftmouseandclickanobjectDouble-clickContinuallypressleftmousetwiceandopenanobjectRight-clickSelectanobjectandpressrightmouseDrag-dropNon-stoppressleftmouseandmovemousetodesignatedpositionthenreleasesthemouse SpecialSignsFormatDescriptionTipsRemindsusersofpossibleseriousconsequenceandcalluser’sattentiontouseitdiscreetly.NoteProvidessomeimportantdescriptionsExampleGivesanexamplesothatuserscanunderstanditveryclearlyPrerequisiteReferstotheoperationthatmustbecompletedbeforeacertainoperation.DefinitionDefinesfinancialorcomputertermsthatappear.DescriptionofSymbolsofFlowChartThismanualusesEPC(Event-driven-ProcessChain)todepictthemainbusinessflow.EPCreferstoEvent-driven-ProcessChain.Throughconnectingtoeventandtask,userscansetupthemoduleofcomplicatedbusinessflowandmakeananalysis.EPCmethodnotonlyusesintelligiblesymbolsandlanguagetohelpusersandconsultantsdescribebusinessinformationsystem,butalsointegratesorganizationalstructure,function,dataandinformationflow.EPCmodulecandemonstratehowtheinterruptionoftaskchainandliabilitychainaffectsacompany’sabilitytooptimizeitsbusinessflow.Bymatchingtheorganizationwitheachtask,userscanseewhichdepartmentorpostisinvolvedwiththeflowveryconveniently.ConcerningthedescriptionofthesymbolsmentionedinEPCchart,seethetablebelow:NameIconDefinitionExampleEventDescribesthehappeningofthestateofaffairs,andoppositelyactsasatrigger.ReceivinganoriginalvoucherFunctionDescribestheconversionfrominitialstatetofinalstate.EnteringavoucherOrganizationUnitDescribestheenterprise’sstructureroughly.AccountingoffinancialdepartmentInformation,Material,ResourceObjectDescribestheobjectinrealworld(forexample,businessobject,andmaterialobject).AccountRouteDisplaystheprecedencerelationshipofconnectionofdifferentflows(navigationassistance).VoucherprocessingprocedureLogicOperationalCharacterVVXORDescribesthelogicrelationshipbetweeneventandfunctionorflow.“XOR”:Onehastomakeexclusivechoicefrommultipleflows.“V”:Itstandsfor“or”relation.“Λ”:Itstandsfor“and”relation.ControlFlowDescribestheprecedenceandlogicdependencyrelationshipbetweeneventandfunctionorflow.InformationFlow,MaterialsCirculationDefineswhetherafunctioncanberead,alteredorwritten.AllocationofResource,OrganizationUnitDescribeswhichunit(staff)orresourcecanbeusedtoprocessacertainfunctionorflow.FeedbackThankyouforselectingourproductandusermanual.Thismanualisaccompaniedwiththeopinionfeedbackform.YoucanputforwardyouropinionandsuggestiononourproductorusermanualandreturnsittousbyKingdee’sbranchofficeordirectlysendsittoK/3ProductDepartmentbyfaxat+8675526615016.Kingdeeislookingforwardtoyoursuggestionandopinion.TableofContentsChapter1SystemOverview..11.1AboutThisModule..11.2PositionintheK/3ERPSystem..51.3InterfacingwithOtherModules.5Chapter2MainProcessesandCriteria..92.1GeneralBusinessProcess..92.2SystemInitialization..102.3PreparingaStatement(ontheInternet)atSubsidiaryLevel..152.4PreparingaStatement(inaFile)atSubsidiaryLevel..182.5ConsolidatingStatementsatGroupLevel..21Chapter3ImplementationGuide..253.1Preparations..253.2Initialization.263.3ApplicationDeploymentMode..27Chapter4ModuleManagement..334.1Installation.334.2CreatinganA/CSet..354.3PermissionManagement..384.4ParameterSettings.414.5NavigationMapandWorkflowManagement..43Chapter5KeyMasterDataSettings.455.1CompanyList..455.2ConsolidationScheme..475.3ReportItems..535.4StatementTemplate..55Chapter6StatementCheckSystem.836.1BasicSettings.836.2StatementCheckMechanism.90Chapter7PreparingFlashReports..957.1BasicSettings.967.2ExecutingFlashReports.997.3QueryingFlashReports..100Chapter8ReportPreparationatSubsidiaryLevel(Network)..1018.1LoggingIntotheConsolidatedStatementPlatform.1018.2ModifyingtheStatementTemplate.1028.3PreparingIndividualStatements.1038.4Pre-SubmissionCheck.1128.5SubmittingaStatement.1128.6De-SubmittingaStatement.113Chapter9ReportPreparationatSubsidiaryLevel(File)..1159.1RelatedSettingsinFileApplication..1159.2FileApplicationinAbsenceofNetworkAccess..1169.3FileApplicationinCaseofNetworkAccess.120Chapter10ReceivingandCheckingStatements..12310.1MonitoringStatementProgress..12310.2ReceivingStatements.12710.3CheckingStatements..128Chapter11ForeignCurrencyConversion.13111.1ProcessforForeignCurrencyConversion..13111.2SettingMasterData..13211.3PreparingForeignCurrencyStatements..13611.4ConvertingForeignCurrencies.136Chapter12GroupStatementAdjustment..13912.1SettinganAdjustmentEntryTemplate.13912.2AdjustingaStatementattheGroupLevel..141Chapter13OffsetProcessing.14513.1ManualOffsetProcessing.14513.2AutomaticOffsetofInternalTransactions.14913.3AutomaticOffsetofInternalEquityInvestment.16113.4OffsetEntrySummary.17513.5TroubleshootingofOffsetSheets.177Chapter14ProportionalConsolidation..17914.1Process.17914.2SettingMasterData..18014.3RecalculatingaSummaryStatementandaWorkingPaper..181Chapter15PreparingaSummary/ConsolidatedStatement..18315.1PreparingaSummaryStatement..18315.2PreparingaWorkingPaper.18715.3PreparingaConsolidatedStatement..18915.4ReportingStatementsatSub-groupLevel..19115.5FilingaStatement.191Chapter16QueryandStatementAnalysis..19316.1OverviewoftheQueryFunction.19316.2StatementMaintenance..19416.3DataQuery..19616.4PackageQuery.19916.5CustomizingaStatement..20216.6AccessFormulasforConsolidatedStatements..203Chapter17GeneralStatementOperations..21317.1FormatEditing.21317.2UsingData..22117.3PageSetting..22617.4VBAandMacro.228Chapter18SystemTools.23518.1RemoteLoginConfigurationTool.23518.2OnlineUpgradeToolforStatementClient..23818.3A/CSetUpgradingTool..23918.4AccessTypeUpgradingToolforOffsetEntry..24018.5Pre-setTemplateImportingTool..24118.6ItemDataEditingTool..24218.7ItemDataBackupTool.24318.8SharedItemCheckingTool..244AppendixA..245AppendixB..249UserManualforKingdeeK/3WISEConsolidatedStatementChapter1SystemOverview1Chapter1SystemOverview1.120BAboutThisModuleFinanceconsolidationisabigtopicfacingthefinanceandaccountingpersonnelofagroup.Thebasicrequirementsforgroupfinancialmanagementarenodoubtasfollows: Tomeetallrulesandcriteria Toprovidetimelyandaccuratefinancialstatements Tofulfillalldatarequestsintermsofservicetype,capitalstructure,andorganizationarchitectureKingdeeK/3consolidatedstatementmodulesetsupanorganizationarchitecturebasedfinancialstatementsystemtocollectthestatementdataateachlevelofagroup.Itensuresatimely,true,andaccurategroupfinancialstatement.Themoduleadjustsandautomaticallyoffsetstheinternaltransactionitems,thusreflectingtheoverallgroupoperationstrulyandweighingtheachievementsandperformancesofeachsubsidiaryaccurately.Itthenpreparesconsolidatedstatementsandsummaryreports,consolidatingthegroupstatements.Themodulesupportscurrencyconversionandstatementanalysisinaconsolidatedstatement.Themoduleprovidesthefollowingfunctions: Centralizedstorage,onlinetransmission,andunifiedmanagementofstatementdata Robuststatementcontrolsandrichstatementoperations Managementofconsolidatedstatementworkflow Full-automaticpreparationofquickstatements Proprietorshipmanagement Multi-dimensionalconsolidationinmultipleapproaches Customreportitems Presetstatementtemplates Inventivedynamicstatisticalstatements Amplepre-submissionchecks Currencyconversionagainstmultipleexchangeratesystems Full-automaticconsolidationoffsetChapter1SystemOverviewUserManualforKingdeeK/3WISEConsolidatedStatement21.1.194BCentralizedStorage,OnlineTransmission,andUnifiedManagementofStatementDataThemoduleprovidescentralizedonlinedatamanagement.Itkeepsallstatementdataatgrouplevel.EachsubsidiarysubmitstheirstatementdatathroughtheconsolidatedstatementplatformandInternet.Themanagementcostincurredindatadistributionthusdecreasessignificantly.Areliableandstableintra-groupdatatransmissionisensured.ThemodulerunseitherinconjunctionwithorindependentofKingdeeK/3ERP.Intheformercase,itaccessesdatadirectlythroughaccessformula,reducingthemanualpreparationload.Inthelattercase,itimportsdatadirectlyfromExceldatasheets.1.1.295BRobustStatementControlsandRichStatementOperationsWithrobuststatementcontrolsdevelopedbyKingdeeindependently,themodulesupportsmulti-taboperations.ItprovidesnotonlythespecialKingdeestatementfeaturesbuttheExceldatasheetfunctions.ItfeaturesthesameinterfacesandoperationstylesasExcel,suitingmostfinancepersonnelwhoareusedtoExcel.1.1.396BManagementofConsolidatedStatementWorkflowAconsolidatedstatementinvolvesallsubsidiariesofagroup.Toensureatimelyandnormativeconsolidatedstatement,theentireconsolidatedstatementworkflowshallbeundereffectivemanagement.Themoduleprovidesthefollowingworkflowmanagementfunctions: Navigationchart Statementprogressmonitoring Conveyofstatementprogressthroughe-mailandSMSThemodulethusoffersaneffectivemanagementplatformtoconsolidatedstatementmanagers.1.1.497BFull-automaticPreparationofQuickStatementsThemodulepreparesaquickstatementFull-automatically,submittingtheoperationdataofeachsubsidiarypromptlyandaccurately.Youonlyneedtosetupaquickstatementschemeandstatementtemplate.ThemoduleaccessesandconsolidatesthedatainthesubsidiaryA/Csetsintoastatementautomaticallywithoutmanualinfluence.Thestatementdatareachesyouasrequiredatthepresettime.UserManualforKingdeeK/3WISEConsolidatedStatementChapter1SystemOverview398B1.1.5ProprietorshipManagementAconsolidatedstatementiscertainlyrelatedtoequityinvestment.Boththeconsolidationrangeandtheequityoffsetdependonequityinvestment.Themodulemanagesgroupproprietorshipandinvestmentchangesclosely.Itreadilyprovidesanyequitiesofinvestorsandinvesteesasthereferenceforinvestmentandstatementconsolidation.Formoreinformationonproprietorshipmanagement,see-Settingproprietorship-inthismanual.1.1.699BMulti-DimensionalConsolidationinMultipleApproachesThemodulepreparesconsolidatedstatementsinmultipledimensions,helpingthefinancepersonnelprovidefinancialstatementsforbothexternalinvestorsandgovernmentsandinternalmanagement.Examplesofthedimensionsincludeinvestmentequity,businessregion,andproductline.Inaddition,themodulesupportstwoconsolidationapproaches:sequentialconsolidationandsynchronousconsolidation.Thesequentialconsolidationreferstoconsolidatingdataonthebasisof3-levelorganizationarchitecture.Thethreelevelsincludethesubsidiaries,thesubsidiarygroups,andthegroup.Thesynchronousconsolidationreferstoconsolidatingdataonthebasisof2-levelorganizationarchitecture.Thetwolevelsincludethesubsidiariesandthegroup.Allthesubsidiariesunderthegroupareatonelevel.Thetwoapproacheshavetheirrespectivefeatures.Thesequentialconsolidationhelpsboththegroupandthesubsidiarygroupspreparec.
