U8中现金流量按部门查询的案例-用友U8

对应版本:用友U8.52对应产品线：财务系统对应模块：现金流量表模块问题现象:用户多个分公司做成部门在U8中统一核算，现金科目设为部门核算，但现金流量无法按部门查询。现金流量表和总账中现金流量统计表都只能全部统计问题原因：现金流量表和总账中现金流量统计表都只能全部统计解决方案：做自定义报表。在自定义报表中，录入如下语句：selectfitemss98.citemnameas项目名称,fitemss98.cDirectionas方向,sum(GL_cashtable.md-GL_cashtable.mc)as金额,Department.cDepNameas部门,GL_cashtable.iperiodas会计期间FromGL_cashtable,GL_accvouch,fitemss98,fitemss98class,DepartmentWhereGL_cashtable.iSignSeq=GL_accvouch.iSignSeqandGL_accvouch.ino_id=GL_cashtable.ino_idandGL_accvouch.inid=GL_cashtable.inidandGL_accvouch.iperiod=GL_cashtable.iperiodand(GL_accvouch.iflag=2orGL_accvouch.iflagisnull)andfitemss98.citemcode=GL_cashtable.cCashitemandfitemss98.citemccode=fitemss98class.citemccodeandDepartment.cDepCode=GL_accvouch.cdept_idand1=1groupbyfitemss98class.citemccode,fitemss98class.citemcname,fitemss98.citemcode,fitemss98.citemname,fitemss98.cDirection,Department.cDepName,GL_cashtable.iperiodorderbyfitemss98class.citemccode,fitemss98class.citemcname,fitemss98.citemcode,fitemss98.citemname,fitemss98.cDirection执行之，问题解决！

本文链接：https://www.bbsufida.com/u8/42511.html