发布时间:2025-8-21
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品8折优惠。
公式列表:
期初余额(QC):=QC("1001","","年","月")
年初余额(QC):=QC("1001","","年")
期末余额(QM):=QM("1001","","年","月")
取辅助项的余额:=QC("1001","","年","月","","项目_项目A")
辅助项录入的形式为“辅助项类型_辅助项的具体值”,例如项目_项目A,部门_销售部
发生额(FS):=FS("1001","","年","月","借","项目_项目A")
累计发生额(LFS):=LFS("1401","","年","月","借","项目_项目A")
净额(JE):=JE("5601","","年","月","项目_项目A")
累计净额(LJE):=LJE("5601","","年","月","项目_项目A")
本月金额与上月金额同页显示:本月=QM("1001","","年","月")
上月=QM("1001","","年","月-1")
具体取某个月的发生额:=JE("6605","","年","1")+JE("6606","","年","1")
在公式后面加减乘除一个固定值:=C5*0.25(不使用%,用小数代替)
取某个季度的净额:=LJE("5403","","年","季@1")
取某个科目的借方余额:=QM("222101","","年","月","自借")
取某个科目的辅助核算借方余额=QM("1221","","年","月","辅借")
取百分比、占比:=BFS(N6/N4,2)(N6单元格占N4单元格的比例)
客服电话:400-665-0028
关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司
版权所有:用友畅捷通软件 Copyright © 2025 All rights reserved.