用友u8科目類型顯示異常
:用友u8科目類型顯示異常 :數(shù)據(jù)結(jié)轉(zhuǎn)到2019年之后,查詢科目余額表發(fā)現(xiàn)損益類科目和負(fù)債類科目部分在資產(chǎn)類里面統(tǒng)計(jì)數(shù)據(jù),查詢科目發(fā)現(xiàn)本來(lái)是負(fù)債的,科目類型為資產(chǎn)。
:首先做好數(shù)據(jù)備份,然后執(zhí)行下面腳本,腳本會(huì)分別將現(xiàn)在賬套里1開頭的科目全部置為資產(chǎn),2開頭的置為負(fù)債,依次類推。執(zhí)行后請(qǐng)仔細(xì)檢查科目是否正確。
update AA_Account set idaccounttypeDTO=6 where code like '1%' and accountingyear='2019'
update AA_Account set idaccounttypeDTO=7 where code like '2%' and accountingyear='2019'
update AA_Account set idaccounttypeDTO=8 where code like '3%' and accountingyear='2019'
update AA_Account set idaccounttypeDTO=9 where code like '4%' and accountingyear='2019'
update AA_Account set idaccounttypeDTO=10 where code like '5%' and accountingyear='2019'
上海企通數(shù)字科技有限公司,用心打造企業(yè)數(shù)字化!連續(xù)13年蟬聯(lián)用友全國(guó)TOP10服務(wù)商,專業(yè)銷售服務(wù)暢捷通、用友u8、用友NC等軟件,歡迎咨詢,咨詢熱線:400-820-8720,網(wǎng)址:http://www.cotong.com/