金蝶KIS专业版常见问题集

http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 KIS http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 1 KISV7.X KISV8.0 ........................................................................................... 6 2 KIS XP .......... 6 3 ......................................................................................... 6 4 Hp-Laser Jet D2400 .............. 6 5 9.1SP1 -16 ........................................................................................................................................... 7 6 9.1SP1 ............................................................................................................................... 7 7 windows 2003 server sql server 2005 windiows xp sql server 2000 ............................................................................... 7 8 9.1 9.1SP1 ........................................................................................................................................... 8 9 ........................................................................................................................................... 8 10 9.0 1 ............................................................... 8 11 ........................................................................................................................... 9 12 SQL Server .............................................................. 9 13 kis ............................................................................................... 9 14 , ............................................................ 10 15 , .................................................... 10 16 ............................................. 10 17 ................................................................................................. 10 18 ............................................................................. 11 19 ......................................................................... 11 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 20 sql server datetime .................................................................... 11 21 XP 127.0.0.1 ...................................... 12 22 XP ............................................................. 12 23 SPread ............................................................ 12 24 Entry #1 ItemClass=002 ( ).................................................................................................................... 12 25 ......................................................................................................................................... 13 26 SQL server LOG ................................................................... 13 27 ..................................................... 14 28 ................................................................................. 14 29 pread ................................ 14 30 ................................................................................................................................. 14 31 9.2 ...................................................... 15 32 Spread .................................................................................. 15 33 ............................................................................. 15 34 ............................. 16 35 Ghost gho ..................................................... 16 36 9.1 .................................................................. 16 37 ................................. 17 38 spread 13880052063 9015678 ......................................................................................................................................... 17 39 KIS .... 17 40 ............... 18 41 ................................................................. 18 42 spread .......................................................... 18 43 ............................................................. 18 44 ............................. 19 45 , ................................................ 19 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 46 ................................. 20 47 ......................... 20 48 ..................................................................... 21 49 Win7 sql server .............................................. 21 50 ......................................... 21 51 ? ............................................................................... 21 52 ............................................. 22 53 KIS 10.0 activex ....................................... 22 54 10.0 ................................................................................................................................. 22 55 ............................... 23 56 ....... 23 57 ................................................. 24 58 F7 FDataRight .................................................................................. 24 59 ..................................................................... 25 60 xp home tabctl .................... 25 61 IP ................................................................................................................. 25 62 10.0 ............................................................................ 25 63 " "...................................................................................... 25 64 10.0 10 ......................................................................................................................................... 26 65 ......................................................... 26 66 KIS ........................................ 26 67 ......................................................... 27 68 0 ...................... 27 69 10.0SP1 ......................................................................................................................... 27 70 10.0SP1 ..................................................................................... 28 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 71 BOM 001 .................................................... 28 72 ............. 28 73 Win7 ........................................ 28 74 ..................... 29 75 ................................................................. 29 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 1 KISV7.X KISV8.0 KDLOCK KDLOCK.dll 2 KIS XP hosts IP 3 4 Hp-Laser Jet D2400 9.1SP1 -- http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 5 9.1SP1 -16 9.1 9.1sp1 kdlock.dll 9.1 system32 9.1sp1 commonfile 9.1sp1 , kdlock.dll 9.1sp1 commonfile 6 9.1SP1 7 windows 2003 server sql server 2005 windiows xp sql server 2000 SqL2005 select * into #aa from #aa NULL, NULL 10.0 KISEbsFaRptDepr.RptDeprInfo http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 8 9.1 9.1SP1 select * from t_userprofile where fcategory='EBO' FFilterQtyVch KISEBCPUB.LedgerSetting.UpdateSelectEnterValue rs!FFilterQtyVch = rs1!FFilterQtyVch 9 t_account FIsCash=0 t_account set FIsCash=1 10 9.0 1 ICClassProfileEntry delete from ICClassProfileEntry where FSchemeID in (select FSchemeID from ICClassProfile where FUserID=16394 and FTranType=1000202 and FSchemeName like 'Default Schema' ) http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 11 t_account fdetailid 0 t_Balance fdetailid >0, t_Itemdetailv,t_Itemdetail delete from t_Balance where faccountid=1009 and fdetailid in (select fdetailid from t_Itemdetail where f3>0) delete from t_Itemdetailv where fdetailid in (select fdetailid from t_Itemdetail where f3>0) delete from t_Itemdetail where f3>0 12 SQL Server SQL SQL SERVER SQL SERVER WINDOWS SQLSERVER SQL SERVER 2 SQL Server Windows 13 kis http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 Null. 14 , K3BBI.tlb 15 , sql : Set NoCount On 16 Excel 0 17 t_profitandloss , t_balance , t_balance, t_balance, http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 18 update t_Itemdetail set fdetailcount= (case when f1 =0 then 0 else 1 end) + (case when f2 =0 then 0 else 1 end)+ (case when f3 =0 then 0 else 1 end)+ (case when f4 =0 then 0 else 1 end)+ (case when f5 =0 then 0 else 1 end)+ (case when f8 =0 then 0 else 1 end)+ (case when f9 =0 then 0 else 1 end)+ (case when f10 =0 then 0 else 1 end)+ (case when f14 =0 then 0 else 1 end)+ (case when f2001 =0 then 0 else 1 end)+ (case when f2002 =0 then 0 else 1 end)+ (case when f2003 =0 then 0 else 1 end)+ (case when f2004 =0 then 0 else 1 end)+ (case when f2014 =0 then 0 else 1 end)+ (case when f2023 =0 then 0 else 1 end)+ (case when f2021 =0 then 0 else 1 end)+ (case when f2024 =0 then 0 else 1 end)+ (case when f3000 =0 then 0 else 1 end) 19 20 sql server datetime Update t_ad_kdAccount_gl Set FBackupTime = '2009-5-24 07:43:34' Where FAcctID = 2' Update t_ad_kdAccount_gl Set FBackupTime = '2009-05-24 19:45:19' Where FAcctID = 2 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 21 XP 127.0.0.1 22 XP XP 23 SPread val vsEntrys.SetText GetColOrder("fboscoe"), Row, Val(xRec.Fields("fboscoe").Value) 24 Entry #1 ItemClass=002 ( ) select * from dbo.sysobjects where [name] like '%bal%' and [name] like '%fa%' and xtype ='u' order by [name] select * from t_FABalCard where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod>=5)--65 select * from t_FABalCardItem where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod=6)--65 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 select * from t_FABalDept where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod=6)--103 select * from t_FABalDevice where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod=6)--0 select * from t_FABalExpense where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod=6)--103 select * from t_FABalOrgFor where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod=6)--65 select * from t_FABalPurchase where fbalid in (select fbalid from t_FABalance where fyear=2009 and fperiod=6)--0 select * from t_FABalance -- ID select t3.faccountid,t3.fnumber,t3.fname,t2.fdetailid,t1.* from t_FABalance t1 inner join t_FABalExpense t2 on t1.fbalid=t2.fbalid inner join t_account t3 on t3.faccountid=t2.facctid where t1.fyear=2009 and t1.fperiod=5 and t3.fdetailid>0 and t2.fdetailid=0 25 : update icstockbillentry set fauxqtyinvoice=0,fqtyinvoice=0 where finterid not in (select fsourceinterid from icsaleentry) and finterid in (select finterid from icstockbill where ftrantype=21) and fauxqtyinvoice <> 0 26 SQL server LOG Sql http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 27 28 select @FMaxIndex=isnull(@FMaxIndex,0) 29 pread InitEntry vsContent.MaxRows = 0 vsContent.MaxRows = 1 30 : update icstockbillentry set fqtyinvoice=0,fauxqtyinvoice=0 where finterid in (select finterid from icstockbill where ftrantype=21) and finterid not in (select fsourceinterid from icsaleentry) http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 31 9.2 LevelCell GetCtlOrderByName 32 Spread vista win2008 windows yyyy\mm\dd "-" yyyy-mm-dd, 33 select * from t_systemprofile where fkey like '%Period%' and fvalue='10' update t_systemprofile set fvalue ='9' where fcategory='CN' and fkey in ('CN_CURRENT_PERIOD','CN_START_PERIOD') update t_systemprofile set fvalue ='9' where fcategory='FA' and fkey in ('CurrentPeriod','StartPeriod') update t_systemprofile set fvalue ='9' where fcategory='GL' and fkey in ('CurrentPeriod','StartPeriod') update t_systemprofile set fvalue ='9' where fcategory='PA' and fkey in ('CurrentPeriod','StartPeriod') update t_systemprofile set fvalue ='9' where fcategory='IC' and fkey in ('CurrentPeriod','StartPeriod') update t_systemprofile set fvalue ='9' where fcategory='ARAP' and fkey in ('StartPeriod') http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 34 35 Ghost gho Ghost gho , . , , NTFS . , : GHOST , QUIT ctrl+alt+del GHOST GHO GHOST NTFS 1 NTFS 8.3 8.2 QUIT CTRL+ALT+DEL 2 FAT32 NTFS , chkdsk : /f gho . 36 9.1 9.1SP1 9.1 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 37 update ictemplate set fenable=0 where ffieldname in ('FPOStyle','FSaleStyle') 38 spread 13880052063 9015678 oSpread.SetText j, i, CStr(oDict(sKey)) 39 KIS HKEY_LOCAL_MACHINE\SOFTWARE "Kingdee\KISPRODUCT" Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Kingdee\KISPRODUCT]"DisplayName"=" KIS " "Version"="10.0" "Path"="C:\\Program Files\\Kingdee\\KIS\\Advance" "RegisteredOrganization"="HTTP://BBS.ITJMZ.COM" "RegisteredOwner"="IT " "SerialNO"="20090409" "OptionalPack"="Build:10.0.0904091616.640" http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 40 41 funitid =0 select funitid,funitgroupid,* from t_icitem where funitid=0 update t_icitem set funitid= (select fitemid from t_measureunit where funitgroupid=128) where funitid=0 and funitgroupid=128 fstandard 0 select * from t_measureunit where fstandard=0 update t_measureunit set fstandard=1 where fitemid >0 42 spread spread spread row 43 fbillno nvarchar(50) collate chinese_prc_ci_as null http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 default(''), fbillno nvarchar(200) collate chinese_prc_ci_as null default(''), 44 INSERT INTO AcctCtl..T_AcctAllUser (FUSERNAME,FUSERallcount) select fname,1 from kis_sample..t_user 45 , sql server kissvrmgr ( host ip ) Public Function GetUncommittedConnection(ByVal sConnectString As String, Optional ByVal bRaiseError As Boolean = True) As ADODB.Connection Dim Conn As ADODB.Connection On Error GoTo ErrHandler Set Conn = New ADODB.Connection Conn.Open sConnectString Conn.Execute "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" Conn.CursorLocation = adUseClient Conn.CommandTimeout = 0 Set GetUncommittedConnection = Conn Set Conn = Nothing Exit Function ErrHandler: Set Conn = Nothing If Err.Number <> 0 And bRaiseError Then Err.Raise Err.Number, Err.Source, Err.Description http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 Else Set GetUncommittedConnection = Nothing End If End Function 46 fdbname 47 t_itemdetailv , delete from t_itemdetailv where fdetailid in (select fdetailid from t_voucherentry) and fdetailid in ( select fdetailid from t_itemdetail where fdetailcount=1 and f1<>0) and fitemclassid <>1 delete from t_itemdetailv where fdetailid in (select fdetailid from t_voucherentry) and fdetailid in ( select fdetailid from t_itemdetail where fdetailcount=1 and f2<>0) and fitemclassid <>2 delete from t_itemdetailv where fdetailid in (select fdetailid from t_voucherentry) and fdetailid in ( select fdetailid from t_itemdetail where fdetailcount=1 and f3<>0) and fitemclassid <>3 delete from t_itemdetailv where fdetailid in (select fdetailid from t_voucherentry) and fdetailid in ( select fdetailid from t_itemdetail where fdetailcount=1 and f4<>0) and fitemclassid <>4 delete from t_itemdetailv where fdetailid in (select fdetailid from t_voucherentry) and fdetailid in ( select fdetailid from t_itemdetail where fdetailcount=1 and f5<>0) and fitemclassid <>5 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 delete from t_itemdetailv where fdetailid in (select fdetailid from t_voucherentry) and fdetailid in ( select fdetailid from t_itemdetail where fdetailcount=1 and f8<>0) and fitemclassid <>8 48 delete from t_itemdetailv where fdetailid=435 and fitemclassid=2 and fitemid=102 49 Win7 sql server - - , UAC 50 drop TRIGGER t_Voucher_Insert 51 ? select * from ICTableRelation WHERE FTypeID=58 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 delete from ICTableRelation WHERE FTypeID=58 52 - 53 KIS 10.0 activex 54 10.0 update icstockbillentry FQtyInvoice 0 update icstockbill fstatus 1 2 update t_rp_pbill set fvoucherid=0 where fbillid=1006 and fvoucherid not in (select fvoucherid from t_voucher) http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 55 1 2 delete from balance 3 4 56 -- SELECT v.FVoucherID,v.FDate,v.FGroupID,v.FNumber,FEntryID=e.FEntryID+1,F ErrCode=-2147204750,FErrDescription=SPACE(0) FROM #Voucher v INNER JOIN t_VoucherEntry e ON v.FVoucherID=e.FVoucherID INNER JOIN t_Account a ON e.FAccountID=a.FAccountID WHERE a.FDetailID>0 AND EXISTS ( SELECT v1.FItemClassID FROM t_ItemDetailV v1 WHERE v1.FDetailID=a.FDetailID AND v1.FItemClassID NOT IN ( SELECT v2.FItemClassID FROM t_ItemDetailV v2 WHERE v2.FDetailID=e.FDetailID ) ) --t_itemdetail update t_itemdetail set fdetailcount= case when F1<>0 then 1 else 0 end + case when F2<>0 then 1 else 0 end + case when F3<>0 then 1 else 0 end + case when F4<>0 then 1 else 0 end + case when F5<>0 then 1 else 0 end + case when F8<>0 then 1 else 0 end + case when F9<>0 then 1 else 0 end + case when F10<>0 then 1 else 0 end + http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 case when F14<>0 then 1 else 0 end + case when F2001<>0 then 1 else 0 end + case when F2002<>0 then 1 else 0 end + case when F2003<>0 then 1 else 0 end + case when F2004<>0 then 1 else 0 end + case when F2014<>0 then 1 else 0 end + case when F2023<>0 then 1 else 0 end + case when F2021<>0 then 1 else 0 end + case when F2024<>0 then 1 else 0 end + case when F3001<>0 then 1 else 0 end + case when F3002<>0 then 1 else 0 end + case when F3003<>0 then 1 else 0 end where fdetailcount >=1 delete from t_balance 57 (u1.FQtyInvoice-u1.FQty)*sign(v1.FRob)>=0 then ' ' 58 F7 FDataRight if not exists (SELECT * FROM sysobjects t1 ,syscolumns t2 where t1.id=t2.id and t1.name='t_user' and t2.Name='FDataright') Alter Table t_user Add FDataright int NULL default(0) Go http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 59 60 xphome tabctl 61 IP 2003 62 10.0 63 " " http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 update t_systemprofile set fvalue=1 where fdescription like '% %' Go 64 10.0 10 t_fabalexpense fdetailid 0 update T_FaBalExpense set fdetailid=0 where facctid in (select faccountid from t_account where fdetailid=0) and fdetailid>0 65 update t_item set FChkUserID=0 where fchkuserid >0 66 KIS --t_itemdetail update t_itemdetail set fdetailcount= case when F1<>0 then 1 else 0 end + case when F2<>0 then 1 else 0 end + case when F3<>0 then 1 else 0 end + case when F4<>0 then 1 else 0 end + case when F5<>0 then 1 else 0 end + http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 case when F8<>0 then 1 else 0 end + case when F9<>0 then 1 else 0 end + case when F10<>0 then 1 else 0 end + case when F14<>0 then 1 else 0 end + case when F2023<>0 then 1 else 0 end + case when F2021<>0 then 1 else 0 end + case when F2024<>0 then 1 else 0 end + case when F3001<>0 then 1 else 0 end + case when F3002<>0 then 1 else 0 end + case when F3003<>0 then 1 else 0 end where fdetailcount >=1 67 1 ICStockBill FCheckerId FCheckDate Null FStatus =1 ICStockBillEntry FItemID =0 68 0 t_stock FItemID =0 FType =502 69 10.0SP1 http://www.hnkingdee.cn 0731-83291207 http://www.hnkingdee.cn 0731-83291207 70 10.0SP1 "update icmaxnum set fmaxnum= (select max(finterid) from icsale) where ftablename='icsale'" 71 BOM 001 -- fprojectval bom update t_billcoderule set fprojectval=1 where FProjectID=3 and fbilltypeid='50' update ICMaxNum set fmaxnum= (select isnull(max(finterid),1) from icbom ) where ftablename='icbom' 72 Sql update seorderentry set fnote = '' where len(fnote)>100 73 Win7 http://www.hnkingdee.cn 0731-83291207 http://www.hnkin