|
|
问题现象：在用友8.52erp系统中用友U8版本号：U8.52软件的供应链产品线销售管理模块出现如下问题：销售普通发票显示不正常，没有表头记录。请帮忙解答！
原因分析：显示销售发票的视图有错，并且数据被损坏。
解决方案：在用友erp 系统版本U8.52软件中执行以下语句修改：useufdata_001_2005godropviewsalebillvouchztgoCREATEVIEWSaleBillVouchZTASselectivtid,convert(char,convert(money,salebillvouch.ufts),2)asufts,csource,ccrechpname,cinfotypecode,salebillvouch.cstcode,salebillvouch.crdcode,salebillvouch.cdepcode,salebillvouch.ccuscode,salebillvouch.cpaycode,saletype.cstname,customer.ccusabbname,customer.ccusaddress,customer.ccusphone,customer.ccusfax,customer.ccusbank,customer.ccusaccount,customer.ccusperson,customer.ccusoaddress,customer.ccuspaycond,salebillvouch.cpersoncode,customer.ccusotype,salebillvouch.sbvid,salebillvouch.csbvcode,salebillvouch.cvouchtype,salebillvouch.ddate,salebillvouch.csocode,salebillvouch.cdefine1,salebillvouch.cdefine2,salebillvouch.cdefine3,salebillvouch.cmaker,salebillvouch.cverifier,department.cdepname,person.cpersonname,salebillvouch.iexchrate,salebillvouch.itaxrate,salebillvouch.cbillver,salebillvouch.cmemo,paycondition.cpayname,salebillvouch.breturnflag,salebillvouch.bfirst,salebillvouch.cbustype,salebillvouch.cbcode,salebillvouch.cexch_name,salebillvouch.cinvalider,bank.cbname,bank.cbaccount,customer.ccusregcode,customer.icuscreline,customer.iarmoney,salebillvouch.cdefine4,salebillvouch.cdefine5,salebillvouch.cdefine6,salebillvouch.cdefine7,salebillvouch.cdefine8,salebillvouch.cdefine9,salebillvouch.cdefine10,salebillvouch.cdefine11,salebillvouch.cdefine12,salebillvouch.cdefine13,salebillvouch.cdefine14,salebillvouch.cdefine15,salebillvouch.cdefine16,salebillvouch.citem_class,salebillvouch.citemcode,salebillvouch.ccusname,salebillvouch.idisp,salebillvouch.cdlcode,salebillvouch.caccounter,salebillvouch.cchecker,salebillvouch.bpayment,customer.ccusdefine1,customer.ccusdefine2,customer.ccusdefine3,customer.ccusdefine4,customer.ccusdefine5,customer.ccusdefine6,customer.ccusdefine7,customer.ccusdefine8,customer.ccusdefine9,customer.ccusdefine10,customer.ccusdefine11,customer.ccusdefine12,customer.ccusdefine13,customer.ccusdefine14,customer.ccusdefine15,customer.ccusdefine16,customer.iidascauthid,salebillvouch.csccode,shippingchoice.cscname,salebillvouch.cshipaddressFROMSaleBillVouchLEFTOUTERJOINBankONSaleBillVouch.cBCode=Bank.cBCodeLEFTOUTERJOINCustomerONSaleBillVouch.cCusCode=Customer.cCusCodeLEFTOUTERJOINDepartmentONSaleBillVouch.cDepCode=Department.cDepCodeLEFTOUTERJOINPayConditionONSaleBillVouch.cPayCode=PayCondition.cPayCodeLEFTOUTERJOINPersonONSaleBillVouch.cPersonCode=Person.cPersonCodeLEFTOUTERJOINSaleTypeONSaleBillVouch.cSTCode=SaleType.cSTCodeleftjoinShippingChoiceonsalebillvouch.csccode=ShippingChoice.csccodewherecSource='销售'anddDate>=(selectcvaluefromaccinformationwherecsysid='SA'andcName='dStartDate')godropviewsalebillvouchzwgoCREATEVIEWSaleBillVouchZWASselectwarehouse.cwhname,salebillvouchs.cinvcode,inventory.cinvname,cinvaddcode,salebillvouchs.cwhcode,salebillvouchs.cfree1,salebillvouchs.cfree2,salebillvouchs.cfree3,salebillvouchs.cfree4,salebillvouchs.cfree5,salebillvouchs.cfree6,salebillvouchs.cfree7,salebillvouchs.cfree8,salebillvouchs.cfree9,salebillvouchs.cfree10,inventory.cinvstd,salebillvouchs.cunitid,unit1.ccomunitnameascinvm_unit,inventory.igrouptype,inventory.cgroupcode,casewhenisnull(inventory.igrouptype,0)=0thennullelseunit2.ccomunitnameendascinva_unit,(casewhenisnull(salebillvouchs.itb,0)=1thensalebillvouchs.tbnumelse(casewhenigrouptype=0thennullelsesalebillvouchs.inumend)end)asinum,inventory.bservice,(casewhenisnull(salebillvouchs.itb,0)=1thensalebillvouchs.tbquantityelsesalebillvouchs.iquantityend)asiquantity,salebillvouchs.iunitprice,salebillvouchs.imoney,salebillvouchs.itax,salebillvouchs.isum,salebillvouchs.idiscount,salebillvouchs.isbvid,salebillvouchs.sbvid,salebillvouchs.iquotedprice,salebillvouchs.ibatch,salebillvouchs.autoid,salebillvouchs.inatunitprice,salebillvouchs.inatmoney,salebillvouchs.inattax,salebillvouchs.inatsum,salebillvouchs.inatdiscount,salebillvouchs.imoneysum,salebillvouchs.iexchsum,salebillvouchs.cclue,salebillvouchs.iinvexchrate,inventory.iinvlscost,salebillvouchs.itaxunitprice,salebillvouchs.bsettleall,salebillvouchs.cbatch,inventory.binvbatch,warehouse.cwhvaluestyle,inventory.bfree1,inventory.bfree2,inventory.cinvdefine1,inventory.cinvdefine2,inventory.cinvdefine3,inventory.cinvdefine4,inventory.cinvdefine5,inventory.cinvdefine6,inventory.cinvdefine7,inventory.cinvdefine8,inventory.cinvdefine9,inventory.cinvdefine10,inventory.cinvdefine11,inventory.cinvdefine12,inventory.cinvdefine13,inventory.cinvdefine14,inventory.cinvdefine15,inventory.cinvdefine16,salebillvouchs.kl,salebillvouchs.kl2,inventory.binvtype,(casewhensalebillvouchs.itb=0then'正常'else'退补'end)asitb,salebillvouchs.imassdateasimassdate,inventory.binvquality,salebillvouchs.dvdate,salebillvouchs.dmdate,casesalebillvouchs.cmassunitwhen'0'then''when'1'then'年'when'2'then'月'when'3'then'日'endascmassunit,salebillvouchs.itaxrate,salebillvouchs.cdefine22,salebillvouchs.cdefine23,salebillvouchs.cdefine24,salebillvouchs.cdefine25,salebillvouchs.cdefine26,salebillvouchs.cdefine27,salebillvouchs.cdefine28,salebillvouchs.cdefine29,salebillvouchs.cdefine30,salebillvouchs.cdefine31,salebillvouchs.cdefine32,salebillvouchs.cdefine33,salebillvouchs.cdefine34,salebillvouchs.cdefine35,salebillvouchs.cdefine36,salebillvouchs.cdefine37,salebillvouchs.isosid,salebillvouchs.idlsid,salebillvouchs.citemcode,salebillvouchs.citem_class,salebillvouchs.csocode,100-salebillvouchs.klasdkl1,100-salebillvouchs.kl2asdkl2,salebillvouchs.fsalecost,salebillvouchs.fsaleprice,inventory.cinvccode,salebillvouchs.citemname,salebillvouchs.citem_cname,salebillvouchs.cmemo,ipbvsid,btrack,ccode,inventory.iidascinvauthid,cincomesub,(casewhenisnull(salebillvouchs.bgsp,0)=1then'是'else'否'end)asbgsp,inventory.ccomunitcode,salebillvouchs.ippartseqid,salebillvouchs.ippartid,salebillvouchs.ippartqty,inventory.cbarcode,salebillvouchs.ccontractid,salebillvouchs.ccontracttagcode,salebillvouchs.ccontractrowguid,casewhenisnull(inventory.batomodel,0)=0then'否'else'是'endasbatomodel,casewhenisnull(inventory.bptomodel,0)=0then'否'else'是'endasbptomodel,casewhenisnull(salebillvouchs.bQANeedCheck,0)=0then'否'else'是'endasbqaneedcheck,casewhenisnull(salebillvouchs.bQAUrgency,0)=0then'否'else'是'endasbqaurgency,salebillvouchs.ccusinvcode,salebillvouchs.ccusinvnameFROMSaleBillVouchsLEFTJOINWarehouseONSaleBillVouchs.cWhCode=Warehouse.cWhCodeLEFTJOINInventoryONSaleBillVouchs.cInvCode=Inventory.cInvCodeleftjoinComputationUnitasUnit1oninventory.cComUnitCode=Unit1.cComUnitCodeleftjoinComputationUnitasUnit2onsalebillvouchs.cunitid=Unit2.cComUnitCodegosp_dboption'ufdata_001_2005','singleuser','true'godbcccheckdb('ufdata_001_2005',REPAIR_ALLOW_DATA_LOSS)gosp_dboption'ufdata_001_2005','singleuser','false'。
|
|
|手机版|小黑屋|用友十万个为什么
( 赣ICP备13006939号 )
发表于 2016-9-25 16:04:48