T+11.6 往来单位里面显示有预付款但是做预付冲应付选不了，查询付款单明细未核销的有

往来单位里面显示有预付款但是做预付冲应付选不了，查询付款单明细未核销的有。

问题回复：

做好数据备份，执行以下脚本： 

UPDATE AA_Partner SET AdvPBalance=TEMP.AdvPBalance FROM AA_Partner P,(select idpartner,SUM(SettleAmount) as AdvPBalance from ARAP_Detail where isArFlag=0 and prepayFlag=1 and auditBussinessFlag=1 and auditFlag=1 group by idpartner ) AS TEMP WHERE P.id=TEMP.idpartner and p.AdvPBalance!=TEMP.AdvPBalance UPDATE AA_Partner SET AdvRBalance=TEMP.advRBalance FROM AA_Partner P,(select idpartner,SUM(SettleAmount) as advRBalance from ARAP_Detail where isArFlag=1 and prepayFlag=1 and auditBussinessFlag=1 and auditFlag=1 group by idpartner ) AS TEMP WHERE P.id=TEMP.idpartner and p.AdvRBalance!=TEMP.advRBalance