【问题描述】

报表单击【数据】→【明细分类账】系统提示:在FROM子句中多次指定了相关名称'vs_FFLEX6'。

【原因分析】

取数公式设置为“=Acct("","1122|[HSWD02_SYS~+~客户~+~CUST0001]|[HSWD02_SYS~+~客户~+~CUST0003]","Y","","","","")”形式时,联查明细分类账会提示上述报错,将公式改为“=Acct("","1122|[HSWD02_SYS~+~客户~+~;CUST0001;CUST0003]","Y","","","","")”形式即可。

【解决方案】

当取数的核算维度编码不连续时,建议用“=Acct("","1122|[HSWD02_SYS~+~客户~+~;CUST0001;CUST0003]","Y","","","","")”或“=Acct("","1122|[HSWD02_SYS~+~客户~+~CUST0001]","Y","","","","")+Acct("","1122|[HSWD02_SYS~+~客户~+~CUST0003]","Y","","","","")”形式,此时联查明细分类账即可不报错,这两者公式的设置联查明细账的展示效果会有区别,如下图所示,一般推荐使用第一种,联查明细账时会方便些,通过后一科目即可查看各个核算维度的数据,而第二种方案需要多次查询。

【备注】全文图片是在8.0.0.202208版本上操作所附的截图。