报表公式有长度限制,导致重分类公式无法保存
610次浏览
编辑于2016年03月08日 10:25:47
以应收预收为例,应收账款有四个二级科目,重分类时需要按照明细科目明细核算项目进行。
应收账款期末数设置公式为:(PS 1231是坏账准备)
=Acct("","1122.0001|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","JY","","","","")+Acct("","1122.0002|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","JY","","","","")+
Acct("","1122.0003|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","JY","","","","")+Acct("","1122.0004|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","JY","","","","")+Acct("","2203|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","JY","","","","")-Acct("","1231|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","Y","","","","")
粘贴到Fx中后公式只剩下如下:
=Acct("","1122.0001|[HSWD02_SYS~+~客户~+~0001.0000:F0026]","JY","","","","")
环境是CLOUD6.0,1月份补丁。
联系QQ 1661338496
推荐阅读