Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

问题描述:年结存提示:系统存在未结算完成的收/付款单据或者超额收/付款的单据,不能选择“按单据进行结转”这种方式!

处理方法:年结存选项中可以勾选【单据超收超付金额和收付款单未结算金额结转至期初收付款单】的选项,如下图所示:

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)))




  • No labels