用友T+/ 总账/ 总账下的总账概况,取值取自何处?
作者:用友软件(广州)客户服务中心
来源:www.ufida168.com
发布时间:2026-04-21
总账下的总账概况,取值取自何处?【问题现象】 总账下的总账概况,取值取自何处?
【取值说明】 此处取值取自科目余额表,公式为后台设置,不可前端修改; 取值来源后台数据库可查询dbo.EAP_ReportPanelItem表; 查询语句(语句中现金等可更换为实际要查询的字段): SELECT * FROM dbo.EAP_ReportPanelItem WHERE SubTitle IN('现金', '银行存款', '其他货币')
具体取值公式如下: 今日资金余额: 现金:QM("1001","","年","","","","本币","{Today}","Y") 银行存款:QM("1002","","年","","","","本币","{Today}","Y") 其他货币:QM("1012","","年","","","","本币","{Today}","Y")
本月库存资金: 总额:QM("1401","","年","月")+QM("1402","","年","月")+QM("1403","","年","月")+QM("1404","","年","月")+QM("1405","","年","月")+QM("1407","","年","月")+QM("1408","","年","月")+QM("1411","","年","月")+QM("1421","","年","月")+QM("4001","","年","月") 库存商品:QM("1405","","年","月") 原材料:QM("1403","","年","月")
本月往来账款: 应收账款:QM("1122","","年","月") 应付账款:QM("2202","","年","月")
本月费用: 销售费用:FS("5601","","年","月","借") 管理费用:FS("5602","","年","月","借") 财务费用:FS("5603","","年","月","借")
本月应缴税费: 增值税:FS("222101","","年","月") 所得税:FS("5801","","年","月") 其他:FS("2221","","年","月")-FS("222101","","年","月") 1 END 1
|
关键词: 系统管理,财务管理,用友管理,用友U8 cloud,财务,销售,用友U8c供应链管理软件,采购管理,U8c销售管理软件
相关服务

