07 2020 档案

解决BOS新增单据只能加一个单据功能
摘要：select * from t_Mutex 阅读全文
posted @ 2020-07-27 14:42 allen1991 阅读(174) 评论(0) 推荐(0)
K3wise 清除记账标记和勾稽状态
摘要：--清除发票记账标志 update ICPurchase set FPosted=null,FPosterID=null,FVchInterID=0 from ICPurchase where FBillNo='10083839' --清除库存单据记账标志 update icstockbill se 阅读全文
posted @ 2020-07-25 11:42 allen1991 阅读(907) 评论(0) 推荐(0)
K3Wise清除用户信息
摘要：declare @fuserid intselect @fuserid=fuserid from t_user where fname ='XXX' 根据情况修改delete b from ICClassFilterProfile a inner join ICClassFilterProfileE 阅读全文
posted @ 2020-07-15 15:14 allen1991 阅读(592) 评论(0) 推荐(0)
成本计算
摘要：select t4.FNUMBER,t5.FNAME,t6.FNUMBER,t7.FNAME,t3.* from T_CB_PROORDERINFO t1 inner join T_CB_PROORDERDIME t2 on t1.FPRODUCTDIMEID=t2.FPRODUCTDIMEIDin 阅读全文
posted @ 2020-07-14 15:13 allen1991 阅读(276) 评论(0) 推荐(0)