采購(gòu)訂單下(xià)推外(wài)購(gòu)入庫單，提示沒有(yǒu)符合條件(•←jiàn)的(de)記錄
2018-4-28 10:49:03 點擊：
先檢查下(xià)物(wù)料的(de)來(lái)料檢驗方 ±式是(shì)否為(wèi)免檢，如(rú)果不(bù)是(shìπ$)，則必須先下(xià)推收料通(tōng)知(zhī)單，再由收料通(t$δ≈↔ōng)知(zhī)單下(xià)推外(wài)購(gòu)入庫單；其次，采購(gòu)訂單的(dε≠ γe)【采購(gòu)方式】為(wèi)【直運采購(gòu)πβ 】或者【采購(gòu)範圍】為(wèi)【調拔】的(de)，不(bù)能(néngδ §★)下(xià)推外(wài)購(gòu)入庫單。如(rú)果上(shàng)述檢查沒有(yǒu)問← ©(wèn)題，請(qǐng)執行(xíng)以下(xià)語句解決：
觸發器(qì)：if (object_id('tgr_poorder_fvalidflag≤↓_insert', 'tr') is not null)
drop trigger tgr_poorder_fvalidf≈<§✔lag_insert
go
create trigger tgr_poorder_fvβ<±₩alidflag_insert
on poorder for in₽♠sert,update
as
declare @flag int,@fid int
select @flag = FValidFlag,@fid=FInterID from insertσ↔®ed;
if(@flag=0)
update♣γ ≤ POOrder set FValidFlag =1 where FIntλ&>erID=@fid
然後執行(xíng)下(xià)面語句修複曆史數(shù)據：
&nbs∑δδβp; update POOrder set FValidFlag=1✔ where FValidFlag =0
觸發器(qì)：if (object_id('tgr_poorder_fvalidflag≤↓_insert', 'tr') is not null)
drop trigger tgr_poorder_fvalidf≈<§✔lag_insert
go
create trigger tgr_poorder_fvβ<±₩alidflag_insert
on poorder for in₽♠sert,update
as
declare @flag int,@fid int
select @flag = FValidFlag,@fid=FInterID from insertσ↔®ed;
if(@flag=0)
update♣γ ≤ POOrder set FValidFlag =1 where FIntλ&>erID=@fid
然後執行(xíng)下(xià)面語句修複曆史數(shù)據：
&nbs∑δδβp; update POOrder set FValidFlag=1✔ where FValidFlag =0
- 上(shàng)一(yī)篇：銷售發票(piào)是(shì)否可(kě)以不(bù)鈎稽？ 2018/4/28
- 下(xià)一(yī)篇：收料通(tōng)知(zhī)單下(xià)推檢驗單，提示沒有(yǒu)符合條件÷δ≈(jiàn)的(de)記錄 2018/4/28
