問:用友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系統等。