解决方案: |
问题分析及测试过程: 1、在销售订单中,进行PTO选配,选择存货编码为0304进行选配,生成销售订单,并保存; 2、通过后台跟踪发现,ICUSBOMID(客户BOMID)字段与ippartid(母件物料ID)字段在so_sodetails表中的值分别为:‘NULL’和 4 跟踪语句如下: Insert Into SO_SODetails(csocode,cinvcode,dpredate,iquantity,inum,iquotedprice,iunitprice,itaxunitprice,imoney,itax,isum,idiscount,inatunitprice,inatmoney,inattax,inatsum,inatdiscount,ifhnum,ifhquantity,ifhmoney,ikpquantity,ikpnum,ikpmoney,cmemo,cfree1,cfree2,isosid,kl,kl2,cinvname,itaxrate,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,citemcode,citem_class,citemname,citem_cname,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10,iinvexchrate,cunitid,id,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,fpurquan,fsalecost,fsaleprice,cquocode,iquoid,cscloser,dpremodate,irowno,icusbomid,imoquantity,ccontractid,ccontracttagcode,ccontractrowguid,ippartseqid,ippartid,ippartqty,ccusinvcode,ccusinvname,iprekeepquantity,iprekeepnum,iprekeeptotquantity,iprekeeptotnum) Values (N'0000000028',N'010210','2005-11-21',1,1,85,72.65,85,72.65,12.35,85,0,72.65,72.65,12.35,85,0,Null,Null,Null,Null,Null,Null,Null,Null,Null,120,100,100,N'耳机',17,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,1,N'0501',52,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,100,100,Null,Null,Null,'2005-11-21',2,Null,Null,Null,Null,Null,15450015,4,1,Null,Null,Null,Null,Null,Null) 3、因为PTO件经过销售订单选配后,会直接按照子件出库,并不会下达生产。因此,所生成的销售订单并不会生成[客户BOMID]号(数据库中为‘NULL’值),而[母件物料ID]却能自动带出。 测试环境: WIN2000SERVER+系统补丁、SQL2000+SP3、IE6.0+SP1、IIS、网站上最新的U860SP1HOTFIX+U860DBHOTFIX+销售模块补丁包。 |