客户想要在销售汇总报表和销售明细里增加客户区域、业务员,赠品3列,
通过开发KISBOS报表可以满足客户需求,但是金蝶关闭了上传应用商店功能,通过几天测试可以变通解决,给大家提供个思路,谁有更好的方法也提供下。
1、金蝶专业版--我的KIS添加服务 选择一个已有的应用,如:成本损益表
2、KISBOS 辅助工具--插件报表调试工具 选择应用包,选择开发好的报表,点导入KIS
如果打开插件报表调试工具报错,执行语句
delete from t_AP_Product where fid='S1S006S001'
insert into t_AP_Product (FID, FName, FSubDirName, FUpgradeVer, FPlatVer, FForumID)
values ('S1S006S001','专业版','kis_pro_stan',20141205,20150623,107)
3、执行行语句
delete FROM T_RepFilter where FRepKey='APP003063'
delete FROM T_RepHeadCaption where FRepKey='APP003063'
UPDATE T_RepHeadCaption SET FRepKey='APP003063' where FRepKey='APP000484'
UPDATE T_RepFilter SET FRepKey='APP003063' where FRepKey='APP000484'
UPDATE T_RepFilter SET FRepKey='APP003063' where FRepKey='APP000484'
UPDATE T_RepList SET FRepKey='APP003063' where FRepKey='APP000484'
delete from T_RepList where FRepName='成本损益表'
UPDATE T_RepSql SET FRepKey='APP003063' where FRepKey='APP000484'
delete from T_RepSql where id in (select min(id) from T_RepSql where FRepKey='APP003063' group by FRepKey )
--APP003063是成本损益表内码 APP000484是测试应用内码
其他的报表修改APP003063后引入
推荐阅读