用友U8采购发票付款申请金额错误查询

haichao118

于 2021-08-25 08:10:55 发布

阅读量547

点赞数

分类专栏：用友文章标签：数据库开发

本文链接：https://blog.csdn.net/haichao118/article/details/119902768

版权

---发票付款申请金额
SELECT B.cVouchID, SUM(a.iApplyAmt_f) FROM dbo.AP_ApplyPayVouchs a INNER JOIN AP_ApplyPayVouch b ON a.PID=b.PID
WHERE a.cSource='采购发票' AND a.iBVid IN (
SELECT id FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE b.cPBVCode='52487154')
GROUP BY B.cVouchID

---发票总金额
SELECT SUM(a.iOriSum) FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE b.cPBVCode='52487154'

SELECT DISTINCT B.cVouchID , B.cOperator FROM dbo.AP_ApplyPayVouchs a INNER JOIN AP_ApplyPayVouch b ON a.PID=b.PID
WHERE a.cSource='采购发票' AND a.iBVid IN (
SELECT id FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE b.cPBVCode='52487154')

select * FROM ap_detail WHERE cCoVouchID='52487154'

---做凭证情况
SELECT DISTINCT cCoVouchType , cCoVouchID,cPZid FROM dbo.Ap_Detail WHERE c