U8C服务小锦囊--总账--总账三栏式明细账显示辅助核算信息——U8C实施与服务支持部闫静业务场景：想要在查询打印三栏式明细账数据时，将对应辅助核算信息也一起显示出来，现提供以下方案可参考。解决方案：一、在三栏式明细账打印模板中，添加以下自定义变量取辅助信息1.以客商信息为例：客商信息：iif(getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"73"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))=null,"","【客商辅助核算："+getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"73"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))+"】")2.如果想要打印其他辅助项档案，只需要将自定义公式中的档案编码换为辅助档案对应的编码即可，例如打印人员档案，将编码替换1即可，如下；iif(getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"73"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))=null,"","【客商辅助核算："+getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"73"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))+"】")替换为：iif(getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"1"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))=null,"","【人员档案："+getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"1"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))+"】")辅助档案对应的编码，可在会计科目节点查看，如下：3.如果想要体现辅助项的编码信息，把自定义公式修改为以下形式即可，将公式中的valuename改为valuecode，如下：iif(getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"1"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))=null,"","【人员档案："+getcolvalue2(gl_freevalue,valuename,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"73"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))+"】")替换为：iif(getcolvalue2(gl_freevalue,valuecode,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"1"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))=null,"","【人员档案："+getcolvalue2(gl_freevalue,valuecode,checktype,getColValue(bd_bdinfo,pk_bdinfo,bdcode,"73"),freevalueid,getColValue(gl_detail,assid,pk_detail,pkdetail))+"】")4.打印三栏式明细账需要设置辅助项输入设置节点下所有辅助的自定义公式根据辅助对应编码设置公式：如下：二、把设置好的自定义变量拖拽到打印模板中三、打印输出效果展示分配模板后，打印输出选择此模板：联系方式：本文档未尽事宜可邮件联系：yanjing17@yonyou.com
