问题描述 凭证查询系统提示“使用NULL 无效”

问题原因 T_Voucher、T_VoucherBlankOut 凭证表表头与T_VoucherEntry 凭证表表体不匹配

解决思路或

方法

备份账套后请参考如下语句处理：

Use AIS2009###### --（指问题账套的账套号）

DELETE FROM T_Voucher WHERE FVoucherID NOT IN (SELECT FVoucherID

FROM T_VoucherEntry)

DELETE FROM T_VoucherBlankOut WHERE FVoucherID NOT IN (SELECT

FvoucherID FROM T_VoucherEntry)

DELETE FROM T_VoucherEntry WHERE FVoucherID NOT IN (SELECT

FVoucherID FROM T_Voucher UNION SELECT FVoucherID FROM

T_VoucherBlankOut)

好像可以用执行语句修复