退货原因的修改

销售退货原因直接在字典中维护

select dictlist as thyy,:mx.dj as dj  from gldict where fdname=‘thyy‘

采购退货原因采购资料检索方案

select ‘包装问题‘ as thyy,:mx.dj as dj

union all

select ‘药品信息不符‘ as thyy,:mx.dj as dj

union all

select ‘付款方式不符‘ as thyy,:mx.dj as dj

union all

select ‘电子监管问题‘ as thyy,:mx.dj as dj

union all

select ‘药品召回‘ as thyy,:mx.dj as dj

union all

select ‘抽检‘ as thyy,:mx.dj as dj

union all

select ‘质量问题‘ as thyy,:mx.dj as dj

union all

select ‘价格不适‘ as thyy,:mx.dj as dj

union all

select ‘入错单位‘ as thyy,:mx.dj as dj

union all

select ‘近效期‘ as thyy,:mx.dj as dj

union all

select ‘资质问题‘ as thyy,:mx.dj as dj

union all

select ‘票据问题‘ as thyy,:mx.dj as dj

union all

select ‘订单问题‘ as thyy,:mx.dj as dj

union all

select ‘多入‘ as thyy,:mx.dj as dj

物流中要将退货原因维护才能正常

select * from openquery(lmis,‘select * from jc_zdwh_mx‘) where english_name=‘tuih_reason‘

退货原因的修改

原文：http://bks2015.blog.51cto.com/9847303/1701854