問題現(xiàn)象：用友U8年結(jié)問題之供銷鏈年度結(jié)轉(zhuǎn)，結(jié)轉(zhuǎn)到存貨明細賬時，提示存貨結(jié)轉(zhuǎn)失?。?/p>

問題原因：輔助計價表ia_valuationass有問題，存在出庫和入庫金額都為null的記錄，可用以下語句查詢：select * from ia_valuationass where iIPrice is null and iOPrice is null

解決方法：根據(jù)存貨明細賬ia_subsidiary，修改輔助計價表ia_valuationass，可參考以下語句：select * from ia_subsidiary  where id in (select inid from ia_valuationass where iIPrice is null and iOPrice is null)  and cvoutype not in ('24','30')