KIS 专业版 V12.3 打过综合补丁包PT098451,引出新的问题!

栏目:kis知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

KIS 专业版 V12.3 打过综合补丁包PT098451,引出新的问题!


先安装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

执行该语句也报错:


问题确实存在,将出补丁解决此问题,预计9.8对外发布

进过反复测试,按如下方法可以在演示账套中重新问题:
在打了PT098451 补丁包的 任意账套新增两张外币销售发票(专用),然后存货核算生成凭证,
选择做好的两张销售发票,采用所有选择的单据生成汇总凭证的方式(借贷合并),生成一张凭证,提示成功!
然后去凭证管理里,打开这张凭证,报错无法打开!

总结:外币销售专用发票,生成的汇总凭证,无法在凭证管理中打开!

KIS 专业版 V12.3 打过综合补丁包PT098451,引出新的问题!

先安装PT088926再安装打了PT098451 后在会计分录序时簿中,打开某些凭证时报错:已经自行测试:1、在KIS 专业版V12.3 不安装 任何补丁...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息