欢迎光临~扬州用友(畅捷通)软件--专业网络软件开发服务商-扬州七龙网络科技有限公司
  咨询电话:15952766660

技术支持

U8 通过后台数据库反启用各模块

通过后台数据库反启用用友erp各模块

(一)固定资产模块反启用:

updateaccinformation set cvalue="" where csysid="FA" and ctype="ddate"

可省 and (cid="601"or cid="05"or cid="603"OR CID="602" OR CID="03"OR CID="06")

updategl_mend set bflag_FA=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "FA")

(二)工资模块反启用:

updateaccinformation set cvalue="" where csysid="wa" and ctype="ddate"

可省 and (cid="601"or cid="05"or cid="603")

updategl_mend set bflag_Wa=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "Wa")

(三)采购模块反启用:

updateaccinformation set cvalue="" where csysid="PU" and ctype="ddate"

可省 and (cid="602"or cid="122"or cid="167")

updategl_mend set bflag_PU=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "PU")

(四)销售模块反启用:

updateaccinformation set cvalue="" where csysid="SA" and ctype="ddate"

可省 and (cid="602"or cid="143"or cid="215")

updategl_mend set bflag_SA=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "SA")

(五)库存模块反启用:

updateaccinformation set cvalue="" where csysid="st" and ctype="ddate"

可省 and (cid="602"or cid="143")

updategl_mend set bflag_st=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "st")

(六)存货模块反启用:

updateaccinformation set cvalue=""

where csysid="IA" and ctype="ddate"

可省 and (cid="602"or cid="104")

updategl_mend set bflag_IA=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "IA")

(七)应收模块反启用:

updateaccinformation set cvalue=""

where csysid="AR" and ctype="ddate"

可省 and (cid="29"or cid="11")

updategl_mend set bflag_AR=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "AR")

(八)应付模块反启用:

updateaccinformation set cvalue=""

where csysid="AP" and ctype="ddate"

可省 and (cid="24"or cid="09")

updategl_mend set bflag_AP=0

deleteua_account_sub where (cacc_id="001") and (cSub_Id = "AP")


联系我们

QQ:274381

电 话:15952766660

微信:15952766660

邮 箱:webmaster@7hl.net

地 址:扬州市广陵区信息产业基地三号楼

用手机扫描二维码关闭
二维码