发出商品不平对账，更换了核算体系，导致获取不到成本

--查询出库单和下游应收单成本金额不一致的单据
select a.FCURRENCYID,a.fdate,f.FPRICEBASEQTY,a.fdate,b.fseq,e.fbillno 出库单号,a.fbillno 应收单号,round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT,2) 修改后的成本金额
,a.fid,b.FCOSTAMTSUM 应收明细成本金额,b.FBASICUNITQTY 应收计价基本数量,b.fentryid,f.FCOSTAMOUNT 出库成本金额,f.FCOSTAMOUNT_LC 出库成本金额本位币,b.FMATERIALID,f.FPRICEBASEQTY 出库单计价基本数量,d.FMATERIALID,e.fbillno,d.fentryid 
--update b set b.FCOSTAMTSUM=round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT_LC,2)  --更新明细成本金额
from t_ar_receivable a
inner join t_ar_receivableentry b on a.fid=b.fid
inner join t_ar_receivableentry_lk c on b.fentryid=c.fentryid and c.fstablename='T_SAL_OUTSTOCKENTRY'
inner join T_SAL_OUTSTOCKentry d on d.FENTRYID=c.fsid and d.fid=c.fsbillid
inner join T_SAL_OUTSTOCKENTRY_F f on f.FENTRYID=d.FENTRYID
inner join T_SAL_OUTSTOCK e on e.fid=f.fid 
where b.FCOSTAMTSUM<>isnull(round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT_LC,2) ,0)
and a.FDATE BETWEEN '2025-04-01' AND '2025-04-30' 
AND a.fsettleorgid=1 

--查询退货单和下游应收单成本金额不一致的单据
select a.FCURRENCYID,a.fdate,f.FPRICEBASEQTY,round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT_LC,2),a.fdate,b.fseq,e.fbillno 退货单号
,a.fbillno 应收单号,round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT,2) 修改后的成本金额
,a.fid,b.FCOSTAMTSUM 应收明细成本金额,b.FBASICUNITQTY 应收计价基本数量,b.fentryid,f.FCOSTAMOUNT 出库成本金额,f.FCOSTAMOUNT_LC 出库成本金额本位币,b.FMATERIALID,f.FPRICEBASEQTY 出库单计价基本数量,d.FMATERIALID,e.fbillno,d.fentryid 
--update b set b.FCOSTAMTSUM=round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT_LC,2)  --更新明细成本金额
from t_ar_receivable a
inner join t_ar_receivableentry b on a.fid=b.fid
inner join t_ar_receivableentry_lk c on b.fentryid=c.fentryid and c.fstablename='T_SAL_RETURNSTOCKENTRY'
inner join t_sal_returnstockentry d on d.FENTRYID=c.fsid and d.fid=c.fsbillid
inner join t_sal_returnstockentry_f f on f.FENTRYID=d.FENTRYID
inner join t_sal_returnstock e on e.fid=f.fid
where  b.FCOSTAMTSUM<>round(b.FBASICUNITQTY/f.FPRICEBASEQTY*f.FCOSTAMOUNT_LC,2) 
and a.FDATE BETWEEN '2025-04-01' AND '2025-04-30' 


--更新暂估冲回单成本金额
select a.fbillno,b.fcostamtsum,b.FBASICUNITQTY,a.FAPPROVEDATE,b.fentryid,d.fentryid,e.fbillno,e.FISINIT,d.fcostamtsum,d.FBASICUNITQTY
,round(b.FBASICUNITQTY/d.FBASICUNITQTY*d.FCOSTAMTSUM,2)
--update b set b.FCOSTAMTSUM=round(b.FBASICUNITQTY/d.FBASICUNITQTY*d.FCOSTAMTSUM,2)
from t_ar_receivable a
left join T_AR_RECEIVABLEENTRY b on b.fid=a.fid  --暂估冲回单
inner join T_AR_RECEIVABLEENTRY d on d.FENTRYID=b.FSRCROWID
left join t_ar_receivable e on e.fid=d.fid
where a.FSETACCOUNTTYPE=2 and a.FBYVERIFY=2 and e.FSETACCOUNTTYPE=2 and e.FBYVERIFY=0 and e.FISINIT=1 
and b.FCOSTAMTSUM<>round(b.FBASICUNITQTY/d.FBASICUNITQTY*d.FCOSTAMTSUM,2)

--更新财务单成本金额
select a.fbillno,a.fdate,b.fcostamtsum,b.FSOURCEBILLNO,c.* 
--update b set b.FCOSTAMTSUM=c.fcostamtsum
from T_AR_RECEIVABLE a
left join T_AR_RECEIVABLEENTRY b on a.fid=b.fid
inner join (
	select a.fbillno,b.fentryid,round(sum(c.FBASICUNITQTY/d.FBASICUNITQTY*d.FCOSTAMTSUM),2) FCOSTAMTSUM
	--select a.fbillno,b.FCOSTAMTSUM,b.FBASICUNITQTY,c.FBASICUNITQTY,d.FBASICUNITQTY,d.FCOSTAMTSUM,round(sum(c.FBASICUNITQTY/d.FBASICUNITQTY*d.FCOSTAMTSUM) over(partition by b.fentryid),2) ,c.* 
	from T_AR_RECEIVABLE a
	left join T_AR_RECEIVABLEENTRY b on a.fid=b.fid
	inner join t_ar_receivableentry_lk c on b.fentryid=c.fentryid 
	left join T_AR_RECEIVABLEENTRY d on c.fsbillid=d.fid and c.fsid=d.fentryid
	where a.FSETACCOUNTTYPE=3 
    and a.FDATE BETWEEN '2025-04-01' AND '2025-04-30' 
	AND a.FSALEORGID=1 
	group by b.fentryid,a.fbillno
) c on b.fentryid=c.fentryid 
 where b.fcostamtsum<>c.fcostamtsum