最近Modify了BaaN里面的Open Purchase Order,使用了N久的报表发现了Bug,对于那种在物料接收Receipt的时候,没有把“Final Receipt”选项打勾的并且接收的PO Line的数量不是订单数量时,先前的报表不能够打印出这种类型的Open Purchase Order List。
主程序修改如下:
<br/> select tdpur401.orno, tdpur401.pono, tdpur401.sqnb, <br/> tdpur401.lseq,tdpur401.rcno, tdpur401.oltp,<br/> tdpur401.ddte,tdpur401.bqua<br/> from tdpur401<br/> where tdpur401.clyn = tcyesno.no<br/>| and tdpur401.ddte = 0<br/> and (tdpur401.dqua = 0 or tdpur401.bqua > 0)<br/> and tdpur401.lseq = 0<br/>| and tdpur401.rcno = ""<br/> and (tdpur401.rcno = "" or tdpur401.bqua <> 0)<br/> and (tdpur401.oltp = tdgen.oltp.detail or<br/> tdpur401.oltp = tdgen.oltp.backorder)<br/>
版权所有,转载请注明出处:[URL=http://www.cuiwenyuan.com/baan]http://www.cuiwenyuan.com/baan/[/URL],本文同时发在[URL=http://www.xihome.com]西山之家[/URL]