学习目标

通过本单元学习，您将能够：

· 了解如何处理生产费用、完工成本等生成凭证卡死

以下描述以金蝶云星空企业版7.6为例，标准版或早期版本产品的需求建议查看发版说明。

案例

在之前版本，许多客户反馈过此问题：生产费用、完工成本等生成凭证卡死

处理方案

后续补丁已有优化，也可通过执行以下脚本进行处理：

--在生产费用分配结果

delete T_BAS_VCHBUILDPLUGIN where fformid='V_CB_EXPALLOCREVINSEND';

insert INTO T_BAS_VCHBUILDPLUGIN(fformid,fplugin,fcustplugin) values('V_CB_EXPALLOCREVINSEND',' ','Kingdee.K3.FIN.App.Core.BuildVoucher.BuildVoucherCBExpPlugIn,Kingdee.K3.FIN.App.Core');

--成本计算材料费用分配结果

delete T_BAS_VCHBUILDPLUGIN where fformid='V_CB_MATALLOCREVINSEND';

insert INTO T_BAS_VCHBUILDPLUGIN(fformid,fplugin,fcustplugin) values('V_CB_MATALLOCREVINSEND',' ','Kingdee.K3.FIN.App.Core.BuildVoucher.BuildVoucherCBMatPlugIn,Kingdee.K3.FIN.App.Core');

--完工成本结转

delete T_BAS_VCHBUILDPLUGIN where fformid='CB_COMPLETIONCOST';

insert into T_BAS_VCHBUILDPLUGIN (fformid,fplugin,fcustplugin) values('CB_COMPLETIONCOST','',

'Kingdee.K3.FIN.App.Core.BuildVoucher.PlugIn.BuildVoucherCBComplPlugIn,Kingdee.K3.FIN.App.Core');

--完工成本结转（数量金额式）

DELETE FROM T_BAS_VCHBUILDPLUGIN WHERE fformid = 'CB_COMPLETIONCOSTQTYAMT';

INSERT INTO T_BAS_VCHBUILDPLUGIN (fformid, fplugin, fcustplugin) VALUES ('CB_COMPLETIONCOSTQTYAMT', '', 'Kingdee.K3.FIN.App.Core.BuildVoucher.PlugIn.BuildVoucherCBComplQTYAMTPlugIn,Kingdee.K3.FIN.App.Core');

---用以上脚本处理过对应的业务后，若是还是卡住，请执行下面的脚本优化一下数据库---

declare @SqlStr nvarchar(max)

set @SqlStr=''

select @SqlStr= @SqlStr+ + 'alter index all on '+name+ ' rebuild;' from sysobjects where xtype='U' and (name in

('T_CB_EXPALLORESULTSEND', 'T_CB_EXPALLORESULTSEND_H', 'T_CB_EXPENSECOLLENTRY', 'T_CB_EXPENSECOLLECTION','T_CB_EXPALLORESULTREC_H','T_CB_EXPALLORESULTREC','T_HS_OUTACCTG','T_HS_CALDIMENSIONS',

'T_FA_ACCTPOLICY','T_CB_COSTCENTER','T_CB_PROORDERDIME','T_HS_InivBalanceExp_H', 'T_HS_InivBalance_H', 'T_HS_STOCKDIMENSION', 'T_HS_InivStockDimension')) and (name not like 'TMP%')

exec (@SqlStr)

declare @SqlStr1 nvarchar(max)

set @SqlStr1=''

select @SqlStr1= @SqlStr1+ + 'UPDATE STATISTICS '+name+ ';' from sysobjects where xtype='U' and (name in

('T_CB_EXPALLORESULTSEND', 'T_CB_EXPALLORESULTSEND_H', 'T_CB_EXPENSECOLLENTRY', 'T_CB_EXPENSECOLLECTION','T_CB_EXPALLORESULTREC_H','T_CB_EXPALLORESULTREC','T_HS_OUTACCTG','T_HS_CALDIMENSIONS',

'T_FA_ACCTPOLICY','T_CB_COSTCENTER','T_CB_PROORDERDIME','T_HS_InivBalanceExp_H', 'T_HS_InivBalance_H', 'T_HS_STOCKDIMENSION', 'T_HS_InivStockDimension')) and (name not like 'TMP%')

exec (@SqlStr1)

declare @SqlStr2 nvarchar(max)

set @SqlStr2=''

select @SqlStr2= @SqlStr2+ + 'ALTER TABLE '+name+ ' rebuild WITH (DATA_COMPRESSION =ROW);' from sysobjects where xtype='U' and (name in

('T_CB_EXPALLORESULTSEND', 'T_CB_EXPALLORESULTSEND_H', 'T_CB_EXPENSECOLLENTRY', 'T_CB_EXPENSECOLLECTION','T_CB_EXPALLORESULTREC_H','T_CB_EXPALLORESULTREC','T_HS_OUTACCTG','T_HS_CALDIMENSIONS',

'T_FA_ACCTPOLICY','T_CB_COSTCENTER','T_CB_PROORDERDIME','T_HS_InivBalanceExp_H', 'T_HS_InivBalance_H', 'T_HS_STOCKDIMENSION', 'T_HS_InivStockDimension')) and (name not like 'TMP%')

exec (@SqlStr2)

如何处理生产费用、完工成本等生成凭证卡死

恭喜您！