用友-知识库

UFPMP

  • 问题描述:用户环境:u861预算管理,已经打好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个字符。
  • 解决方案:游客无权查看
  • 相关补丁:
  • 模块:预算管理
  • 产品:U861--管理会计--预算管理
  • 问题名称:UFPMP
  • 更新时间:2006-12-20 00:00:00
  • 有用 没用67 浏览