销售选项设置缺失

iufida

【问题现象】销售选项设置只有几个参数，新建账套也这样,正常账套对比是缺少了很多选项

                               
登录/注册后可看大图

                               
登录/注册后可看大图

【问题方案】备份好账套，执行以下ｓｑｌ处理，然后重启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'

END