打印模板设置一例nc产品支持部吴雅萍wuyp@ufida.com.cn客户需求：客户在系统中的很多客商名称后面都带有一位识别码，如"统一嘉吉L"。希望在打印凭证和单据的时候把客商名称的识别码提取出来并单独打印在单据右上角。如：客商名称统一嘉吉L打印客商时显示统一嘉吉打印识别码L分析：客户的系统中存在很多客商，一部分客商是带有识别码的，还有另一部分是不带识别码的，必须区分开来。因此可以使用IFF函数，通过endwith(,)函数来判断是否带有识别码，然后进行打印，具体设置如下：1.增加两个自定义变量：自定义变量111，用来打印科目及辅助核算，公式设计如下：voucher79&""&iif(endwith(voucher76,"A】")+endwith(voucher76,"B】")+endwith(voucher76,"C】")+endwith(voucher76,"D】")+endwith(voucher76,"E】")+endwith(voucher76,"F】")+endwith(voucher76,"G】")+endwith(voucher76,"H】")+endwith(voucher76,"I】")+endwith(voucher76,"J】")+endwith(voucher76,"K】")+endwith(voucher76,"L】")+endwith(voucher76,"M】")+endwith(voucher76,"N】")+endwith(voucher76,"O】")+endwith(voucher76,"P】")+endwith(voucher76,"Q】")+endwith(voucher76,"R】")+endwith(voucher76,"S】")+endwith(voucher76,"T】")+endwith(voucher76,"U】")+endwith(voucher76,"V】")+endwith(voucher76,"W】")+endwith(voucher76,"X】")+endwith(voucher76,"Y】")+endwith(voucher76,"Z】")>0,left(voucher76,length(voucher76)-2)+"】",voucher76)自定义变量222，用来提取客商的标识符，公式设计如下：iif(endwith(voucher76,"A】")+endwith(voucher76,"B】")+endwith(voucher76,"C】")+endwith(voucher76,"D】")+endwith(voucher76,"E】")+endwith(voucher76,"F】")+endwith(voucher76,"G】")+endwith(voucher76,"H】")+endwith(voucher76,"I】")+endwith(voucher76,"J】")+endwith(voucher76,"K】")+endwith(voucher76,"L】")+endwith(voucher76,"M】")+endwith(voucher76,"N】")+endwith(voucher76,"O】")+endwith(voucher76,"P】")+endwith(voucher76,"Q】")+endwith(voucher76,"R】")+endwith(voucher76,"S】")+endwith(voucher76,"T】")+endwith(voucher76,"U】")+endwith(voucher76,"V】")+endwith(voucher76,"W】")+endwith(voucher76,"X】")+endwith(voucher76,"Y】")+endwith(voucher76,"Z】")>0,left(right(voucher76,2),1),null)2.打印模板设计为了方便显示，把变量222放在“摘要”上。3.凭证打印凭证如下：其中客商：上海医药不带标识符，统一嘉吉带标识符打印效果：满足客户的需求。单据上的公式跟凭证上类似这么设计公式有个前提：客户其他用于辅助核算的档案中没有以英文大写字母结果的档案。
