UserManualforKingdeeK/3V14.2A/CSetUpgradeToolStatementThedocumentcopyrightisownedbyKingdeeSoftware(China)Co.,Ltd.Nopartofthisdocumentmaybeadded/deleted,reproduced,excepted,translated,reprintedorrewritteninanyformorbyanymeanswithoutpriorwrittenconsentofKingdee.KingdeeSoftware(China)Co.,Ltd.October,20151TableofContentsTUChapter1OverviewUT.1TUChapter2Base-CheckingDataBeforeUpgradingA/CSetsofV10.4UT.3TU2.1CheckItemsofUserUpgradeUT..3TU2.2RulesofUserUpgradeUT.3TU2.3CheckItemsofEmployeeUpgradeUT..4TU2.4RulesofEmployeeUpgradeUT..4TUChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSetsUT.5TU3.1CheckingVoucherDataGeneratedBasedonDocumentsUT.5TU3.2CheckingValidityofDatainCustomItemsUT.5TU3.3CheckingS/NUpgradeUT.6TU3.4CheckingCommercialA/CSetsfortheDocumentsWrittenOfforDeductedButNotApprovedUT.11TU3.5CancellingtheCheckofCommercialA/CSetsfortheWritten-offDocumentsLaterThanThisPeriodUT..13TU3.6CheckingInvoicesinCommercialA/CSetSystemWhileNotTransferredtoA/RandA/PModuleUT..13TU3.7CheckingTransactionModulesfortheDocumentswithIncorrectConversionBetweenCUOMQuantityandBUOMQuantityUT..13TU3.8CheckingthePolicieswiththeSamePriorityandoftheCombinationTypeUT.14TU3.9CheckingShelfLivesofMaterialsUT..14TU3.10CheckingtheDocumentDataWhichWritten-OffQuantityIsZeroButtheWritten-OffAmountIsNotZeroUT..16TU3.11CheckingIfThereIsRedundancyInvoicesinAR/APModulesUT.16TU3.12CheckingIftheInvoiceAmountsonAR/APContractAreConsistentwithThoseinSCMSystemUT..17TU3.13CheckingSalesInvoice(CashReceipt)UT.17TU3.14CheckingPurchaseInvoice(CashPayment)UT.18TU3.15CheckingPriceDifferenceAdjustmentUT.18TU3.16CheckingInvoicesApprovedinSCMButNotApprovedinA/RandA/PUT..19TU3.17CheckingUpgradeofDocumentwithConsignmentWarehouseUT..19TU3.18CheckingFreeItemsThatWereNotModifiedNames,ButWereEnteredTransactionDatainCommercialSystemUT.23TU3.19CheckingUpgradeofInstallmentSalesUT.24TU3.20CheckingConsignmentSalesUpgradeUT..272TU3.21SameFcolNameRecordsExistinSameKindofDocumentsintheDocumentsListUT..29TU3.22CheckingProduction/PurchaseDateofCommercialSalesInvoiceUT.30TUChapter4SCM-CheckingDataBeforeUpgradingV10.1IndustrialA/CSetsUT.31TU4.1CheckingtheS/NUT.31TU4.2CheckingtheUpgradeoftheInvoicedQuantityofSalesDeliveriesUT.33TU4.3CheckingtheUpgradeoftheInvoicedQuantityofPurchaseReceiptsUT..35TU4.4UpgradingtheInvoicedQuantityofSalesOrdersUT..36TU4.5UpgradingtheInvoicedQuantityofPurchaseOrdersUT..37TU4.6SameFcolNameRecordsExistinSameKindofDocumentsintheDocumentsListUT.38TU4.7CheckingProduction/PurchaseDateofIndustrialSalesInvoicesUT..39TUChapter5SCM-CheckingDataBeforeUpgradingV10.2A/CSetsUT.41TU5.1CorrectingErrorsintheUpgradeofNegativeDeliveryCostAdjustmentUT..41TU5.2CheckingtheUpgradeofInvoicedQuantityUT.43TU5.3CheckingtheUpgradeofCross-checkQuantityUT..44TU5.4CheckingtheUpgradeErrorsofConsignmentWarehouseDataUT.49TU5.5CheckingtheCloseofManualRowTransactionsUT..49TU5.6CheckingtheSalesInvoiceProduction/PurchaseDateUT.50TUChapter6A/RandAP-CheckingDataBeforeUpgradingA/CSetsUT.53TU6.1CheckingDataBeforeUpgradingV10.1A/CSetsUT..53TU6.2CheckingDataBeforeUpgradingV10.2A/CSetsUT..56TU6.3SystemSelf-checkaftertheUpgradeUT.59TUChapter7Finance-CheckingDataBeforeUpgradingA/CSetsforV10.1andLaterVersionsUT.61TU7.1CheckingforVoucherswithHeaderButwithoutBodyUT.61TU7.2CheckingforAccountingInformationAffiliatedtotheVoucherintheMasterDataUT61TU7.3CheckingFixedAssetsDataUT.62UserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter1Overview1Chapter1OverviewBeforeA/Csetupgrade,thecheckwizardofthechecktoolguidesyouthroughastepbystepprocesstochecktransactiondata.Ifthereareanyillegaldata,theyarelistedforyoutorecovermanuallyorautomatically.YoucannotupgradeanyA/Csetunlessalltheillegaldataareadjusted.Fordetailsaboutvarioustransactionchecks,seethefollowingsections.Chapter1OverviewUserManualforKingdeeK/3V13.1A/CSetUpgradeTool2UserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter2Base-CheckingDataBeforeUpgradingA/CSets3Chapter2Base-CheckingDataBeforeUpgradingA/CSets2.1CheckItemsofUserUpgradeCheckitems:1.HRUsersWhoWereSettoBeK/3Users;2.UserswithSameName;3.UsersExistinginHR;4.UserOnlyExistinginK/3;5.Dimission,retirementandnot-in-jobusersinHRsystem.Checkresults:Iftherearedatameetingtheaboveconditions,thedatacheckresultisWarning.Otherwise,theresultisPassed.Viewingresults:ClickViewtodisplaytheinterfacefortheuserdatacheckreport,asshowninthefollowingfigure:FunctionsofRecover:Re-check,ExportandExitonthetoolbaroftheinterface:Recover:Afterselectingoneormultiplerecordsfromthelist,clickthisbuttontodisplayapage,whereyoucanmodifyselecteddata.Re-check:RechecktheuserdataintheA/Csetandremakeacheckreport.Export:ExportthedatainthelistofthecurrenttabpagetoanExcelspreadsheet.Exit:Exittheinterfacefortheuserdatacheckreport.2.2RulesofUserUpgradeRulesofuserupgrade:1.TheK/3andHRuserswiththesamenameareautomaticallycombinedintooneuser.Afterupgrade,thepasswordsoftheoriginalK/3andHRusersarestilleffective.Upgraderulesofotherproperties:IfthepropertyvalueoftheoriginalHRuserisnull,thecombinedpropertyvalueissubjecttothatoftheoriginalK/3user.Otherwise,thecombinedpropertyvalueissubjecttothatoftheoriginalHRuser.Chapter2Base-CheckingDataBeforeUpgradingA/CSetsUserManualforKingdeeK/3V13.1A/CSetUpgradeTool42.TheK/3andHRuserswithdifferentnamesareupgradeddirectly.3.Ifausergroupnameisrepetitiveofausername,theusergroupnameismodifiedautomatically.2.3CheckItemsofEmployeeUpgradeCheckitems:1.K/3employeewhoseIDcardNo.isblankorsubstandard2.K/3andHRemployeeswiththesameIDcardNo.3.K/3andHRemployeeswiththesameK3Code+NameandHREmployeeCode+Name4.K/3andHRemployeeswiththesamename5.K/3employeeswiththesameIDcardNo.Checkresults:Iftherearedatameetingtheconditionsinitem2,thedatacheckresultisFailed.Iftherearedatameetingtheconditionsinitem1/3/4/5,theresultisWarning.Ifthereisnodata,theresultisPassed.Viewingresults:ClickViewtodisplaytheinterfacefortheemployeeupgradecheckresult,asshowninthefollowingfigure:FunctionsofRecover,Re-check,ExportandExitonthetoolbaroftheinterface:Recover:Afterselectingoneormultiplerecordsfromthelist,clickthisbuttontodisplayapage,whereyoucanmodifyselecteddata.Re-check:RechecktheuserdataintheA/Csetandremakeacheckreport.Export:ExportthedatainthelistofthecurrenttabpagetoanExcelspreadsheet.Exit:Exittheinterfacefortheemployeeupgradecheckresult.2.4RulesofEmployeeUpgradeRulesofemployeeupgrade:1.TheK/3andHRemployeeswiththesameIDcardNo.(notblank)areautomaticallycombinedintooneemployee.IfthepropertyvalueoftheoriginalHRemployeeisblank,thecombinedpropertyvalueissubjecttothatoftheoriginalK/3employee.Otherwise,thecombinedpropertyvalueissubjecttothatoftheoriginalHRemployee.2.TheK/3andHRemployeeswithdifferentIDcardnumbersareupgradeddirectly.UserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSets5Chapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSets3.1CheckingVoucherDataGeneratedBasedonDocumentsCheckdescription:Itisallowedtogeneratevouchersincurrentperiodforthedocumentswhichhavenotbeengeneratedvouchersinpreviousperiod.Butafterupgrading,thesekindsofdocumentsofinvoices,receiptsanddeliveriesarenotallowedtogeneratevouchersincurrentperiod.Documentswithoutvouchersinpreviousperiodswillbedisplayedintheresultofthecheck.Duringthecheck,thefirststepistocheckwhetherthereiscorrespondingvouchertemplateforonekindofdocument,ifthereisn't,thenitisnoneedtocheckthiskindofdocuments.Checkreport:Tablenameofdocument|Documenttype|DocumentISN|DocumentNo.|Documentdate|Handlingmethod:Therearetwomethodsforhandling.1.Thedataarethoughttobecorrect.Ifthedocumentsnotgeneratingvouchersinhistoryperiodshavenoimpactonaccounting(forexample,inventoryadjustment),thismethodcanbeused.2.Thedataarethoughttobeincorrectandneedtobeadjustedmanually.If2isselected,youcannotupgradeunlessyouhavemanuallygeneratedvouchersbasedondocumentsintheCommercesystem.3.2CheckingValidityofDatainCustomItemsCheckdescription:Althoughthetypeofthecommercialcustomitemistextinthedatabase,yetitcanbesetbyyoutotext,integerandfloatingpointrepeatedly.Forexample,thetypeofcustomitem1ofSalesDeliveryisfirstsettotext,andyoufill“KingdeeSoftware”incustomitem1ofdocumentSOUT00001.Later,thetypeofcustomitem1isresettointeger.Duringtheupgrade,anintegerfieldiscreatedinthestandardsupplychainaccordingtothecurrenttype,soanerroroccurswhen“KingdeeSoftware”isconvertedintoaninteger.Checkreport:Documentname|DatabaseTable|DocumentISN|Documententry|Errordescription|Handlingmethod:Chapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSetsUserManualforKingdeeK/3V13.1A/CSetUpgradeTool6Youcannotcontinuetoupgradeunlessallthecheckresultsarehandled.Therearetwomethodsfordatarecovery:automaticadjustmentandmanualadjustment.Regardingtheabovedata,youcanonlyadjustthemmanually.1.Automaticadjustment.Adjustmentlogic:allthebusinessdatawillbeclearedexceptthedataofcurrenttypeofonecustomitem.Forexample,thetypeofCustomItem1ofPurchaseReceiptisfirstsettointeger,andintegersareinputinthisfield.Later,thetypeofthisfieldisresettotext,andtextsarealsoinputinthisfield.Duringdataupgrade,thesystemdeletesalltheintegersinthisfield,andreservesonlytextdata.Afterdataupgrade,thetypeofthisfieldistextbydefault.2.Manualadjustment.Adjustmentlogic:Firstcheckwhetherthereareothercustomitemsthatneverhavebeenusedintherelevantdocument.Ifyes,setthetypesoftheseunusedfieldsasrequired,andtransplantrelevantdatatothesefields.Inthismode,thesystemprovidesrelevantadjustmentSQLtemplates,andyouneedimplementrelevantSQLstatementsinthequeryanalyzerforthesakeofadjustment.3.3CheckingS/NUpgradeBecausetheSCMV10.2exercisesstrictcontrolonS/Ndata,especiallyindataintegrity,thissectionissubdividedintoeightparts.3.3.1CheckFieldsinDescriptionTableWhileNotinS/NRuleTableCheckdescription:CheckingtheintegralityoftheSNruleismainlytochecktheconsistencyofthedatainthefielddescriptiontableofSNruleandthephysicaltable.Checkreport:S/NruleID|S/Nrulename|S/Nrulecode|Fieldname|FieldID|PhysicalTablefieldname|Datatype|Searchtype|Indexcolumnornot|Handlingmethod:Thiskindofdatacanonlybeadjustedmanually.Adjustmentlogic:UserhastocheckRuleS/NBaseTableCom_Serial_F+RuleISNandconfirmwhetherthisfieldisrequired.Ifitisanextrafield,thecorrespondingdescriptionwillbedeletedfromCom_Serialdesc;ifitisrequired,thisfieldshouldberecreatedontheBaseTableandcompletethedata.ThesystemprovidesanadjustmentSQLtemplatefordeletingthedescriptionandcreatinganewfieldontheBaseTable.3.3.2CheckS/NRuleoftheFieldswithoutIndexCheckdescription:FromversionV10.0,itisrequiredthatonefieldforoneS/Nruleistheindexfield,butitdidnotupgradethedataofpreviousversionconstrainedly.Andinversion10.2andonlater,thisindexfieldwillbecombinedwiththegoodsandbecomestheuniqueprimarykeytoassuretheuniquedata.Checkreport:S/NruleID|S/Nrulecode|S/Nrulename|Remarks|UserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSets7Handlingmethod:Thiskindofdatacanonlybeadjustedmanually.Adjustmentlogic:1.IfafieldofthecurrentrulecontainsuniquedataandisexpectedtoserveastheprimaryidentificationflagoftheS/N,youcandesignatethisfieldastheindexfieldbysettingthevalueofFisdIndexofthisfieldto1inDescriptionTableCom_Serialdesc.ThesystemprovidesanadjustmentSQLtemplate.2.Ifthereisnosuchfieldintherule,itisnecessarytoaddanewfieldastheindexfield,andensuretheuniquenessofinputdata.Additionmethod:InputthedescriptionofthenewfieldinRuleFieldDescriptionTableCom_Serialdesc.AddthenewfieldtoPhysicalTableCom_Serial_F+RuleISNandinputuniquedata.DescriptionoffieldsinRuleFieldDescriptionTableCom_SerialDesc:FserialclassIDS/NruleISN,correspondingtoFserialCLassIDinCom_Serialclass.FpropIDfieldISN,with1001,1002,1003,1004and1005forpredefinedfields.Customfieldsarenumberedfrom1.FpropNamefieldname,intheS/NviewsheetheaderFSQLColumnNamefieldnameofPhysicalTableCom_Serial_F+S/NruleISNFdataTypedatatype.0:integer;1:text;2:accountingitem;3:auxiliarydataFsizemaximumlengthofthefieldFprecisionnotinuseforthetimebeingFscalenotinuseforthetimebeingFclassIDsearchtypeofaccountingitemandauxiliarydataand0forotherdatatypeFdefaultdefaultvalueFgenerateIDautomaticallygenerateschemeIDsFpreDefinepredefinedfieldornotFisIndexindexcolumnornot3.3.3CheckS/NRuleWhoseDataTypeofIndexFieldisNotIntegerorTextCheckdescription:Inthenewversion,thefieldsofSNrulecanbeInteger,Text,AccountingItemorAuxiliaryData(andintableCom_Serialdesc,FdataTypeisseparatedin0,1,2,and3).Toassuretheuniquedata,itisrequiredthefieldtypeshouldbeTextorInteger(becausethelimitationonthemaximumvalueofInteger,theTexttypeisrecommended.Andafterupgradingtoversion10.2,theindexfieldsaresettotheTexttype).Checkreport:S/NruleID|S/Nrulecode|S/Nrulename|FieldID|Fieldname|PhysicalTablefieldname|Handlingmethod:Thiskindofdatacanonlybeadjustedmanually.Adjustmentlogic:Changethedataintheindexcolumntotext.ThesystemprovidesanadjustmentSQLtemplate,wherethelengthoftheindexissetto100bydefault.Chapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSetsUserManualforKingdeeK/3V13.1A/CSetUpgradeTool83.3.4CheckS/NRulewithDuplicatedIndexValueCheckdescription:Thepreviousversionrequiresthesameindexcolumnshouldbeunique,andV10.2andlatercontinuetoprocessonthebasisofuniqueIndexColumn+Goods,thustheindexvalueshouldbeunique.Checkreport:S/NruleID|S/Nrulecode|S/Nrulename|Fieldname|PhysicalTablefieldname|Indexvalue|Handlingmethod:manualadjustment.Adjustmentlogic:DeleteredundantandrepeateddatafromPhyscialTableCom_Serial_F+RuleISNorchangethemtoothervalues,iftheISNoftheindexvaluehasnoflowrecordinFlowTableCom_SerialBill.ThesystemprovidesanadjustmentSQLtemplateforprocessing.Ifthereareflowrecords,youneedtomodifyindexvaluesandensuretheiruniqueness.3.3.5CheckS/NinInitializationFlowTableWhileNotinBasicTableCheckdescription:ChecktheinconsistencyS/NsintheinitialS/NProcessFlowTableandS/NBaseTable,ifthereisanydatainconsistency,theerrorsmayoccurwhentheassociationqueryisdoneorwrongresultmaybeoutput.Checkreport:Commoditycode|Commodityname|Auxiliarypropertycode|Auxiliarypropertyname|Warehousecode|Warehousename|S/Nrulename|S/NISN|Handlingmethod:manualadjustment.Adjustmentlogic:1.IftheS/Nisactuallyinuseaccordingtothetransactionlogicqueryresult,addittotheBasicTable.2.Otherwise,deletetherelevantrecordfromtheInitialFlowTableandensuretheinitialBUoMquantityisconsistentwiththeS/Nquantityafterdeletion.3.3.6CheckIftheInitialQuantityofGoodsintheWarehouseIsSameasS/NQuantityCheckdescription:Inversion10.2andlateron,itisrequiredthatthematerialquantityandthequantityofSNshouldbeconsistentintheinitialization,andtheSNnumberofnon-on-handinventoryisnotallowedtoenter.Checkingthisistoassurethedatabaseisupgradedaccordingtothenewrequirementandcanbeappliedintheprocesslateron.Checkreport:Commoditycode|Commodityname|Auxiliarypropertycode|Auxiliarypropertyname|Warehousecode|Warehousename|Initialcommodityquantity|InitialS/Nquantity|UserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSets9Handlingmethod:disablingS/Nmanagementofcommoditieswithabnormaldataforthetimebeing,andmanualadjustment.1.DisablingS/Nmanagementofcommoditieswithabnormaldataforthetimebeing.ThismethodisapplicablewhentheS/Nnotinthewarehouseisinputduringinitializationandcannotbede-initialized.Duringupgrade,thesystemdeletesalltheS/Ninformationofrelevantcommodities,anddisablesS/Nmanagementofrelevantcommodities.Afterupgrade,youcancreatecommoditiesforprocessing.2.Manualadjustment.ThismethodisapplicablewhenupgradeddatarequireS/Nmanagementontheprincipleofstricttrack.Adjustmentmethod:de-initializeinconsistentdataandstopinitialization.ToimplementSQLforadjustment,itisnecessarytomaintainFlowTableCom_SerialBillandMainTableCom_Serial_F+S/NruleISNasrequired.DescriptionofinitialapplicationfieldsinFlowTableCom_SerialBill:FscreenIDdocumenttype.00mustbeinputduringinitialization.FbillIDdocumentISN.ThecommodityISNmustbeinputduringinitialization.FbillEntryIDdocumententryID.ThecommodityauxiliarypropertyISNmustbeinputduringinitialization.Otherwise,0shouldbeinput.FstockIDwarehouseISN.FserialClassIDS/NruleISN.FserialIDS/NISN.ThesystemprovidesanadjustmentSQLtemplate.3.3.7ChecktheConsitenceofCommodityUOMandBUOMonDocumentEntryCheckdescription:IntheoldcommercialA/Cset,theQty(CUoM)isusedasS/NQty,whileinthenewversion,Qty(BUoM)isusedastheS/Ns.IftheCUoMandBUoMinthedocaredifferent,thentheS/NQtyandDocQtywillbedifferentaftertheupgrade.UsersareallowednottousetheS/Nmanagementforexceptionalgoodstemporarily,andthesystemprovidestowaystoadjustitmanually.Checkreport:Documenttypecode|Documenttypename|Documentcode|Documentdate|EntryNo.|Commoditycode|Commodityname|Auxiliarypropertycode|Auxiliarypropertyname|UoM|Quantity|BUoM|BUoMquantity|Handlingmethod:disablingS/Nmanagementofcommoditieswithabnormaldataforthetimebeing,andmanualadjustment.1.DisablingS/Nmanagementofcommoditieswithabnormaldataforthetimebeing.ThisoptionisselectedifthiskindofdocumentislargeinnumberandyoucannotchangethedocumentUoMtotheBUoMtoensureconsistentS/Nquantities.Duringupgrade,thesystemdeletesalltheS/NinformationChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSetsUserManualforKingdeeK/3V13.1A/CSetUpgradeTool10ofrelevantcommodities,anddisablesS/Nmanagementofrelevantcommodities.Afterupgrade,youcancreatecommoditiesforprocessing.2.Manualadjustment.ThismethodisapplicableiftheabnormaldatavolumeissmallandyoucanchangethedocumentCUoMtotheBUoM.Adjustmentmethod:MaketheS/NquantityconsistentwiththedocumentBUoMfornormalupgrade.3.3.8ChecktheConsitenceofCommodityS/NQuantityofDocumentEntryandEntryQuantityCheckdescription:ItisrequiredtocontroltheSNstrictlyafterversion10.2,andgoodswithSNmanagementmustentertheSNforit.SothedocumentswithoutSNforthesegoodswillnotbeappliedsmoothlyafterupgrading.Checkreport:Documenttypecode|Documenttypename|DocumentISN|Documentcode|Documentdate|EntryNo.|Commoditycode|Commodityname|Auxiliarypropertycode|Auxiliarypropertyname|EntryBUoMquantity|InputS/Nquantity|Handlingmethod:disablingS/Nmanagementofcommoditieswithabnormaldataforthetimebeing,andmanualadjustment.1.DisablingS/Nmanagementofcommoditieswithabnormaldataforthetimebeing.ThisoptionisselectedifthiskindofdocumentislargeinnumberandyoucannotmaketheS/NquantityconsistentwiththedocumentquantitybysupplementingtheS/N.Duringupgrade,thesystemdeletesalltheS/Ninformationofrelevantcommodities,anddisablesS/Nmanagementofrelevantcommodities.Afterupgrade,youcancreatecommoditiesforprocessing.2.Manualadjustment.ThismethodisapplicableiftheabnormaldatavolumeissmallandyoucanmodifythedocumenttocompletetheS/Nfornormalupgrade.TocompletetheS/N,itisnecessarytomaintainFlowTableCom_SerialBillandMainTableCom_Serial_F+S/NruleISN.DescriptionofdocumentapplicationfieldsinFlowTableCom_SerialBill:FscreenIDdocumenttypeFbillIDdocumentISNFbillEntryIDdocumententryIDFstockIDoptionalFserialClassIDS/NruleISNFserialIDS/NISNUserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSets113.3.9CheckIfThereAreMaterialswithS/NmanagementonCommercialInstallmentDelivery,ConsignmentSalesDeliveryandVendorConsignmentReceipt/DeliveryCheckdescription:1.Intheversionof10.2andafterwards,InventoryReceiptandDeliveryforVWdoesnotsupportserialNo.management,thehistorydataoftheoriginalVendorConsignmentReceiptandDeliverymaterialshavingbeenwithserialNo.managementcannotsupporttheupgrading;2.Duringtheupgrading,installmentwarehouseandconsignmentsaleswillautomaticallygenerateSalesDeliveryaccordingtotheunsettledquantity,buttheirmaterialswithserialNo.managementcannotautobegenerated.Checkreport:TherearematerialsunderS/NmanagementintheInstallmentCollectionDelivery,ConsignmentDelivery,VendorConsignmentDeliveryandVendorConsignmentReceipt.Details:Documenttype,documentNo.,documentcodeandcommoditynameHandlingmethod:ThesystemallowsyoutodisableS/Nmanagementforthetimebeingornottorecoverdata(bydefault).Handlingdescription:Duringupgrade,thesystemdeletesalltheS/Ninformationofrelevantcommodities,anddisablesS/Nmanagementofrelevantcommodities.Afterupgrade,youcancreatecommoditiesforprocessing.3.4CheckingCommercialA/CSetsfortheDocumentsWrittenOfforDeductedButNotApprovedCheckdescription:IntheSCMsystemofthenewversion,thecontrolofdocumentstatusisverystrict.Onlyapproveddocumentcanbeexecutedthetransactionsfollowed.Forexample,adocumentcannotbecross-checkedordeductedlyexecutedbythetargettransactionsuntilitisapproved.Butinpreviousversions(V10.2andbeforewards),thereisnosuchlimitation.Sousersmustprocessthesedatabeforeupgrading.Checkreport:Documentname|Tablenameofdocument|Documentcode|DocumentISN|Handlingmethod:manualrecoveryandautomaticrecovery.1.Manualrecoveryistoadjustdatainthesystem,thatis,manuallyapprovethedetecteddocumentsonebyoneinthecommercialsystem.Chapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSetsUserManualforKingdeeK/3V13.1A/CSetUpgradeTool122.AutomaticrecoveryistoupdateapprovalstatusesofdocumentsbycallingSQLstatements.Inthecaseofapproval,theApprovedbyisadministratorbydefault.Inthecaseofmulti-levelcheck,theCheckedbyofabusinesschecklevelisalsoadministratorbydefault.Ifthereisacheckwhosedateislaterthanthedocumentdatebeforeachecklevel,thecheckdateofthischecklevelisthatofthepreviouslevel;otherwise,thecheckdateshouldbethedocumentdate.WhenupdatingSalesInvoicesandPurchaseInvoices,youneedrenewtheapprovalstatusesandBalanceStatementsofA/RandA/Patthesametime.Involvedassociations:AssociationofthePurchasemodule:PurchaseOrder->ReceiptNotice->PurchaseReceipt->PurchaseReturnPurchaseOrder(OEMReceipt)->VendorConsignmentReceipt->VendorConsignmentReturnPurchaseOrder->PurchaseInvoiceReceiptNotice->PurchaseInvoiceMaterialReturnNotice->PurchaseInvoicePurchaseInvoice->PurchaseInvoiceSalesInvoice->SalesInvoiceVendorConsignmentReceipt->InvoiceVendorConsignmentReturn->InvoiceAssociationoftheSalesmodule:SalesOrder->SalesNotice->SalesDelivery->SalesReturnSalesOrder(Consignment)->ConsignmentDelivery->ConsignmentReturnSalesOrder(InstallmentCollection)->InstallmentCollectionDelivery->InstallmentCollectionReturnSalesOrder->SalesInvoiceSalesDelivery->SalesInvoiceSalesReturn->SalesInvoicePurchaseInvoice->SalesInvoiceAssociationoftheWarehousemodule:SalesOrder->CombinationReceipt-CombinationDeliveryReceiptNotice->StockTransferInternalOrder->StockTransferDeliveryNotice->StockTransferUserManualforKingdeeK/3V13.1A/CSetUpgradeToolChapter3SCM-CheckingDataBeforeUpgradingV10.1CommercialA/CSets133.5CancellingtheCheckofCommercialA/CSetsfortheWritten-offDocumentsLaterThanThisPeriodDescriptionofV10.2:TheV10.2SCMIndustryrefusesthedocumentsinthefutureperiodtobecross-checked,buttheCommercesystemofpreviousversionsdoesnotsetsuchalimit.Asaresult,thesedatacannotmeettherequirementsofSCMV10.2.HandlingmethodofV10.2:A.Usersconsiderthesedatatobecorrect.B.Usersconsiderthesedatatobeillegalandde-write-offthesedataincommercialA/Csets,mostlyPurchaseInvoices,PurchaseReceipts,SalesInvoicesandSalesDeliveries.InV10.2,thedocumentsinlaterperiodscannotbecross-checked,socheckingA/Csetsforthewritten-offdocumentslaterthanthisperiodisadded.InV10.2sp,thischeckiscancelledbecausethedocumentsinlaterperiodscanbecross-checked.Note:Afterthischeckiscancelled,itisnecessarytochecktheupgradelogicofcommercialwrite-offrelations,sothatthedocumentwrite-offrelationsinlaterperiodscanbeupgradedcorrectly.3.6CheckingInvoicesinCommercialA/CSetSystemWhileNotTransferredtoA/RandA/PModuleCheckdescription:InthecommercialA/CV9.41andbeforewards,somereasonscausecreditinvoicesout-of-syncinSCMsystemandAR/APmodules,whichisthereasonwhysomecreditinvoicescannotbetransferredtoAR/APmodules.Checkreport:Documentname|Documentcode|DocumentISN|Handlingmethod:YoucanmakeautomaticadjustmentbyimplementingthefollowingSQLstatement.Adjustmentlogic:1.Deletetheinvoicesthatcontainonlysheetheaderorbodyinformation.2.TransferthePurchaseInvoices(AccountPurchase)toA/RandA/P.3.TransfertheSalesInvoices(AccountSales)toA/RandA/P.3.7CheckingTransactionModulesfortheDocumentswithIncorrectConversionBetweenCUOMQuantityandBUOMQuantityCheckdescription:ProgramerrorcausetherateofCUoMquantityandBUoMquantityisnotequaltotheconversionrateofCUoM.Checkreport:Chapt.
