k3固定資產(chǎn)折舊問題專題講解(存儲版)
【正文】 m where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABalCard where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABaldevice where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABalfor where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABaldept where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_FABalexpense where fbalid in (select fbalid from t_fabal_hetemp ) delete from t_fabalance where fbalid in (select fbalid from t_fabal_hetemp ) update t_systemprofile set fvalue=0 where fcategory=‘fa’ and fkey=‘closed‘— 初始化 update t_systemprofile set fvalue=1 where fcategory=39。fa‘ select * from t_fabalance where fperiod=1 and fyear=2022 select * from t_faalter where fperiod=0 select * from t_faalter where fnew=1 找出問題的解決方法 一個基本問題：把數(shù)據(jù)反到初始化期間，但是根本沒有初始化記錄，如何反。,faltdate=39。 where fperiod=0 update t_fabalance set fdate=39。 where fcategory=39。初始化 案例一 帳套： 案例二 ：固定資產(chǎn)在計提折舊時出現(xiàn)“科目沒有權(quán)限 ,5(5H)的錯誤代碼”提示 只要是科目沒有權(quán)限，或核算項目無權(quán)限，則一定是t_fabalexpense,或 t_faexpense中的 facctid（ fdetailid)對應(yīng)的科目 (核算項目）在科目表（ t_itemdetail)不存在或已禁用，或不是最明細 問題定位 案例二 找出問題的根本原因 求證問題 select * from t_faexpense where facctid=1070無記錄
高考資料相關(guān)推薦
鄂ICP備17016276號-1