问题现象: | 批量发货签回时,不能进行批量签回完成操作,在批量签回列表没有操作按钮进行批量操作。 |
问题原因: | |
解决方案: | 您好, 您的问题经提交需求/开发人员讨论,现需求/开发最终答复如下: 用户自己增加过滤条件,数据源fpurquan 在data库执行以下脚本 if exists(select name from sysobjects where name='sale_RefSOVouch_B' and xtype='V') drop view sale_RefSOVouch_B go CREATE VIEW sale_RefSOVouch_B as select N'' as selcol,so_sodetails.id,so_sodetails.autoid, so_sodetails.csocode, so_sodetails.cinvcode, inventory.bservice, inventory.cinvname, inventory.cinvstd,inventory.cinvaddcode,so_sodetails.fsalecost,so_sodetails.fsaleprice,isnull(FPurQuan,0) as fpurquan, inventory.iinvweight,inventory.cinvdefine1, inventory.cinvdefine2, inventory.cinvdefine3,inventory.igrouptype,inventory.cgroupcode, so_sodetails.iquantity, so_sodetails.inum, so_sodetails.iquotedprice, so_sodetails.iunitprice, so_sodetails.imoney, so_sodetails.itax, so_sodetails.isum, so_sodetails.inatunitprice, so_sodetails.inatmoney, so_sodetails.inattax, so_sodetails.inatsum, so_sodetails.inatdiscount, so_sodetails.idiscount, so_sodetails.ifhquantity, (case when isnull(inventory.igrouptype,0)=0 then null when inventory.igrouptype=1 then so_sodetails.ifhquantity/so_sodetails.iinvexchrate else so_sodetails.ifhnum end ) as ifhnum, so_sodetails.ifhmoney, so_sodetails.ikpquantity, (case when isnull(inventory.igrouptype,0)=0 then null when inventory.igrouptype=1 then so_sodetails.ikpquantity/so_sodetails.iinvexchrate else so_sodetails.ikpnum end ) as ikpnum, so_sodetails.ikpmoney, convert(varchar(10),so_sodetails.dpredate,121) as dpredate,convert(varchar(10),so_sodetails.dpremodate,121) as dpremodate, so_sodetails.cmemo, so_sodetails.cfree1, so_sodetails.cfree2, case when igrouptype=1 then ISNULL(Unit2.iChangRate,0) else so_sodetails.iinvexchrate end as iinvexchrate, so_sodetails.itaxunitprice, inventory.bfree1, inventory.bfree2, inventory.binvtype, so_sodetails.itaxrate, so_sodetails.kl, so_sodetails.kl2, so_sodetails.cdefine22, so_sodetails.cdefine23, so_sodetails.cdefine24, so_sodetails.cdefine25, so_sodetails.cdefine26, so_sodetails.cdefine27, so_sodetails.isosid , so_sodetails.citemcode, so_sodetails.citem_class,so_sodetails.citemname,so_sodetails.citem_cname, so_sodetails.cfree3, so_sodetails.cfree4, so_sodetails.cfree5, so_sodetails.cfree6, so_sodetails.cfree7, so_sodetails.cfree8, so_sodetails.cfree9, so_sodetails.cfree10, so_sodetails.cunitid, so_sodetails.cdefine28, so_sodetails.cdefine29,bfree3,bfree4,bfree5,bfree6,bfree7,bfree8,bfree9,bfree10, bsalepricefree1,bsalepricefree2,bsalepricefree3,bsalepricefree4,bsalepricefree5,bsalepricefree6,bsalepricefree7,bsalepricefree8,bsalepricefree9,bsalepricefree10, so_sodetails.cdefine30, so_sodetails.cdefine31, so_sodetails.cdefine32,so_sodetails.cdefine33, so_sodetails.cdefine34, so_sodetails.cdefine35, convert(varchar(10),so_sodetails.cdefine36,121) as cdefine36, convert(varchar(10),so_sodetails.cdefine37,121) as cdefine37,case when inventory.bpropertycheck=0 then N'否' else N'是' end as bgsp,vendor.cvenabbname, inventory.cinvdefine4, inventory.cinvdefine5, inventory.cinvdefine6, inventory.cinvdefine7, inventory.cinvdefine8,inventory.cinvdefine9, inventory.cinvdefine10, inventory.cinvdefine11, inventory.cinvdefine12, inventory.cinvdefine13, inventory.cinvdefine14,convert(varchar(10),inventory.cinvdefine15,121) as cinvdefine15, convert(varchar(10),inventory.cinvdefine16,121) as cinvdefine16, inventory.binvbatch , inventory.iinvlscost as iinvlscost,inventory.iinvsalecost as iinvsalecost, inventory.ccomunitcode, convert(char,convert(money,so_somain.ufts),2) as corufts, imassdate, binvquality,btrack,inventory.cdefwarehouse as cwhcode ,cwhname,case when isnull(bproxywh,0)=1 then 1 else 0 end as bproxywh,case inventory.cmassunit when N'0' then N'' when N'1' then N'年' when N'2' then N'月' when N'3' then N'日' end as cmassunit, so_sodetails.ccontractid,so_sodetails.ccontracttagcode,so_sodetails.ccontractrowguid,ccusinvcode,ccusinvname,inventory.csrpolicy,cscloser,imoquantity,unit1.ccomunitname as cinvm_unit, so_sodetails.csocode as cordercode,so_sodetails.irowno as iorderrowno,convert(varchar(10),so_sodetails.dreleasedate,121) as dreleasedate,so_sodetails.iprekeepquantity,so_sodetails.iprekeepnum,so_sodetails.iprekeeptotquantity,so_sodetails.iprekeeptotnum,so_sodetails.fcusminprice ,inventory.iid as Iiid,case when isnull(inventory.igrouptype,0)=0 then null else unit2.ccomunitname end as cinva_unit,100-so_sodetails.kl as dkl1,100-so_sodetails.kl2 as dkl2,case when isnull(bserial,0)=1 then 1 else 0 end as bserial ,irowno,cquocode,icusbomid,'正常' as itb,idemandtype,case isnull(idemandtype,0) when 4 then cdemandcode when 0 then N'' else so_sodetails.csocode end as cdemandcode,case when isnull(idemandtype,0)=4 then cdemandmemo else N'' end as cdemandmemo,vendor.cvencode, case isnull(idemandtype,0) when 4 then cdemandcode when 1 then cast(isosid as nvarchar(40)) when 5 then so_sodetails.csocode else N'' end as cdemandid,case when isnull(idemandtype,0)=1 then so_sodetails.irowno else null end as idemandseq,iexpiratdatecalcu from so_sodetails inner join so_somain on so_sodetails.id=so_somain.id left join inventory with (nolock) on so_sodetails.cinvcode = inventory.cinvcode left outer join vendor with (nolock) on inventory.cvencode = vendor.cvencode left join warehouse on inventory.cdefwarehouse=warehouse.cwhcode left join computationunit as unit1 on inventory.ccomunitcode=unit1.ccomunitcode left join ComputationUnit as Unit2 on so_sodetails.cunitid=Unit2.cComUnitCode left join inventory_sub on inventory_sub.cinvsubcode= so_sodetails.cinvcode go 给您工作带来不便之处,我们表示歉意,敬请谅解和支持。【同时请您关注新版本的发版说明】 |
相关补丁: | |
版本: | 8.90 |
模块: | 销售管理 |
产品: | 供应链 |
问题名称: | 批量发货签回时,不能进行批量签回完成操作 |
最后更新: | 2011-08-29 23:24:42 |