用友财务软件互动问答平台

 找回密码
 立即注册
查看: 1187|回复: 1

用友U8.61软件中UFPMP?

[复制链接]
发表于 2016-9-25 16:28:01 | 显示全部楼层 |阅读模式
问题现象:在用友8.61erp系统中用友U8版本号:U8.61软件的财务系统产品线预算管理模块出现如下问题:用户环境:u用友U861ERP系统预算管理,已经打好8月30号的预算管理的补丁.现用户在定义以下公式保存时出错,估计应该是公式过长引起的。请帮忙解决为感.此公式主要目的是将业务预算转化成财务预算,多个业务预算的项目几个部门的预算要取到财务预算中来用户定义的公式:GETBG(预算版本号,"2020102020104","11211001",周期类型,预算周期,,,,,,,账套号,账套年度)-GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ",预算机构,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",102,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",103,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",104,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",109,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",111,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",113,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",115,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",116,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",117,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",118,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",119,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",120,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",121,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011601","11211001",周期类型,预算周期,"Organ",预算机构,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011602","11211001",周期类型,预算周期,"Organ",预算机构,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",102,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",103,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",104,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",109,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",111,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",115,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",116,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",117,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",118,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",119,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",120,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",121,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","102",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","103",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","104",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","109",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","111",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","113",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","115",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","116",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","117",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","118",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","119",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","121",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","120",,,,,账套号,账套年度)请帮忙解答!
原因分析:使用中间项目解决,如取管理费用=超长公式,那么建1个上级项目10个下级项目放到一个中间表中,把超长公式分成10份,10个项目分别取,然后再管理费用=10个项目的上级项目即可。公式最多支持3000个字符。
解决方案:在用友erp 系统版本U8.61软件中使用中间项目解决,如取管理费用=超长公式,那么建1个上级项目10个下级项目放到一个中间表中,把超长公式分成10份,10个项目分别取,然后再管理费用=10个项目的上级项目即可。公式最多支持3000个字符。
回复

使用道具 举报

发表于 2016-9-25 17:58:47 | 显示全部楼层
用友U8ERP软件免费下载地址截止2016年已发布的版本全部在下方,安装教程请认真参考:http://www.yyrjxz.com/xue/u8azjc.html 进行安装。
1、用友MERPu811软件免费下载地址:http://www.yyrjxz.com/yongyou/MERPU811.1.html
2、用友U82.0erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u8old820.html
3、用友U83.0erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u8old830.html
4、用友U852erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/U852.html
5、用友U860erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u860.html
6、用友U861erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u861xz.html
7、用友U870erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u870.html
8、用友U872erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u871.html
9、用友U82.0erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/U872.html
10、用友U890erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u890.html
11、用友U810.0erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/U810.0.html
12、用友U810.1erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/U8V10.1.html
13、用友U811.0erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/U8V11.0.html
14、用友U8+v11.1erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/U8V11.1.html
15、用友U8+v12.0erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u8120.html
16、用友U8+v12.1erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u8121.html
17、用友U8+v12.5erp软件免费下载地址:http://www.yyrjxz.com/yongyouu8/u8125.html
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|用友十万个为什么 ( 赣ICP备13006939号 )

GMT+8, 2025-6-18 02:30 , Processed in 0.075962 second(s), 20 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表