cVouchType and cProcStyle<>’XJ’ And cFlag=’AP’ delete from ap_closebill where" />
發(fā)布時(shí)間:2024-11-18
問(wèn)題現(xiàn)象:
采購(gòu)管理模塊有一張采購(gòu)發(fā)票棄審不了(2008-4-30的發(fā)票,發(fā)票號(hào);0000002),已經(jīng)取消結(jié)算和核銷了.但在”付款結(jié)算單列表”里還可以看得到結(jié)算號(hào)為0000000061,奇怪的是在取消操作里找不到這個(gè)核銷單。
解決方法:
雖然發(fā)票取消了結(jié)算和核銷,但數(shù)據(jù)庫(kù)里的記錄未清除徹底,delete From AP_Detail Where cCoVouchType =’02′ And cCoVouchID=’0000002′ And cProcStyle<>cVouchType and cProcStyle<>’XJ’ And cFlag=’AP’ delete from ap_closebill where cvouchid=’0000000061′。
客服電話:400-665-0028
關(guān)鍵字:用友財(cái)務(wù)軟件,暢捷通軟件,財(cái)務(wù)軟件,進(jìn)銷存軟件,U9官網(wǎng),用友U8,用友T1,用友T+,用友T3,用友T6,暢捷通好會(huì)計(jì),好生意,智+好業(yè)財(cái),用友培訓(xùn)服務(wù)售后公司,暢捷通運(yùn)營(yíng)培訓(xùn)服務(wù)公司
版權(quán)所有:用友暢捷通軟件 Copyright © 2025 All rights reserved.