我使用的是用友畅捷通T+财务管理软件,在操作T+T-UFO模块的时候碰到了个问题:
T+现金流量附表公式
请教用友财务软件工程师如何解决?具体的情况如下:
T+现金流量附表公式: 经营性应收项目的减少(增加以“-”号填列),本年的累计数工式如下:Get("企会01","B8","年-1","月","")+Get("企会01","B9","年-1","月","")+Get("企会01","B10","年-1","月","")+Get("企会01","B11","年-1","月","")+Get("企会01","B12","年-1","月","")+Get("企会01","B13","年-1","月","")
-Get("企会01","B8","年","月","")-Get("企会01","B9","年","月","")-Get("企会01","B10","年","月","")-Get("企会01","B11","年","月","")-Get("企会01","B12","年","月","")-Get("企会01","B13","年","月","") 是不是错了呢?为啥是年-1?应该是月-1才对吧?
公式格式本身没有错误,根据实际需要看取哪个数值,要取本年的话就用Get(\"企会01\",\"B8\",\"年-1\",\"月\",\"\")这个即可,不需要用年-1,这个只是个预制的形式,可根据实际需要进行修改的
那意思是说本身报表预置的这个工式就是错了
若一个账套里有两个年度,用新年度登录做报表取数,年-1取得就是上年企会01这个报表中B8单元格里的数,即相当于取得就是上年同期
Get(\"企会01\",\"B8\",\"年-1\",\"月\",\"\"),我的意思是这个本来就是年的,为啥要取年-1?
根据实际需要设置公式取数即可,年-1取得是上年的数据,月-1取数的是今年上月的数据,根据实际需要取哪一个数值进行修改即可