b、大包装数量合计：if(sum(if(dec(db_data2(~"SELECT count(*) FROM t_item_unit WHERE item_no=?~",item_no))>1   , int(『数量小计』/dec(db_data2(~"SELECT isnull(item_pack,0) FROM t_item_unit WHERE item_no=? AND unit_type=1~",item_no))),0))>0,string(sum(if(dec(db_data2(~"SELECT count(*) FROM t_item_unit WHERE item_no=?~",item_no))>1   , int(『数量小计』/dec(db_data2(~"SELECT isnull(item_pack,0) FROM t_item_unit WHERE item_no=? AND unit_type=1~",item_no))),0)))+~"件~",~"~")

档案中添加现有机构默认的库存数量：
gf_item_stock_qty(item_no,db_data2('SELECT param_data FROM t_sys_param WHERE param_id=?','gs_defa_branch'),'1')

标签中添加打印失效日期（在现有系统时间上加上档案中的有效日期）：
db_data2(~"SELECT CONVERT(varchar(100), dateadd(dd,item_valid_day,getdate()), 23) FROM t_item_info WHERE item_No=?~",item_No)

小票上当实价为0的时候，打印赠送两个字：
if(string(real_price)='0','赠送',string(real_price,'0.00'))

批发单中添加客户上次退货时间和金额以及客户最近一次结算日期跟金额：
上次退货时间和金额：
db_data4(~"select top 1  convert(varchar(100),oper_date,23)+?+cast(sheet_amt-order_amt-paid_amt-free_amt as varchar(12)) from t_cust_accout_flow  where trans_no=? and cust_no =? order by 『单据编号』 desc~",~"退货~",~"RI~",db_data2(~"select cust_no from t_cust_accout_flow where sheet_no=?~",sheet_no))