首页 > 其他 > 详细

发票不能审核

时间:2020-02-07 18:31:18      阅读:67      评论:0      收藏:0      [点我收藏+]

update t_bas_systemprofile set fvalue = ‘1‘ where fkey =‘DoNotCheck‘ and fcategory = ‘AR‘

 

--单据转换修改

(((FBASICUNITQTY > 0 And FBASICUNITQTY > (FBUYIVBASICQTY + FSpecialQTY))  or  (FBASICUNITQTY  < 0 AND FBASICUNITQTY < (FBUYIVBASICQTY + FSpecialQTY)) or  FBASICUNITQTY  = 0)  And (FACCOUNTSYSTEM = 0 Or FACCOUNTSYSTEM.FISDEFAULT =‘1‘ ))   And FCUSTOMERID.FFREEZELIMIT  not  like ‘%Invoice%‘ 

--负数可以下推

update t2 set FOPENAMOUNTFOR=0,FIVALLAMOUNTFOR=0 from t_AR_receivable t1 inner join t_AR_receivableentry t2 on t1.FID=t2.FID
where FALLAMOUNT<0

 

发票不能审核

原文:https://www.cnblogs.com/allen1991/p/12272826.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!