问:用友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
至此就分享完毕了,建议小伙们收藏并转发,不明白的小伙伴们可以联系我们!
补充:提供东莞用友软件,深圳用友软件,用友财务软件,进销存系统,用友ERP系统,MES系统等。