UserManualforKingdeeK/3WISEReportStatementThecopyrightofthisdocumentisownedbyKingdeeSoftware(China)Co.,Ltd.Nopartofthisdocumentmaybealtered,reproduced,excerpted,translated,reprintedorrewritteninanyformorbyanymeanswithoutpriorwrittenconsentofKingdee.KingdeeSoftware(China)Co.,Ltd.-1-PrefaceThemanualisorganizedinthefollowingsections,helpingyoutoeffectivelyusetheReportmodule: GeneralDescription Instructions Procedures Functions&Features SystemSettingsThePrefaceprovidesyouwiththewaytoobtainotherhelpfulinformationaswellastheconventions.TargetReadersThismanualisintendedforuserswhohavesolidworkexperienceandexpertiseintherelatedareaandknowthebasicsoftheKingdeeK/3system.Beforefirsttimeuse,itisrecommendedthatyouattendoneormoreourtrainingprograms.Formoreinformationaboutthetraining,pleasecontactourlocalKingdeeoffice.Tolearnmoredetailsaboutthesystem,suchasuserinterfaces,pleasefamiliarizeyourselfwiththeKingdeeK/3systemandtheMSSQLSERVER,andreadthetechnicaldocumentationthatcomeswiththeKingdeeK/3system.SourcesofRelevantInformationYoumayacquaintyourselfwithoursystemandgetserviceandhelpthroughthefollowingchannels.1.OnlineTokeepyourselfuptodatewithourlatestKingdeeK/3products,applicationsandsolutions,pleasevisitourwebsiteathttp://www.kingdee.com/.2.Pre-saleConsultingTomeetenterprises’developmentandmanagementneeds,weprovidemanagementconsultationandsolutions,helpingenterprisestomakequickandrightdecisions.3.ProductTrainingTostayattheforefrontoftechnologicalandmanagementinnovations,Kingdeeiscommittedtoprovidingcustomerswithholisticindustrialsolutions.Inadditiontoitswiderangeofqualityproducts,Kingdeealsoofferscomprehensivetraining,helpinguserstoquicklydeploytheirsoftwareapplications.4.ConsultingBasedontheextensiveexperienceofmorethan10,000customersaswellasadvancedmanagementideasandmanagementsoftwareapplicationsworldwide,KingdeehasdevelopedGoldenFingerImplementationMethodology,asoftwareapplicationmethodologythatsuitsChina’sactualsituation-.KingdeehasnohesitationinhelpingyouachievemoresuccessbyleveragingitssolidexperienceandexpertiseinenterprisemanagementandITtechnology.5.FieldSupportOurqualifiedprofessionalsarealwaysreadytodiscusswithyoufacetofaceaboutanyissuesandconductfieldresearchandanalysistoworkoutarightsolutionimmediately.6.CRMServiceByutilizingtheKingdeeEAS-CRM,apowerfulcustomerrelationshipmanagementsystem,Kingdeehasestablishedacomprehensivecustomerinformationmanagementlibrary,enablingKingdeetosolvecustomers’problemsimmediately,tomaintainanexhaustivecustomerrecordandtoprovidecustomerswithlong-term,sustainable,efficientservices.7.CSPService-2-Kingdeereliesonitsyearsofexperienceandstate-of-the-artmanagementpracticestoprovideintegratedCSPservicethatbestsuitscustomers’need.Astheindustry’smostholisticservice,theCSPisdistinguishedbyafullrangeoffeaturesthatbuildonKingdee’scutting-edgetechnologyandprofessionalserviceteam.8.CallCenterThroughcustomercallcenter,weprovideyouwithattentiveserviceandrespondtoyourquestionsandconcernsquickly.9.PersonalizedServiceInresponsetocustomers’needforpersonalizedservice,weprovidecustomizedserviceandutilizealltheresourcesavailabletoofferyoufull-featuredapplicationstogetherwithourpartners.10.ConvenientServiceAsaproviderofbothsolutionsandproducts,weofferyoueasyaccesstoourservices,removingyourworryofchoosingfromawideselectionofsolutionswhileatthesametimeensuringthecompatibilityandintegrityofourproductsandsolutions.11.PartnershipWearelookingtoforgestrategicpartnershipwithotherITindustryleadersinordertoprovideyouwithanextensivearrayofservices,includingenterprisemanagementconsulting,systemsintegration,trainingandmore.InadditiontoKingdee’sbroadserviceportfolio,youalsogainaccesstoservicesofferedbyKingdee’spartners.12.UpgradeOurupgradeserviceenablesyoutomitigateinflationrisks,toprotectyourvalue-addedinvestmentovertime,andtocost-effectivelyupgradeyoursystem.ProductDesignBasedonthebasemanagementphilosophy,KingdeeK/3incorporatesrobustmanagementcapabilities,includingbusinessflowplanning,organization,andcoordinationacrosstheproduct(service)valuechainaswellaseffectivebusinessandmanagementprocedures.Intermsofstrategicmanagement,thesystemfocusesonenterprises’masterdata,basicbusinessflows,internalcontrol,knowledgemanagement,employee’sconduct.Additionally,itprovidestheabilitytosupplyalltheinformationrequiredfordecision-makingthroughoutstrategicmanagementproceduresbyutilizingawidevarietyoftoolsandmethodsandtomonitortheproblemsarisingoutofstrategyimplementationinrealtime,thushelpingenterprisestosharpentheircompetitiveedge.-3-Acornerstoneoftheenterprise'scontinuousmanagementpractice,basemanagementdetermineswhethertheenterprise’sstrategicobjectivescanberealizedandwhethertheenterprise’sdevelopmentisreallysustainable.Thismanagementpracticefeaturesprocessmanagement,becauseitprovidesfirst-handdocumentsthatcantrulyreflectbusinessproceduresandhelpsmakebusinessandstrategicdecisionsthroughrationalknowledge.AboutKingdeeKingdeeInternationalSoftwareGroupCompanyLimitedisaleadingproviderofbusinesssoftwareande-businessapplicationsolutionintheAsia-Pacificregion,andoneofthefast-growingISVinglobalsoftwaremarket,andaleadingcompanyofChinesesoftwareindustry.ThesoftwareproductdevelopedandsoldbyKingdeeincludesthebusinessmanagementsoftwarethatmeetsthedemandofbusinessmanagementofthefast-growingnewmarket,thee-businessapplicationsoftwarethatoffersserviceviaInternet,aswellasthemiddlewaresoftwareusedbyenterprisestoestablishe-businessplatform.Besides,Kingdeealsoprovidescustomersworldwidewithsoftware-relatedmanagementconsulting,implementationandtechnicalservice.Kingdee’sunique“fastconfiguration,fastimplementation,fastapplication,fasteffect”globalizedproductandservicepositioningcanhelpcustomersmeetthechallengeoftheuncertaincommercialenvironmentcalmly,realizetheperfectcombinationofbusinessflowandITtechnology,carryouteffectivemanagementinnovationandensurefast,sustainableandhealthygrowthoftheorganization.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.-4-CompilationAgreement AgreementofGeneralFormatFormatDescriptionArialCharacterTextInputMessageItalicPromptMessage AgreementofGraphicalInterfaceFormatFormatDescriptionWindowname.Generalmenuitemordendritestructuremenuitem.Buttoninthewindow.BoldOptionintheform.->Continuousselectionofmenuanditssubmenuordendritestructure. AgreementofKeyboardOperationFormatDescriptionKey1Keynameonthekeyboard.Key1+Key2Presstwokeyssimultaneously. AgreementofMouseActionFormatDescriptionClickPressleftmouseandclickanobject.Double-clickContinuallypressleftmousetwiceandopenanobject.Right-clickSelectanobjectandpressleftmouse.Drag-dropNon-stoppressleftmouseandmovemousetodesignatedpositionthenreleasesthemouse. SpecialSignsFormatDescriptionCautionRemindsusersofpossibleseriousconsequenceandcalluser’sattentiontouseitdiscreetly.NoteProvidessomeimportantdescriptions.ExampleGivesanexamplesothatuserscanunderstanditveryclearly.PreconditionReferstotheoperationthatmustbecompletedbeforeacertainoperation.DefinitionDefinesfinancialorcomputertermsthatappear.DescriptionofSymbolsofFlowChartThismanualusesEPC(Event-driven-ProcessChain)todepictthemainbusinessflow.EPCreferstoEvent-driven-ProcessChain.Throughconnectingtoeventandtask,userscansetupthemoduleofcomplicatedbusinessflowandmakeananalysis.EPCmethodnotonlyusesintelligiblesymbolsandlanguagetohelpusersandconsultantsdescribebusinessinformationsystem,butalsointegratesorganizationalstructure,function,dataandinformationflow.EPCmodulecandemonstratehowtheinterruptionoftaskchainandliabilitychainaffectsacompany’sabilitytooptimizeitsbusinessflow.Bymatchingtheorganizationwitheachtask,userscanseewhichdepartmentorpostisinvolvedwiththeflowveryconveniently.ConcerningthedescriptionofthesymbolsmentionedinEPCchart,seethetablebelow:-5-NameIconDefinitionExampleEventItdescribesthehappeningofthestateofaffairs,andoppositelyactsasatrigger.ReceivingoriginalvoucherFunctionsItdescribestheconversionfrominitialstatetofinalstate.NewVoucherOrganizationUnitItdescribestheenterprise’sstructureroughly.AccountantoffinancialdepartmentInformation,Material,ResourceObjectItdescribestheobjectinrealworld(forexample,businessobject,andmaterialobject).AccountRouteItdisplaystheprecedencerelationshipofconnectionofdifferentflows(navigationassistance).VoucherhandlingprocedureLogicOperationalCharacterItdescribesthelogicrelationshipbetweeneventandfunctionorflow.“XOR”:Onehastomakeexclusivechoicefrommultipleflows.“V”:Itstandsfor“or”relation.“Λ”:Itstandsfor“and”relation.ControlFlowItdescribestheprecedenceandlogicdependencyrelationshipbetweeneventandfunctionorflow.InformationFlow,MaterialsCirculationItdefineswhetherafunctioncanberead,alteredorwrittenin.AllocationofResource,OrganizationUnitItdescribeswhichunit(staff)orresourcecanbeusedtoprocessacertainfunctionorflow.FeedbackThankyouforusingourproductandusermanual.ThismanualisdeliveredtogetherwithafeedbackformYouarehighlyappreciatedtoindicateyouropinionsandsuggestionsonourproductorusermanualandsendtheformtoourlocalKingdeeofficeorfaxittoourK/3ProductDepartmentat+86-755-26615016.Kingdeeislookingforwardtoyoursuggestionsandopinions.TableofContentsChapter1OverviewofThisModule.11.1AbouttheModule.11.1.1FlexibleAccessSettings..21.1.2AmplePresetReportTemplates..21.1.3Multi-accountSetAccessManagement.21.1.4Multi-sheetManagementandSummary..21.1.5MassCopy.21.1.6AnalysisofReports..21.1.7AssociatedQueryofReports.21.1.8ConvenientRecalculationManagementofReportsandAutomaticTimedRecalculation.31.1.9ReportCheck.31.1.10FlexiblePrintFunctionofReports..31.1.11AuthorizedManagementofReports.31.1.12AccessAccordingtoOrganizationalUnit.31.1.13ReportPublishing.31.2ModuleLocationinK/3ERPSystem..41.3InterfacingwithOtherModules.41.3.1InterfacingwithOtherModulesofK/3..41.3.2InterfacingwithManagementCockpit..5Chapter2OperationsofReportModule..72.1ReportManagement.72.1.1CreateAReport.72.1.2OpenAReport.82.1.3CloseAReport.102.1.4ImportFile..102.1.5ExportReport.102.1.6OpenAChart.112.1.7SaveAReport..112.1.8PrintAReport.122.1.9ChangeOperator.132.1.10Exit.132.2ReportEdit.132.2.1Cut.132.2.2Copy.132.2.3Paste..142.2.4Clear..142.2.5DeleteCellHorizontally..142.2.6DeleteCellVertically..142.2.7DeleteRow.142.2.8DeleteColumn.142.2.9DeleteChart.142.2.10FindandReplace.152.3ViewDisplay.152.3.1DisplayofToolbar,StatusBar,EditColumn..152.3.2DisplayofReport..172.3.3Refresh.172.4InsertProcessing..172.4.1InsertCellHorizontally.172.4.2InsertCellVertically.172.4.3InsertRow..182.4.4InsertColumn.182.4.5Function.182.4.6Chart..182.5ReportFormatDefinition..242.5.1CellProperty..242.5.2RowProperty.262.5.3ColumnProperty..272.5.4TableProperty..272.5.5SheetManagement..332.5.6DefineDiagonal..342.5.7DeleteDiagonal..352.5.8MergeCell..352.5.9LockCell..352.5.10AutoApplyFormat.362.6WindowSettings.362.6.1Cascade.362.6.2HorizontalTile..362.6.3VerticalTile..362.6.4ArrangeIcon.362.6.5ListofUnfoldedReports.36Chapter3ReportOperationProcessing.373.1ReportProcessing..373.1.1MultiA/CSetManagement..373.1.2SetFormulaAccessFunction..403.1.3SetDefaultAccessAccountSet.413.1.4SetDefaultOrganization..423.1.5ConvertOldVersionFormula.423.1.6MassFilling..433.1.7SheetSummary.483.1.8SortReportbyPriority..483.1.9ReportAnalysis..493.1.10AssociatedQueryofReports.503.1.11TruncationFormulaSettings..513.1.12ReportAuthorityControl.523.1.13ReportCheck.533.1.14ReportApproval.543.1.15ReportPublish..543.2ReportCalculation..543.2.1ReportCalculation..543.2.2ReportRecalculation..55Chapter4IntroductionofReportAccessFormula..594.1ElementaryOperationofFunction..594.1.1SettingsofVisualDisplayModeofEditBar.594.1.2AccessFormulaSettingsinEditBar..594.2IntroductionofAccessFormulaonClassBasis.604.2.1AccessFormulainKingdeeReportFunction.604.2.2LogicAccessFormula..684.2.3MathandTrigonometryAccessFormula..684.2.4FinancialAccessFormula..684.2.5AccessFormulaforGeneralLedger..694.2.6AccessFormulaforBudgetManagement..734.2.7AccessFormulaforIndustrialStatement..764.2.8AccessFormulaforInventoryAccountingStatement.774.2.9AccessFormulaforCostStatement.784.2.10AccessFormulaforEquipmentManagement..784.2.11AccessFormulaforCRMReports..794.2.12AccessFormulaforSalary.794.2.13AccessFormulaforCashFlowStatement.814.2.14DataConversionFormula..814.2.15DatabaseAccessFormula.824.2.16AccessFormulaforNewConsolidatedStatement.834.2.17BusinessBudgetAccessFormula..864.2.18ExpenseBudgetAccessFormula..944.2.19FundBudgetAccessFormula..100AppendixFeedbackForm.108UserManualforKingdeeK/3WISEReportChapter1OverviewofThisModule-1-Chapter1OverviewofThisModule1.1AbouttheModuleAfterenterpriseappliesERPsystemforatime,itwillproducealotofroutineoperatingdata.Thesedataarevaluableinformationresourceoftheenterprise,whichcanbeusedasaquantitativefoundationforanenterprisetojudgecurrentoperationmodeandmakevariousdecisions.WecansaythatthejudgmentofthematurityofanERPsystemreliesuponwhethertheinformationmeetscustomer’srequirementtoagreatextent.ThemodulesofKingdeeK/3ERPprovideuserswithamplegenerallyacceptedreportforms,anditsK/3reportingsubsystemhelpsuserspreparevariousindividualizedreportsquicklyandaccurately.K/3Reportmoduleoffershundredsofflexibleaccessformulaandmeetstherequirementofusersatdifferentlevels;moreover,withtheoperatingstylesimilartoEXCEL,theuserscanpreparetheirownreportsindependentlyoncetheyreceivesimpletraining,thustheenterprise’strainingcostisgreatlyreduced.K/3Reportmodulehasthefollowingdistinctivefunctions: FlexibleAccessSettings AmplePresetReportTemplates Multi-accountSetAccessManagement Multi-sheetManagementandSummary MassCopy AnalysisofReports AssociatedQueryofReports ConvenientRecalculationManagementofReportsandAutomaticTimedRecalculation ReportCheck FlexiblePrintFunctionofReports AuthorizedManagementofReports AccessAccordingtoOrganizationalUnit ReportPublishingChapter1OverviewofThisModuleUserManualforKingdeeK/3WISEReport-2-1.1.1FlexibleAccessSettingsK/3systemprovidesampleaccessformula,thususerscanobtainallsortsoffinancialsettlementdata,budgetdataandbusinessdata.TheycangetaccesstotheGeneralLedgermodulethroughtheaccessformulaofACCT,ACCTCASH,ACCTGROUP,ACCTEXT,etc.;getaccesstothePayrollManagementmodulethroughwageaccessformulaFOG-PA;getaccesstotheFixedAssetsmodulethroughFOG-PA,theaccessformulaoffixedassets;getaccesstotheManagementAccountingsystemthroughMGAcct;andgetaccesstotheSCMsystemthroughthespecifiedaccessformula.1.1.2AmplePresetReportTemplatesInlightofdifferentaccountingsystemofdifferentindustry,K/3Reportingmoduleprovidesthetemplescoveringmorethan20industriesandover100fixedstatements,sothattheuserscanpreparethereportsmoreconveniently.1.1.3Multi-accountSetAccessManagementUndercentralizedoperationmode,i.e.agroup’salldatabaseandaccountsetsareplacedattheheadquarter’soneormoreintermediateservertomanage,themulti-accountsetaccessmanagementcanrealizethepurposeofgettingaccesstootheraccounts(notthecurrentaccountset)andpreparerelatedtransactionreports.1.1.4Multi-sheetManagementandSummaryWithmulti-pagemanagementfunction,theuserscansetmultiplepagesonthesamereport,andutilize“multi-pagesummary”functiontosummarizethedataitemsondifferentpages.1.1.5MassCopyMasscopyfunctionhelpstospecifyaccessobjects,accountingitemsinbatchesandproducebatchgenerationaccessformulaautomatically.Thiscangreatlyreduceuser’srepetitiveworkloaddefinedbyasingleformulaandhelpthempreparereportsquickly.1.1.6AnalysisofReportsItintegratestheoriginalfinancialanalysisfunctionandtheReportmodule,sothatuserscanmakeananalysisofreportsintheReportmoduleaccordingly.1.1.7AssociatedQueryofReportsK/3systemoffersdata“associatedquery”function.ForthedataacquiredthroughACCTorACCTEXTformula,userscansearchtheGeneralLedgermodule’sledgeraccount,subledger,andthegeneralledgeronquantity/amountbasis,thesubledgeronquantity/amountbasis.Therebyithelpsusersmakeananalysisofdatamoreeffectively.UserManualforKingdeeK/3WISEReportChapter1OverviewofThisModule-3-1.1.8ConvenientRecalculationManagementofReportsandAutomaticTimedRecalculationK/3systemoffersthefunctionofrecalculationschemeofstatements,thususerscansetrecalculationschemeaccordingtothecharacteristicofreportdataandcarryoutbatchrecalculationofstatements,withnoneedtoopeningallstatementsandrecalculateonebyone.Thissavestheenterprise’sapplicationcost.Basedontherecalculationschemeofreports,thesyst.
