应收单据不能录入-用友U8

对应版本:用友U其他对应产品线：财务系统对应模块：应收模块问题现象:应收单据不能录入问题原因：因为数据库中的两个视图有错误。解决方案：可以把正确的视图复制过来，重新创建，具体的脚本如附件。dropviewAp_SalBillCustgocreateviewAp_SalBillCustasSELECTCustomer.cCCCodeAScDWCCode,CustomerClass.cCCNameascDWCName,Customer.cDCCodeAScDWDCode,DistrictClass.cDCName,CASEWHENCustomer.cCusName‘‘THENCustomer.cCusNameELSECustomer.cCusAbbNameENDAScDWName,Customer.cCusPPersonAScHPsnCode,Person_1.cPersonNameascHPersonName,Customer.cCusDepartAScHDptCode,Department_1.cDepNameascHDepName,Customer.cCusHeadCodeAScHDWCode,CASEWHENCustomer_1.cCusName‘‘THENCustomer_1.cCusNameELSECustomer_1.cCusAbbNameENDAScHDwName,Customer.iCusCreLineASiCreLine,Department.cDepName,Person.cPersonName,Inventory.cInvName,Inventory.cInvCCode,InventoryClass.cInvCName,Ap_VouchType.cTypeName,dDate+IsNull(PayCondition.iPayCreDays,0)ASdExpireDate,dDate+IsNull(PayCondition_1.iPayCreDays,0)ASdExpireDate_DW,dDate+IsNull(PayCondition.iPayFaDays,0)ASdFaDate,PayCondition.cPayName,SaleBillVouch.cCusCodeAScDWCode,SaleBillVouch.cDepCodeAScDeptCode,SaleBillVouch.cPersonCodeAScPerson,SaleBillVouch.cMemoAScDigest,SaleBillVouch.cInvaliderascInvalider,SaleBillVouch.cChecker,SaleBillVouch.dDateASdVouchDate,SaleBillVouch.cVouchType,SaleBillVouch.cSBVCodeAScVouchID,SaleBillVouch.cMaker,SaleBillVouch.cVerifierAScCheckMan,SaleBillVouch.cPayCode,SaleBillVouch.cexch_name,SaleBillVouch.iExchRate,SaleBillVouchs.cInvCode,SaleBillVouchs.iNatSumASiAmount,SaleBillVouchs.iSumASiAmount_f,SaleBillVouchs.iMoneySumASiFmount,SaleBillVouchs.iExchSumASiFmount_f,SaleBillVouchs.iQuantityASiAmount_s,SaleBillVouchs.iNatUnitPriceASiprice,SaleBillVouchs.iNatTaxASino_id,1-bReturnFlagasbd_c,bpayment,bFirst,cClueFROM((((((((((((SaleBillVouchLEFTJOINAp_VouchTypeONSaleBillVouch.cVouchType=Ap_VouchType.cTypeCode)LEFTJOINCustomerONSaleBillVouch.cCusCode=Customer.cCusCode)LEFTJOINDepartmentONSaleBillVouch.cDepCode=Department.cDepCode)LEFTJOINPersonONSaleBillVouch.cPersonCode=Person.cPersonCode)LEFTJOINPayConditionONSaleBillVouch.cPayCode=PayCondition.cPayCode)INNERJOIN(SaleBillVouchsLEFTJOINInventoryONSaleBillVouchs.cInvCode=Inventory.cInvCode)ONSaleBillVouch.SBVID=SaleBillVouchs.SBVID)LEFTJOINPayConditionASPayCondition_1ONCustomer.cCusPayCond=PayCondition_1.cPayCode)LEFTJOINCustomerClassONCustomer.cCCCode=CustomerClass.cCCCode)LEFTJOINCustomerasCustomer_1ONCustomer.cCusHeadCode=Customer_1.cCusCode)LEFTJOINDistrictClassONCustomer.cDCCode=DistrictClass.cDCCode)LEFTJOINDepartmentasDepartment_1ONCustomer.cCusDepart=Department_1.cDepCode)LEFTJOINPersonasPerson_1ONCustomer.cCusPPerson=Person_1.cPersonCode)LEFTJOINInventoryClassONInventory.cInvCCode=InventoryClass.cInvCCodeWherecCheckerIsNotNullAndisnull(cInvalider,‘‘)=‘‘godropviewAp_PurBillVendgoCREATEVIEWAp_PurBillVendasSELECTVendor.cVCCodeAScDWCCode,VendorClass.cVCNameascDWCName,Vendor.cDCCodeAScDWDCode,DistrictClass.cDCName,CaseWhenVendor.cVenName‘‘ThenVendor.cVenNameElseVendor.cVenAbbNameEndAScDWName,Vendor.cVenPPersonAScHPsnCode,Person_1.cPersonNameascHPersonName,Vendor.cVenDepartAScHDptCode,Department_1.cDepNameascHDepName,Vendor.cVenHeadCodeAScHDWCode,CASEWHENVendor_1.cVenName‘‘THENVendor_1.cVenNameELSEVendor_1.cVenAbbNameENDascHDWName,Vendor.iVenCreLineASiCreLine,Department.cDepName,Person.cPersonName,Inventory.cInvName,Inventory.cInvCCode,InventoryClass.cInvCName,dPBVDate+IsNull(PayCondition.iPayCreDays,0)ASdExpireDate,dPBVDate+IsNull(PayCondition_1.iPayCreDays,0)ASdExpireDate_DW,dPBVDate+IsNull(PayCondition.iPayFaDays,0)ASdFaDate,Ap_VouchType.cTypeName,PayCondition.cPayName,PurBillVouch.cUnitCodeAScDWCode,PurBillVouch.cDepCodeAScDeptCode,PurBillVouch.cPersonCodeAScPerson,PurBillVouch.cPBVMemoAScDigest,PurBillVouch.dPBVDateASdVouchDate,PurBillVouch.cPBVBillTypeAScVouchType,PurBillVouch.cPBVCodeAScVouchID,PurBillVouch.cPBVMaker,PurBillVouch.cPBVVerifierAScCheckMan,PurBillVouch.cPayCode,PurBillVouch.cexch_name,PurBillVouch.cExchRateASiExchRate,PurBillVouchs.cInvCode,PurBillVouchs.iSumASiAmount,PurBillVouchs.iOriSumASiAmount_f,PurBillVouchs.iTotalASiFmount,PurBillVouchs.iOriTotalASiFmount_f,PurBillVouchs.iPBVQuantityASiAmount_s,PurBillVouchs.iCostASiprice,PurBillVouchs.iTaxPriceASino_id,PurBillVouch.dSDate,bNegativeasbd_c,bpayment,bFirst,bOriginal,cClue,iNetLockFROM((((((((((((PurBillVouchLEFTJOINAp_VouchTypeONPurBillVouch.cPBVBillType=Ap_VouchType.cTypeCode)LEFTJOINVendorONPurBillVouch.cUnitCode=Vendor.cVenCode)LEFTJOINDepartmentONPurBillVouch.cDepCode=Department.cDepCode)LEFTJOINPersonONPurBillVouch.cPersonCode=Person.cPersonCode)LEFTJOINPayConditionONPurBillVouch.cPayCode=PayCondition.cPayCode)INNERJOIN(PurBillVouchsLEFTJOINInventoryONPurBillVouchs.cInvCode=Inventory.cInvCode)ONPurBillVouch.PBVID=PurBillVouchs.PBVID)LEFTJOINPayConditionASPayCondition_1ONVendor.cVenPayCond=PayCondition_1.cPayCode)LEFTJOINVendorClassONVendor.cVCCode=VendorClass.cVCCode)LEFTJOINVendorasVendor_1ONVendor.cVenHeadCode=Vendor_1.cVenCode)LEFTJOINDistrictClassONVendor.cDCCode=DistrictClass.cDCCode)LEFTJOINDepartmentasDepartment_1ONVendor.cVenDepart=Department_1.cDepCode)LEFTJOINPersonasPerson_1ONVendor.cVenPPerson=Person_1.cPersonCode)LEFTJOINInventoryClassONInventory.cInvCCode=InventoryClass.cInvCCode

本文链接：https://www.bbsufida.com/u8/39381.html