1、把部门修改成项目,项目可以挂在科目做核算项目
2、销售单增加是否开票和销售部门两项 按客户实际情况修改FLookUpList= 下拉列表 销售单需要单据设置重新应用后下才变更
3、可以考虑把职员2级 1级部门 2级业务员
以下为执行语句
--把部门修改成项目
update t_MF_FuncInfo set FCaption = '项目' WHERE (FCaption = '部门')
update t_ItemClass set FName = '项目' WHERE (FName = '部门')
update ICClassTableInfo set FCaption_CHS='项目' WHERE (FCaption_CHS = '部门')
-- 把表头自定义1修改成是否开票
update ICClassTableInfo set FCaption_CHS = '是否开票' where (FClassTypeID = '1030002') AND FCaption_CHS = '表头自定义1'
update ICClassTableInfo set FCtlType=8 where (FClassTypeID = '1030002') AND FCaption_CHS = '是否开票'
update ICClassTableInfo set FUnControl=17 where (FClassTypeID = '1030002') AND FCaption_CHS = '是否开票'
update ICClassTableInfo set FCondition=0 where (FClassTypeID = '1030002') AND FCaption_CHS = '是否开票'
update ICClassTableInfo set FSourceType=1 where (FClassTypeID = '1030002') AND FCaption_CHS = '是否开票'
update ICClassTableInfo set FLookUpList='VALUELIST{0=开发票,1=不开发票}' where (FClassTypeID = '1030002') AND FCaption_CHS = '是否开票'
-- 把表头自定义2修改成销售部门
update ICClassTableInfo set FCaption_CHS = '销售部门' where (FClassTypeID = '1030002') AND FCaption_CHS = '表头自定义2'
update ICClassTableInfo set FCtlType=8 where (FClassTypeID = '1030002') AND FCaption_CHS = '销售部门'
update ICClassTableInfo set FUnControl=17 where (FClassTypeID = '1030002') AND FCaption_CHS = '销售部门'
update ICClassTableInfo set FCondition=0 where (FClassTypeID = '1030002') AND FCaption_CHS = '销售部门'
update ICClassTableInfo set FSourceType=1 where (FClassTypeID = '1030002') AND FCaption_CHS = '销售部门'
update ICClassTableInfo set FLookUpList='VALUELIST{0=销售1部,1=销售2部,2=销售3部}'
where (FClassTypeID = '1030002') AND FCaption_CHS = '销售部门'