用友通发货明细表--用友通发货明细表
2015-2-13 0:0:0 wondial用友通发货明细表--用友通发货明细表
用友通发货明细表">用友通发货明细表发货明细表按照客户查询的时候,在发货明细表里点击格式按钮,将“客户”下移到第二行,之后在表体里“客户”一列消失了,格式里面的“客户”也没有了。——————————–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 (‘发货明细表(货物)’, ‘发货明细表(部门)’, ‘发货明细表(客户)’, ‘发货明细表(业务员)’, ‘发货明细表(仓库)’)) end GO –更新发货明细表(客户)显示 update rpt_flddef SET visible = -1 where id = 1363 and modeex = 0 and expression = ‘[Customer].[cCusAbbName]‘ GO ——————–begin 发货明细表 重新排序 Declare @ID int Declare @ID_Field int Declare @iOrderEx int Declare Glb_Cur Cursor for select ID from rpt_Glbdef where name like ‘发货明细表%’ and SystemID = ‘SA’ Open Glb_Cur Fetch Next FROM Glb_Cur Into @ID WHILE @@FETCH_STATUS = 0 Begin delete from Rpt_FldDEF where id = @ID and Expression = ‘cDefine22′ –重新排序(显示列排在前) update Rpt_FldDEF set OrderEx = 0 where Id = @ID and modeEx = 0 and visible = 0 Set @iOrderEx = 0 Declare Fld_Cur Cursor For Select ID_Field from Rpt_FldDEF Where Id = @ID And ModeEx = 0 order by visible,OrderEx Open Fld_cur Fetch Next FROM Fld_Cur Into @ID_Field WHILE @@FETCH_STATUS = 0 Begin Set @iOrderEx = @iOrderEx + 1 Update Rpt_FldDef Set OrderEx = @iOrderEx Where Id = @ID And ModeEx = 0 And ID_Field = @ID_Field Fetch Next FROM Fld_Cur Into @ID_Field End CLOSE Fld_Cur DEALLOCATE Fld_Cur Fetch Next FROM Glb_Cur Into @ID End CLOSE Glb_Cur DEALLOCATE Glb_Cur GO ——————–end 重新排序。
如果您的问题还没有解决,可以到 T+搜索>>上找一下答案
相关阅读
- 用友U8不同的核算方式如何影响存货成本2021-10-9 10:15:1
- 用友U8材料采购科目借贷发生不平有余额是什么原因详解2021-10-9 9:57:49
- 用友U8电子文档管理详解2021-9-26 11:31:31
- 用友U8哪些办法可以让库存更准确详解2021-9-26 11:24:19
- 用友u8无法自动备份问题解决方法2020-4-10 10:50:44
- 用友U8固定资产科目设置详解2020-4-8 8:14:24
- U8标准成本详解2019-9-29 13:36:49
- 2005装好后登陆端口1433被禁用2019-4-23 8:0:0
- 总账与辅助账对账不平2019-4-23 8:0:0
- 总账进入软件时报行业性质不符2019-4-23 8:0:0
最新信息
用友u8软件不同客户价格的设置不同客户价格的设置
不同客户价格的设置原因分析:连锁加盟版中增加了协议价的功能,可以支持不同客户对不同商品的价格也不同的功能。问题解答:在价格管理---协议价设置进行设置,在价格系统设置中--售价提取中只选择协议价