用友u8软件发货明细表_0
2015-1-5 0:0:0 wondial用友u8软件发货明细表_0
发货明细表发货明细表
原因分析:发货明细表发生错乱,开发提供了一个补丁,见解决方法。问题解答:--------------------------------begin 发货明细表 补丁脚本Begin Declare @cItemName varchar(20) Set @cItemName = (Select cItemName from userDef Where cID = '01') If @cItemName Is Null update rpt_flddef set Name = '自定义项1' where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表(货物)', '发货明细表(部门)', '发货明细表(客户)', '发货明细表(业务员)', '发货明细表(仓库)')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表(货物)', '发货明细表(部门)', '发货明细表(客户)', '发货明细表(业务员)', '发货明细表(仓库)')) Set @cItemName = (Select cItemName from userDef Where cID = '02') If @cItemName Is Null update rpt_flddef set Name = '自定义项2' where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表(货物)', '发货明细表(部门)', '发货明细表(客户)', '发货明细表(业务员)', '发货明细表(仓库)')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表(货物)', '发货明细表(部门)', '发货明细表(客户)', '发货明细表(业务员)', '发货明细表(仓库)')) endGO--更新发货明细表(客户)显示update rpt_flddef SET visible = -1 where id = 1363 and modeex = 0 and expression = '[Customer].[cCusAbbName]'GO--------------------begin 发货明细表 重新排序Declare @ID intDeclare @ID_Field intDeclare @iOrderEx int Declare Glb_Cur Cursor forselect ID from rpt_Glbdef where name like '发货明细表%' and SystemID = 'SA'Open Glb_Cur Fetch Next FROM Glb_Cur Into @IDWHILE @@FETCH_STATUS = 0Begin delete from Rpt_FldDEF where id = @ID and Expression = 'cDefine22'--重新排序(显示列排在前)update Rpt_FldDEF set OrderEx = 0 where Id = @ID and modeEx = 0 and visible = 0Set @iOrderEx = 0 Declare Fld_Cur Cursor For Select ID_Field from Rpt_FldDEF Where Id = @ID And ModeEx = 0 order by visible,OrderExOpen Fld_cur Fetch Next FROM Fld_Cur Into @ID_FieldWHILE @@FETCH_STATUS = 0BeginSet @iOrderEx = @iOrderEx + 1Update Rpt_FldDef Set OrderEx = @iOrderEx Where Id = @ID And ModeEx = 0 And ID_Field = @ID_FieldFetch Next FROM Fld_Cur Into @ID_FieldEnd CLOSE Fld_CurDEALLOCATE Fld_Cur Fetch Next FROM Glb_Cur Into @IDEnd CLOSE Glb_CurDEALLOCATE Glb_CurGO--------------------end 重新排序如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- U8+移动销售下单解决方案2019-5-29 8:8:13
- 用友U8vs金蝶K314.0竞争分析报告详解2019-5-10 17:27:59
- U8 cloud 1.0发版说明-管理会计篇2019-5-9 14:44:2
- U8v15.0总账报表操作手册2019-5-8 10:47:55
- U8+V15.0发版说明2019-5-8 10:19:37
- 启用标准成本后,对方科目设置中找不到暂估科目设置2019-5-7 8:0:0
- U860Sp1核算收发存汇总表查询下标越界2019-5-7 8:0:0
- 存货XX没有找到批次结存,请参照录入2019-5-7 8:0:0
- 点库存模块提示-2147,其他操作节点也报错。2019-5-7 8:0:0
- 套打纸张无法选择2019-5-7 8:0:0
最新信息
T1总是提示演示版是怎么回事 T1总是提示演示版是怎么回事[]
您好,您用的是T1哪个版本的软件?您也可以尝试在知识库中搜索演示版,里面有详细的解决方案可参考。@畅捷服务刘礽:现在客户这里没有网,可以给我发一下吗?谢谢,这个是t1 t3连用的,t3可以用就t1不行@利德科技&高敬:您好,我现在在车上手机值班,您可以稍后有网的时候再下载,也可以留下邮箱等我在电脑旁边再給您发。