問(wèn):用友T+選項(xiàng)設(shè)置中,銷售頁(yè)簽設(shè)置中只有兩項(xiàng)設(shè)置,很明顯是不正常而缺失了,如圖下:


答:以上原因一般是由于后臺(tái)數(shù)據(jù)庫(kù)缺少某張表導(dǎo)致的,首先備份下賬套,然后打開(kāi)SQL Server Management Studio,執(zhí)行下面的語(yǔ)句即可


執(zhí)行語(yǔ)句如下:
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
至此就分享完畢了,建議小伙們收藏并轉(zhuǎn)發(fā),不明白的小伙伴們可以聯(lián)系我們!
補(bǔ)充:提供東莞用友軟件,深圳用友軟件,用友財(cái)務(wù)軟件,進(jìn)銷存系統(tǒng),用友ERP系統(tǒng),MES系統(tǒng)等。