--总账版检查凭证 发现是此段代码在作祟
if (@nSwitch & POWER(2,0) = 0) AND EXISTS (SELECT 1 FROM dbo.sysdata WHERE SubName = 'FINANCE' AND SubValue = '1' )
BEGIN
SET @smodDate = ''
SELECT @sdate = [date] FROM dlyndx where vchcode = @nvchcode
SELECT @smodDate = [date] from dbo.Modidlyndx WHERE ModiVchcode = @nModivchcode
IF EXISTS ( SELECT 1 FROM (select fromvchcode,FromVchtype from FDlyNdx UNION ALL select fromvchcode,FromVchtype from FVchcodeDlyNdx) a,
(SELECT vchcode,VchType FROM dlyndx WHERE [date] > @sdate OR vchcode >= @nvchcode OR ([date] > @smodDate AND @smodDate <> '')
) b WHERE a.FromVchcode = b.vchcode AND a.FromVchtype = b.Vchtype) return -822
END
附常见错误提示