| 解決方案: |
自定義預(yù)警語句供參考：目的，當(dāng)自定義項6減3天等于系統(tǒng)日期時，給予提示。
select csbvcode as '發(fā)票號',ccuscode as '客戶名稱',cdepcode as '部門編碼',
cast(year(ddate)as varchar)+'-'+cast(month(ddate) as varchar)+'-'+cast(day(ddate) as varchar) as '單據(jù)日期',
cast(year(cdefine6)as varchar)+'-'+cast(month(cdefine6) as varchar)+'-'+cast(day(cdefine6) as varchar) as '收款日期',
DATEADD(day,-3,cdefine6) as '預(yù)警日期'
from salebillvouch where DATEADD(day,-3,cdefine6)=(select convert(char(10),getdate(),120) as yourdate)
設(shè)置方法：1.預(yù)警設(shè)置---自定義預(yù)警源--增加。2.預(yù)警源名稱和描述自行設(shè)置，把語句拷入。選中帳套及年度，進行測試及保存。3.在預(yù)警設(shè)置--添加，名稱自行輸入，預(yù)警源選擇‘自定義預(yù)警源’中自定義的名稱。4.設(shè)置好預(yù)警時間及通知對象。
|
