用友U8软件中应收单据不能录入？
问题现象：在用友U8erp系统中用友U8版本号：U8软件的财务系统产品线应收模块出现如下问题：应收单据不能录入请帮忙解答！原因分析：因为数据库中的两个视图有错误。
解决方案：在用友erp 系统版本U8软件中可以把正确的视图复制过来，重新创建，具体的脚本如附件。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。
用友U8ERP软件免费下载地址截止2016年已发布的版本全部在下方，安装教程请认真参考：http://www.yyrjxz.com/xue/u8azjc.html 进行安装。
1、用友MERPu811软件免费下载地址：http://www.yyrjxz.com/yongyou/MERPU811.1.html
2、用友U82.0erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u8old820.html
3、用友U83.0erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u8old830.html
4、用友U852erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/U852.html
5、用友U860erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u860.html
6、用友U861erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u861xz.html
7、用友U870erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u870.html
8、用友U872erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u871.html
9、用友U82.0erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/U872.html
10、用友U890erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u890.html
11、用友U810.0erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/U810.0.html
12、用友U810.1erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/U8V10.1.html
13、用友U811.0erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/U8V11.0.html
14、用友U8+v11.1erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/U8V11.1.html
15、用友U8+v12.0erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u8120.html
16、用友U8+v12.1erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u8121.html
17、用友U8+v12.5erp软件免费下载地址：http://www.yyrjxz.com/yongyouu8/u8125.html
页:
[1]