文档介绍:DoEvaluateFormula(
switch(
BillKey()={shiyongmingxibi},SetTableFilter(0,"(huanru is null or (huanru is not null and MtlAmount1>shuliang)) and days(billdate)+shiyongqixian<=days(current date)"),
BillKey()={caigoudingdanzh},SetTableFilter(0,"daohuoriqi is null and days(yujidaohuoriqi)<=days(current date)")
)
);
={(select ,didian,billtype,,XSHTH,EmployeeID,zhangqi,caigoumoney,coalesce(jine,0)+coalesce(tuihuomoney,0) - coalesce(fukuan,0) as weifukuanmoney,fukuan,jine,tuihuomoney,rukuriqi,date(rukuriqi+zhangqi days) as riqi,kaipiaomoney from (select distinct SupplierID,didian,billtype,CGDDH,XSHTH,EmployeeID,zhangqi,sum(TotalMoney) as caigoumoney from SCM_StockOrderHead h left join SCM_StockOrderDtl d on = where status=10 group by SupplierID,didian,billtype,CGDDH,XSHTH,EmployeeID,zhangqi)a left join (select caigoudingdanha,PayObject,sum(fukuanjine) as fukuan from SCM_OutPayPaymentHead h join SCM_OutPayPaymentDtl d on = where status=10 group by caigoudingdanha,PayObject) b on = and = left join (select CGDDH,SupplierID,sum(totalmoney) as jine,max(billdate) rukuriqi from scm_stockinhead h left join scm_stockindtl d on = where