【问题现象】
销售选项设置只有几个参数,新建账套也这样,正常账套对比是缺少了很多选项
备份好账套,执行以下sql处理,然后重启T+服务,对应的是17.0版本的一个账套问题方案
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'
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)