问题描述:年结存提示:系统存在未结算完成的收/付款单据或者超额收/付款的单据,不能选择“按单据进行结转”这种方式!
处理方法:年结存选项中可以勾选【单据超收超付金额和收付款单未结算金额结转至期初收付款单】的选项,如下图所示:
PS:如果需要查询,哪些单据超收、单据金额为0又有抹零金额的这些异常单据的话,可以对账套数据执行下面语句查询异常单据。
SELECT CompleteTotal,preferencemoney,totalmoney,totalinmoney,* FROM dbo.BillIndex b
WHERE draft=0 AND RedWord=0
AND (BillType IN (4,66) AND NOT EXISTS(SELECT 1 FROM dbo.CompleteTotal
WHERE MoneyBillID=b.BillNumberId GROUP BY Moneybillid
HAVING SUM(NCompleteTotal)=b.Ntotalmoney+b.Npreferencemoney)
OR ( (abs(Ntotalinmoney + NCompleteTotal + Npreferencemoney)>abs(Ntotalmoney) Or(Ntotalmoney>0 and Ntotalinmoney + NCompleteTotal + Npreferencemoney<0) or (Ntotalmoney<0 and Ntotalinmoney + NCompleteTotal + Npreferencemoney>0))
and BillType in(6,11,34,45,141,145,148,160,161,36,84,85,93,148,149,150,151,181,167,168,170,172,115,116,128,129)))