畅捷通T+选项部分销售项缺失

问：用友T+选项设置中，销售页签设置中只有两项设置，很明显是不正常而缺失了，如图下：

答：以上原因一般是由于后台数据库缺少某张表导致的，首先备份下账套，然后打开SQL Server Management Studio，执行下面的语句即可

执行语句如下：

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