在用友畅捷通T+的T+T-UFO中碰到如下问题:
资产负债表年初数设置公式
具体问题现象如下:
资产负债表的的“应收款项”的期末数=“应收账款”借方余额+“预收账款”借方余额-“坏账准备”余额+“应收票据”余额+其他应收款余额,报表模板中设置公式为:QM("1111","","年","月")+QM("1121","","年","月","借")+QM("1122","","年","月")-QM("1131","","年","月")+QM("2203","","年","月","借"),但年初数设置公式:QC("1111","","年")+QC("1121","","年","借")+QC("1122","","年")-QC("1131","","年")+QC("2203","","年","借"),没有数值呢?但把公式中的“借”取消,就有数值了?怎么回事?年初公式该如何才正确?
以下列示的内容为尝试性解决方案,如若下面的方案未能解决您的问题,可以添加用友软件工程师微信号进行咨询:https://www.xlsderp.com/24239.html。
年初如果设就要都设上方向,要么就都不设
发表评论