NC6 报销单显示凭证号吴雅萍 wuyp@yonyou.com1 引言之前写过一篇案例,关于如何区分应收应付的单据是否生成凭证的,案例名称是:《NC6 应收应付如何区分单据是否已生成凭证》,现在报销单也有这个需求。2 应用场景及问题描述之前写过一篇案例,关于如何区分应收应付的单据是否生成凭证的,案例名称是:《NC6 应收应付如何区分单据是否已生成凭证》,现在报销单也有这个需求。3 解决方案应收应付显示凭证号的公式如下应收单: getcolvalue("gl_voucher","num","pk_voucher",getcolvalue2("fip_relation","des_relationid","src_relationid", pk_gatherbill,"des_billtype","C0"))收款单: getcolvalue("gl_voucher","num","pk_voucher",getcolvalue2("fip_relation","des_relationid","src_relationid",pk_recbill,"des_billtype","C0"))应付单:getcolvalue("gl_voucher","num","pk_voucher",getcolvalue2("fip_relation","des_relationid","src_relationid",pk_payablebill,"des_billtype","C0"))付款单:getcolvalue("gl_voucher","num","pk_voucher",getcolvalue2("fip_relation","des_relationid","src_relationid",pk_paybill,"des_billtype","C0"))对于报销单,修改公式为:getcolvalue("gl_voucher","num","pk_voucher",getcolvalue2("fip_relation","des_relationid","src_relationid",pk_jkbx+"_1","des_billtype","C0"))效果如下:单据卡片显示:列表显示:4 注意事项