1/6用友股份-LE支持服务业务本部产品方案--《关于打印模板中个性化设置打印金额》建立日期：2013-08-01修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-CP-2013-06492/6文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围内部员工伙伴客户发布人姓名所属部门发布时间日期作者所属部门邮件地址版本2013-08-01张晨产品支持部V1.0版本领域模块备注3/6目录关于打印模板中个性化设置打印金额....................................................................4一、需求描述：........................................................................................................4二、方案说明：........................................................................................................44/6关于打印模板中个性化设置打印金额一、需求描述：请问销售订单打印模板配置中，对于价税合计金额，类似这样的数字，可否有函数，配置成元角分，将单个数字分开打印。截图如下。二、方案说明：如下公式已指定要打印的金额为123456.78，实际应用中可以将其改为要打印的变量即可。各个金额位的自定义变量设置如下：分位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")+3))*100-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")+2))*100角位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")+2))*10-5/6tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")))*10个位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-1))*10十位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-1))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-2))*10百位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-2))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-3))*10千位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-3))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-4))*106/6万位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-4))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-5))*10十万位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-5))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-6))*10百万位：tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-6))-tonumber(left(tostring(123456.78),indexof(tostring(123456.78),".")-7))*10这样就通过以上方式设置自定义变量并应用到模板中，成功了解决了这一问题。
