先安装PT088926再安装打了PT098451 后
在会计分录序时簿中，打开某些凭证时报错：
已经自行测试：1、在KIS 专业版V12.3 不安装 任何补丁的环境，无上述报错问题
2、在KIS 专业按V12.3 安装综合补丁包 PT088926后 ，也无上述问题。
3、在KIS 专业版 V12.3 安装 PT088926、PT098451，后打开系统的一些凭证报错提示如上图。
自行测试有问题的凭证，可以删除，可以过账！就是不能打开，删除该不能查询的凭证，
重新在存货核算 用销售发票生成 该凭证，也是可以的，保存时也能调出该凭证，但是去到凭证序时簿，就无法再打开该凭证
去数据库表t_Voucher及t_VoucherEntry 分析该凭证无数据问题！
用SQL 跟踪 发现语句有问题。
语句如下：exec sp_executesql N'Select ve.FEntryID,ve.FExplanation,IsNull(a.FAccountID,0) as FAccountID,ve.FDetailID,IsNull(a.FNumber,'''') as FAccountNumber,IsNull(a.FName,'''') as FAccountName,IsNull(a.FLevel,1) as FLevel, IsNull(a.FFullName,'''') as FAcctFullName, IsNull(v.FGroupID,0) as FGroupID,ve.FCurrencyID,c.FNumber as FCurrencyNumber,c.FScale,c.FName as FCurrencyName,case when ve.Fcurrencyid<>1 then (case when isnull((select Fexchangerate from icsale where Fvchinterid=8477 and Fcurrencyid<>1),0)<>0 then (select Fexchangerate from icsale where Fvchinterid=8477 and Fcurrencyid<>1) else ve.Fexchangerate end) else ve.Fexchangerate end as Fexchangerate,ve.FDC,ve.FAmountFor,ve.FAmount,ve.FDC*ve.FAmount as FDebit,(1-ve.FDC)*ve.FAmount as FCredit,ve.FQuantity,ve.FMeasureUnitID,u.FName as FMeasureUnit,u.FUnitGroupID,u.FNumber as FMeasureUnitNumber,u.FCoefficient,ve.FUnitPrice,ve.FInternalInd,ve.FAccountID2,ve.FSettleTypeID,ve.FSettleNo,ve.FTransNo,ve.FCashFlowItem,ve.FTaskID,ve.FResourceID,IsNull(cu.FcussentID,0) as FcussentID,0 as FContrastID,FIsReadOnly=case when IsNull(cu.FIsHook,0)>0 or (a.FControlsystem=1 And v.FInternalInd in(''ar'',''ap'',''Industry'')) then 1 else 0 end, IsNull(fw1.FName,'''') as FCussentFrameWorkName,IsNull(fw1.FNumber,0) as FCussentFrameworkNum,IsNull(fw1.FFrameworkID,0) as FCussentFrameworkID, IsNull(fw1.FUserName,'''') as FCussentUserName,IsNull(fw1.FPassword,'''') as FCussentPassword,IsNull(fw1.FDatabaseLocation,'''') as FCussentDatabaseLocation From (select * from t_Voucher union all select * from t_VoucherBlankout) as v left join t_VoucherEntry as ve on v.FVoucherID=ve.FVoucherID left join t_Currency as c On ve.FCurrencyID = c.FCurrencyID left join t_MeasureUnit as u On ve.FMeasureUnitID = u.FMeasureUnitID Left outer join t_account as a On ve.FAccountID = a.FAccountID Left Outer Join t_GLCussent as cu on ve.FVoucherID=cu.FVoucherID And ve.FentryID =cu.FVoucherEntryID Left Outer Join t_Gr_FrameWorkItem as fi On a.FAccountID=fi.FItemID And fi.FItemType=0left outer join t_Gr_Framework as fw1 On fi.FFrameworkID=fw1.FFrameworkID Where ve.FVoucherID = @P1 Order By ve.FEntryID',N'@P1 int',8477
执行该语句也报错:
推荐阅读