|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
【问题现象】
13.0使用友空间中的T+下单,单据打印设置中,含税单价和含税金额,显示列是灰色的,无法勾选。
【解决方案】
把数据备份好,执行语句:
--更新移动端销售订单打印模板中 含税金额和含税单价可以修改勾选
update eap_MBColumnSet set IsSelected = 1,AllowSelect = 1
where Field in ('OrigTaxAmount','OrigTaxPrice') and MBSolutionID = (select id from eap_MBColumnSetSolution where Name = 'SaleOrderDTO')
and GroupID = (select id from eap_MBColGroup where MBSolutionID = ((select id from eap_MBColumnSetSolution where Name = 'SaleOrderDTO')) and Name = 'Body')
--更新移动端销货单打印模板中 含税金额和含税单价可以修改勾选
update eap_MBColumnSet set IsSelected = 1,AllowSelect = 1
where Field in ('OrigTaxAmount','OrigTaxPrice') and MBSolutionID = (select id from eap_MBColumnSetSolution where Name = 'SaleDeliveryDTO') and GroupID = (select id from eap_MBColGroup where MBSolutionID = ((select id from eap_MBColumnSetSolution where Name = 'SaleDeliveryDTO')) and Name = 'Body')
执行完语句后,可以正常勾选显示
|
|