【YOU学吧】应对复杂报销场景难题，你应掌握这个高阶技巧！--第71期--关于报销标准，各企事业单位存在多种方式。针对部分复杂的无法通过报销标准配置实现的报销场景，我们该如何应对呢？本期【YOU学吧】NC财务领域资深专家通过一个复杂的、典型的企业报销案例为你解惑。业务场景1、差旅补助标准报销类型(zyx9)分为四种：一、出公差，二、进修，三、学术会议，四、培训；当报销类型等于出公差时，补贴标准为第一种情况，每种报销类型情况里面，又分为1.市内，2.市外省内，3.省外，4.西藏、青海、新疆，四种地区。根据报销类型和地区不同，选择报销类型和地区后自动出来差旅补助标准。出公差：defitem47->iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120"));defitem1->iif(defitem7=="市内","30",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","80","50"));defitem4->iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120"))进修：defitem47->iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120"));defitem1->iif(defitem7=="市内","0",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","0","0"));defitem4->iif(defitem7=="市内","10",iif(defitem7=="市外省内"||defitem7=="省外","10","10"))学术会议：defitem47->iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120"));defitem1->iif(defitem7=="市内","20",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","20","20"));defitem4->iif(defitem7=="市内","10",iif(defitem7=="市外省内"||defitem7=="省外","10","10"))培训：defitem47->iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120"));defitem1->iif(defitem7=="市内","20",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","20","20"));defitem4->iif(defitem7=="市内","10",iif(defitem7=="市外省内"||defitem7=="省外","10","10"))我们分单条把公式都写出来了，困难的是如何把公式连在一起，自动出来差旅补助标准。2、差旅住宿标准出公差：defitem3->iif(defitem1=="副高级","350",iif(defitem1=="正高级","420",iif(defitem2=="普通地区","240",iif(defitem2=="广东","340","350"))))进修：defitem3->iif(defitem1=="副高级","50",iif(defitem1=="正高级","50",iif(defitem2=="普通地区","50",iif(defitem2=="广东","50","50"))))学术会议：defitem3->iif(defitem1=="副高级","350",iif(defitem1=="正高级","420",iif(defitem2=="普通地区","240",iif(defitem2=="广东","340","350"))))培训：defitem3->iif(defitem1=="副高级","350",iif(defitem1=="正高级","420",iif(defitem2=="普通地区","240",iif(defitem2=="广东","340","350"))))如何将以上公式连起来实现：当报销类型等于出公差时（报销类型(zyx9)分为四种：一、出公差，二、进修，三、学术会议，四、培训），住宿补贴标准是第一种情况，以此类推。当选择报销类，职级，地区类型后，自动出来住宿标准。解决方案经过分析，本身此类带出标准金额是可以通过报销标准配置实现，但是由于需求比较特殊，同一条件，要带出多个字段不同的标准，这个就无法通过报销标准实现了，因为内容不是互斥的，报销标准无法在同一条件下带出多个字段多个金额标准；所以，编辑公式实现，公式见下文。1、差旅补助标准defitem47->iif(defitem50=="出公差",iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120")),iif(defitem50=="进修",iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120")),iif(defitem50=="学术会议",iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120")),iif(defitem50=="培训",iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120")),"0"))));defitem1->iif(defitem50=="出公差",iif(defitem7=="市内","30",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","80","50")),iif(defitem50=="进修",iif(defitem7=="市内","0",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","0","0")),iif(defitem50=="学术会议",iif(defitem7=="市内","20",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","20","20")),iif(defitem50=="培训",iif(defitem7=="市内","20",iif(defitem7=="西藏、青海、新疆"||defitem7=="省外","20","20")),"0"))));defitem4->iif(defitem50=="出公差",iif(defitem7=="市内","80",iif(defitem7=="市外省内"||defitem7=="省外","100","120")),iif(defitem50=="进修",iif(defitem7=="市内","10",iif(defitem7=="市外省内"||defitem7=="省外","10","10")),iif(defitem50=="学术会议",iif(defitem7=="市内","10",iif(defitem7=="市外省内"||defitem7=="省外","10","10")),iif(defitem50=="培训",iif(defitem7=="市内","10",iif(defitem7=="市外省内"||defitem7=="省外","10","10")),"0"))));2、差旅住宿标准defitem3->iif(defitem50=="出公差",iif(defitem1=="副高级","350",iif(defitem1=="正高级","420",iif(defitem2=="普通地区","240",iif(defitem2=="广东","340","350")))),iif(defitem50=="进修",iif(defitem1=="副高级","50",iif(defitem1=="正高级","50",iif(defitem2=="普通地区","50",iif(defitem2=="广东","50","50")))),iif(defitem50=="学术会议",iif(defitem1=="副高级","350",iif(defitem1=="正高级","420",iif(defitem2=="普通地区","240",iif(defitem2=="广东","340","350")))),iif(defitem50=="培训",iif(defitem1=="副高级","350",iif(defitem1=="正高级","420",iif(defitem2=="普通地区","240",iif(defitem2=="广东","340","350")))),"0"))));注意事项本文通过了一段不太长的公式，实现了企业的实际业务控制，显然是合理的；如果公式实在特别复杂：例如有的项目上，公式1000个字符都不够，需要2000个字符，笔者认为就得不偿失了，会给企业留下一个难于理解，难于运维的环境。进入服务社区（http：//ism.yonyou.com）搜索“报销”了解更多内容！【本文作者】NC财务领域“头牌”王宏【往期精华】【专栏】YOU学吧：3分钟get一个NC新技能！（知识汇总帖）【精华】【YOU学吧】第01期——税率调整，用友NC6产品应对方案轻松get！【精华】【YOU学吧】第02期——税率调整，用友NC5产品应对方案轻松get！【精华】【YOU学吧】第03期——学会这一招，NC6产品敏感数据权限控制都搞定！【精华】【YOU学吧】第05期——支招：NC6如何设定物料采购和销售不同税率【精华】【YOU学吧】第06期——NC资金贷款担保集成应用方案轻松学【精华】【YOU学吧】第07期——实用！NC单据按个性化要求入账的正确姿势【精华】【YOU学吧】第11期——有了它，再也不用担心NC6组织权限设置出错！【精华】【YOU学吧】第12期——精通语义模型，轻松搞定NC报表取数！【精华】【YOU学吧】第15期——财务报表格式再次变化，NC6产品应对方案出炉！【精华】【YOU学吧】第23期——新个税法来了！NC最新个税调整方案助你轻松应对【精华】【YOU学吧】第46期——增值税税率下调，NC6适配方案新鲜出炉【YOU学吧】3分钟get一个NC新技能！相约用友服务社区，每周为你献上知识盛宴。
