发票现结后不能审核,审核后不能现结-用友U8

对应版本:用友U8.50对应产品线：供应链对应模块：销售管理模块问题现象:发票现结后不能审核,审核后不能现结问题原因：数据库存相关表出现问题解决方案：解决:(1)SELECT*FROMufsystem..UA_IdentityWHERE(cAcc_Id=’009’)AND(cVouchType=’xj’);(2)updateufsystem..UA_Identitysetifatherid=(SELECTmax(ccancelno)FROMufdata_009_2004..ap_closebill)WHERE(cAcc_Id=’009’)AND(cVouchType=’xj’);(3)updateufsystem..UA_account_subsetbclosing=1wherecacc_id=’009’and(csub_id=’AP’orcsub_id=’PU’)ANDiyear=2003;(4)updateasetccheckman=nullfromap_closebilla,PURbillvouchbwhereb.bpayment=a.ccancelnoandb.bpaymentisnotnullandb.CPBVVerifierisnullanda.cCheckManisnotnull

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