问题现象:
销售选项设置只有几个参数,其他参数不显示。
解决方案:
请备份账套,执行以下脚本后重启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