|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
【问题现象】
销售选项设置只有几个参数,其他参数不显示。
【解决方案】
请备份账套,执行以下脚本后重启T+服务:
update EAP_AccInformation set IsVisible='1' where ParentName='Tab4_Base' and name not in ('IsNoAutoSaleOutForMB','IsWriteBackInvMultiCode','ValidateExistsOffline')
declare @Manufacture varchar(10)
select @Manufacture=[value] from EAP_AccInformation where name='Manufacture'
declare @OutSource varchar(10)
select @OutSource=[value] from EAP_AccInformation where name='OutSource'
if (@Manufacture = '0' and @OutSource='0')
begin
update EAP_AccInformation set IsVisible='0' where name='ExceedProductByOrders'
end
declare @SAWorkflow varchar(10)
select @SAWorkflow=[value] from EAP_AccInformation where name='SAWorkflow'
if(@SAWorkflow='0')
BEGIN
Update EAP_AccInformation set IsVisible='0' where name='IsDeliveryOrderAutoStockOrder'
END |
|