以文本方式查看主题

-  安易免费财务软件交流论坛  (http://bbs.anyicw.com/bbs/index.asp)
--  安易小型V5E财务软件交流  (http://bbs.anyicw.com/bbs/list.asp?boardid=3)
----  [求助]现金流量表编制公式有误:  (http://bbs.anyicw.com/bbs/dispbbs.asp?boardid=3&id=20612)
--  作者：tbg5853
--  发布时间：2009/4/26 21:13:01
--  [求助]现金流量表编制公式有误:

存货
=(ZW("CJ",1,1403)+ZW("CJ",1,1406)+ZW("CJ",1;1407)+ZW("CJ",1,1411)ZW("CJ,1,1431)-ZW("CD",1,1461))-(ZW("MJ",0,1403)+ZW("MJ",0,1406)+ZW("MJ",0,1407)+ZW("MJ",0,1411)ZW("MJ",0,1431)-ZW("MD",0,1461))

经营性应收项目的减少
=(ZW("CJ",1,1121)+ZW("CJ",1,1122)+ZW("CJ",1;1123)+ZW("CJ",1,1231))-(ZW("MJ",0,1121)+ZW("MJ",0,1122)+ZW("MJ",0,1123)+ZW("MJ",0,1231))

=经营性应付项目的增加
-(ZW("CD",1,2201)+ZW("CD",1,2202)+ZW("CD",1,2205)+ZW("CD",1;2211)+ZW("CD",1,2221)+ZW("CD",1,2241))+(ZW("MD",0,2201)+ZW("MD",0,2202)+ZW("MD",0,2205)+ZW("MD",0,2211)+ZW("Md",0,2221)+ZW("MD",0,2241))