服务热线:020-82116603

常识库

新皇冠威尼斯+销售发票审核不了

发布于:2018-01-21 20:58:06

问题现象:现结销售发票审核时提示“发票已经被审核”,经查找原因为:实际发票并没有审核过,Ap_CloseBill表中ccancelman字段;salebillvouch中的bpayment字段 出现重复 解决方案:-- 检查、修改ufsystem SELECT * FROM ufsystem..UA_Identity WHERE (cAcc_Id = '004') AND (cVouchType = 'xj') update ufsystem..UA_Identity set ifatherid=(SELECT max(ccancelno) FROM ufdata_004_2004..ap_closebill) WHERE (cAcc_Id = '004') AND (cVouchType = 'xj') update ufsystem..UA_account_sub set bclosing=1 where cacc_id='004' and (csub_id='AR' or csub_id='SA') AND iyear=2003 --修改AP_Closebill update a set ccheckman=null from ap_closebill a,salebillvouch b where b.bpayment=a.ccancelno and b.bpayment is not null and b.cVerifier is null and a.cCheckMan is not null 注意做好帐套数据备份!!

澳门皇冠威尼斯人常识

澳门皇冠威尼斯人App 为您提供最优质的产品和服务

产品报价:

详情请咨询澳门皇冠威尼斯人:020-82116603

XML 地图 | Sitemap 地图