完工产品成本汇总表查询没有任何数据 问题描述：U852打上最新的HOTFIX和DBHOTFIX后，完工产品成本汇总表查询没有任何数据。 问题原因：打上最新的HOTFIX和DBHOTFIX后经测试在999演示帐套上，没有发现该现象。也可能跟您的数据库有关系。经跟踪发现查询完工产品成本汇总表时程序会执行如下脚本（假设当前期间为11月）： select 11 as iPeriod,Department.cDepName,Ca_Inventory.cInvName,t1.* from (select cppid,cbatch, max(iFinQua) as iFinTotalQua , sum(case camotype when 0 then (iFinPdtUnitAmo*iFinqua) else 0 end) as iFinMatTotalAmo, Sum(case camotype when 1 then (iFinPdtUnitAmo*iFinqua) else 0 end) as iFinPayTotalAmo, Sum(case camotype when 2 then (iFinPdtUnitAmo*iFinqua) else 0 end) as iFinAuxTotalAmo, Sum(case camotype when 3 then (iFinPdtUnitAmo*iFinqua) else 0 end) as iFinManTotalAmo, Sum(case camotype when 4 then (iFinPdtUnitAmo*iFinqua) else 0 end) as iFinOthTotalAmo, case max(ifinqua) when 0 then 0 else Sum(itotalAmo-ionptotalamo)/max(ifinqua) end as iFinUnitAmo, sum(iFinPdtUnitAmo*iFinqua) As iFinTotalAmo From CA_AmoCt Where iPeriod =11 group by cppid,cbatch) as t1 inner Join productstructureEx inner JOIN Department ON productstructureEx.cDepCode = Department.cDepCode ON t1.cPPID = productstructureEx.cPSPCode inner JOIN Ca_Inventory ON t1.cPPID = Ca_Inventory.cInvCode 解决方案：游客无权查看 相关补丁：模块：成本管理产品：U852--管理会计--成本管理问题名称：完工产品成本汇总表查询没有任何数据更新时间：2006-02-14 00:00:00 有用 没用92 浏览 分类 U8知识库用友U8知识库(旧)畅捷通知识库用友NC知识库用友U9知识库用友政务知识库致远OA知识库U8Cloud知识库