文章 30
浏览 18643
金蝶单据清空记账标志

金蝶单据清空记账标志

领料单 生成凭证后,发现单据做错了,然后删除了凭证,但是删除凭证后,查询到单据任然显示已经记账。 解决办法:数据表是ICStockBill,这个是单据头表 涉及的字典一般是这两个 记账人FPosterID;凭证内码FVchInterID。 先用SELECT语句过滤出来要改的那张单据,本例是领料单 SELECT * FROM ICStockBill where fbillno like '单据编号' 然后用update语句更新相关字段 update ICStockBill set fvchinterid=null where fbillno like '单据编号'

金蝶清理辅助数量不为0

金蝶清理辅助数量不为0

update ICStockBillEntry set fsecqty=0

金蝶内部查询处理器错误查询处理器在执行过程中遇到意外错误修复

金蝶内部查询处理器错误查询处理器在执行过程中遇到意外错误修复

修复.zip drop index ICStockBillEntry20020328 on ICStockBillEntry drop index idx_ICStockBillEntry_FSourceTranTypeNFSourceInterId on ICStockBillEntry drop index idx_Flex on ICStockBillEntry drop index IX_ICStockBillEntry_FSourceInterId on ICStockBillEntry /****** Object: Index [ICStockBillEntry20020328] Script Date: 09/20/2017 15:31:07 ******/ CREATE NONCLUSTERED INDEX [ICStockBillEntry20020328] ON [dbo].[ICStockBillEntry] ( [FItemID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_I....

金蝶删除凭证的时候数据库没有清空相应的记录修复

金蝶删除凭证的时候数据库没有清空相应的记录修复

update icstockbill set fvchinterid=0 where fbillno=‘单据编号’

金蝶FCustid修正

金蝶FCustid修正

–select *From ICTransactionType –select FFieldName , *From ICClassLink where FSourClassTypeID = -81 and FDestClassTypeID = -28 –select * from ICSelbills where FID = ‘B08’ and FFieldName = ‘81’ and FDstCtlField = ‘FEntrySelfB0861’ delete from ICSelbills where FID = ‘B08’ and FFieldName = ‘81’ and FColName in(‘FCustID0’,‘FCustID1’,‘FCustID2’) update ICSelbills set FTableAlias = ‘V1’ where FID = ‘B08’ and FFieldName = ‘81’ and FDstCtlField = ‘FEntrySelfB0861’ and FColName in(‘FCustIDName’,‘FCustIDN....