用友u8软件应付红字付款单预警
2018-07-18 12:23 来源:用友
应付红字付款单预警原因分析:自定义预警方式解决!问题解答:在自定义预警源中设置一个预警源,然后语句用下面的语句,并启用门户预警就可以了!select ctypename as 单据名称,cVouchID as 单据号,dVouchDate as 单据日期, cExch_Name as 币种,case when cVouchType='49' then iAmount_f else -iAmount_f end as 金额 from AP_CloseP where cCheckMan Is Null and ctypename like '%收款%'