問(wèn)題現(xiàn)象：用友U8 存貨記帳找不到倉(cāng)庫(kù)？

問(wèn)題原因:存貨核算方法為按存貨核算,IA_Summary中倉(cāng)庫(kù)多記錄 解決方法:存貨核算方法為按存貨核算,期末處理后存貨記帳找不到倉(cāng)庫(kù),編寫腳本處理;use ufdata_111_2009 --查詢出倉(cāng)庫(kù)不為空的記錄 SELECT * FROM ufdata_111_2009..IA_Summary WHERE (NOT (cWhCode IS NULL)) --修改倉(cāng)庫(kù)為空 update IA_Summary set cwhcode=NULL