报表公式有长度限制,导致重分类公式无法保存
金蝶云社区-云社区用户80441234
云社区用户80441234
0人赞赏了该文章 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