用友CDM货位间商品移库（一步）增加冲红功能

本文主要是介绍用友CDM货位间商品移库（一步）增加冲红功能，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

1.新增业务单据提取方案，在业务单据货位间商品移库（一步），单据菜单功能。

2.单据选择sql

select kaiprq,djbh,(select huowname from huoweizl b where a.dchw=b.hw) as dchwname,
(select huowname from huoweizl b where a.drhw=b.hw) as drhwname,bm,ywy
from dbhz a order by  kaiprq DESC

单据抬头sql

select kaiprq,djbh,(select huowname from huoweizl b where a.dchw=b.hw) as dchwname,(select hw from huoweizl b where a.dchw=b.hw) as dchw,
(select huowname from huoweizl b where a.drhw=b.hw) as drhwname,(select hw from huoweizl b where a.drhw=b.hw) as drhw,bm,ywy
from dbhz a
where a.djbh=:djbh

单据明细sql

select djbh,dj_sn,a.spid,recnum,dj_sort,xgdjbh,a.dw,pihao,a.jlgg,-shl as shl,-baozhshl as baozhshl,lingsshl,chbdj,dbdj,-dbje as dbje,ml,miejph,a.baozhiqi,drhw,dchw,sxrq,a.lshj,lshe,a.beizhu,b.* from dbmx a,spkfk b where a.spid=b.spid and a.djbh=:djbh

 

这篇关于用友CDM货位间商品移库（一步）增加冲红功能的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---