问题现象:在用友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个字符。
|