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

---发票付款申请金额
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 cVouchType='49' AND cVouchID IN (
SELECT B.cVouchID FROM dbo.Ap_CloseBills A INNER JOIN Ap_CloseBill B ON A.IID=B.IID WHERE A.cCoVouchID IN (
SELECT B.cVouchID 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 cCoVouchType,cCoVouchID,bPrePay,SUM(icamount-idamount) 
FROM dbo.Ap_Detail WHERE iFlag<3 AND cDwCode='0104021' AND cCoVouchType='01'
GROUP BY cCoVouchType,cCoVouchID,bPrePay  HAVING SUM(icamount-idamount)<>0

SELECT bPrePay,SUM(icamount-idamount) 
FROM dbo.Ap_Detail WHERE iFlag<3 AND cDwCode='0104021'  AND cCoVouchType='01'
GROUP BY bPrePay

SELECT * FROM dbo.AP_PayDetail WHERE cSource='采购发票' 
AND iBVid IN (SELECT id FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE b.cPBVCode IN (
SELECT cCoVouchID
FROM dbo.Ap_Detail WHERE iFlag<3 AND cDwCode='0104021' AND cCoVouchType='01'
GROUP BY cCoVouchID))
-- HAVING SUM(icamount-idamount)<>0

SELECT * FROM dbo.AP_PayDetail WHERE cSource='采购订单' 
AND iBVid IN (SELECT a.iPOsID FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE b.cPBVCode IN (
SELECT cCoVouchID
FROM dbo.Ap_Detail WHERE iFlag<3 AND cDwCode='0104021' AND cCoVouchType='01'
GROUP BY cCoVouchID HAVING SUM(icamount-idamount)<>0))

SELECT iApplySum_f * FROM dbo.AP_V_PUBillApply WHERE PBVID IN (
SELECT PBVID FROM purbillvouch WHERE cPBVCode IN (
'16748623'
,'16748683'
,'32069334'
,'32069336'
,'32069350'))

SELECT DISTINCT cCoVouchType , cCoVouchID,cPZid FROM dbo.Ap_Detail WHERE cVouchType='49' AND cVouchID IN (
SELECT B.cVouchID FROM dbo.Ap_CloseBills A INNER JOIN Ap_CloseBill B ON A.IID=B.IID WHERE A.cCoVouchID IN (
SELECT b.cVouchID FROM dbo.AP_ApplyPayVouchs a INNER JOIN AP_ApplyPayVouch b ON a.PID=b.PID
WHERE a.cSource='采购发票' AND  a.iBVid IN (
SELECT a.id FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE cPBVCode IN (
'16748623'
,'16748683'
,'32069334'
,'32069336'
,'32069350'))))

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 a.id FROM purbillvouchs a INNER JOIN purbillvouch b ON a.PBVID=b.PBVID WHERE cPBVCode IN (
'16748623'
,'16748683'
,'32069334'
,'32069336'
,'32069350')) GROUP BY b.cVouchID